Module 04Lesson 2

Lesson 2. Your First Zap: Automation Without Code

Hands-on: Zapier

Lesson 2. Your First Zap: Automation Without Code#

Why This Matters#

Zaps are the foundation of Zapier. Once you learn to create Zaps, you can automate any routine task for clients.

Key Idea#

Zap = trigger + one or more actions

Every Zap follows simple logic: «When this happens → do that».

Zap structure: trigger → action
Zap structure: trigger → action

Example Task#

You have a contact form on your site. You want submissions to automatically go into a Google Sheet — without manual copying.

Breaking it down:

  • Which apps? Form (Google Forms) + spreadsheet (Google Sheets)
  • What starts the Zap? New form submission (trigger)
  • What does the Zap do? Adds a row to the spreadsheet (action)
  • What data to pass? Name, email, message text

Preparation#

Before creating the Zap:

  1. Create a Google Form with fields (Name, Email, Message)
  2. Submit a test entry (e.g., "Test User", test@test.com) — Zapier will use this data during setup
  3. Create a Google Sheet with labeled columns: Name, Email, Message, Source

Tip: use fictional names for tests (superheroes, characters) so you don't mix them up with real data.

Step 1: Setting Up the Trigger#

Choosing trigger app
Choosing trigger app

  1. Open Zap Editor (click "+ Create""Zaps")
  2. Select trigger app (Google Forms)
  3. Select trigger event — «New Form Response»
  4. Connect your Google account (Zapier will ask for authorization)
  5. Choose the specific form from the list

Choosing trigger event
Choosing trigger event

Note: trigger events vary by app. Google Sheets uses «New Spreadsheet Row», Telegram uses «New Message», Typeform uses «New Entry».

Step 2: Testing the Trigger#

Trigger test data
Trigger test data

  1. Click "Test trigger"
  2. Zapier will find the latest submission from your form
  3. Verify the data pulled correctly
  4. Click "Continue with selected record"

Important: Zapier only reads data when testing the trigger — it doesn't change anything in your form.

Step 3: Setting Up the Action#

  1. Select action app (Google Sheets)
  2. Select event — «Create Spreadsheet Row»
  3. Connect your Google account
  4. Choose the specific spreadsheet and sheet

Step 4: Field Mapping (Most Important!)#

Field mapping — connecting data
Field mapping — connecting data

Mapping is when you tell Zapier which data from the trigger goes where.

  1. You'll see your table fields (Name, Email, Message, Source) — that's why labeling columns matters!
  2. Click "+" or type "/" in a field — a list of trigger data will appear

Choosing data from trigger
Choosing data from trigger

  1. Choose which form data goes where:
    • «Name» field → form «Name» data
    • «Email» field → form «Email» data
    • «Message» field → form «Message» data
    • «Source» field → enter «Contact form» (fixed value)

Mapped fields with data
Mapped fields with data

Tip: what you see in the editor is test data. When the Zap runs, real form data will be used.

Step 5: Testing and Publishing#

Result: data in the table
Result: data in the table

  1. Click "Test step" — Zapier will actually perform the action
  2. Verify the row appeared in your Google Sheet
  3. If everything looks correct, click "Publish"

Important: when testing, the Zap really adds a row to the table. Use test data so you don't clutter real spreadsheets!

Zap Templates#

You don't have to create a Zap from scratch — the Zapier app directory has thousands of ready-made templates. Pick a template, connect your accounts, and adjust the details.

Common Mistakes#

Didn't test the trigger: no test data in the form
→ Submit at least one test entry

Didn't label columns: spreadsheet has no headers
→ Zapier can't figure out where to write data

Skipped testing: didn't verify the Zap works
→ Always test before publishing

Good Zap: clear trigger + correct mapping + tested