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:
- A normal request with every field filled in.
- A request with no email.
- 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 doneThat third test probably logged "about 40" as text. That is a data hygiene problem. Hold on to it for Module 5.