lesson
45 min

Build Your First Automation

Build and test a form-to-sheet-to-email automation using practice data.

Objective

By the end of this lesson, you have a working automation that takes a form response, logs it in a sheet, and sends a confirmation email. You test it with fake data.

Practice data only

Build this first version with fake data and your own accounts. Do not connect your partner's real inbox or customer list yet. You will learn why in Module 6. For now, you are the customer.

The build: catering request intake

We use the taquería example. You can swap in your own partner.

Step 1: Make the form

Create a Google Form called "Catering Request (Practice)." Add these questions:

  • Name (short answer, required)
  • Phone (short answer, required)
  • Email (short answer)
  • Event date (date, required)
  • Guest count (number, required)
  • Notes (paragraph)

Step 2: Make the sheet

Create a Google Sheet called "Catering Log (Practice)." In row 1, type these headers: Received, Name, Phone, Email, Event date, Guests, Notes, Status.

Step 3: Set the trigger

In your tool, start a new automation. Choose Google Forms: New Response as the trigger. Connect your account and pick your practice form. Submit one test response so the tool can see the fields.

Step 4: Add the sheet action

Add Google Sheets: Add Row. Pick your practice sheet. Map each form field to its column. Set Status to the fixed text "New."

Step 5: Add a filter

Add a filter: only continue if Email is not empty. Some people leave email blank. Without the filter, the next step fails.

Step 6: Add the email action

Add Gmail: Send Email. Map Email to the To field. Write a short message:

Hi {Name}, we got your catering request for {Event date}. We will reply within one business day to confirm details.

Use the tool's field picker to insert Name and Event date. Do not type the braces yourself.

Step 7: Test three ways

Submit three practice responses:

  1. A normal request with every field filled in.
  2. A request with no email.
  3. A request with odd data, like a guest count of "about 40."

Check the sheet and your inbox after each one. Write down what happened.

My first automation works when

0 of 6 done

That third test probably logged "about 40" as text. That is a data hygiene problem. Hold on to it for Module 5.

Quiz: Module 3 check: building blocks

  1. 01In an automation, what does a filter do?

    Choose one.

  2. 02The confirmation email says 'Hi ,' with a blank. What is the most likely cause?

    Choose one.

  3. 03A busy shop owner with no tech help needs a simple two-step flow. Which tool fits best?

    Choose one.

  4. 04Why do you build the first version with fake data?

    Choose one.

  5. 05Which are good test cases for a new automation? Choose all that apply.

    Choose all that apply.