Labeled Gmail attachments need to go into a spreadsheet
Incoming data files land in the spreadsheet automatically instead of requiring manual download and paste.
Track 6 · Advanced
6.1.3
Zapier
The largest app catalogue — the fastest first automation
1Overview
Founded in 2011 — the tool that made no-code automation mainstream, now used by more than three million businesses worldwide.
Zapier is the most widely adopted no-code automation platform: point-and-click "Zaps" that link 9,000+ apps, each one a trigger → action chain that fires automatically. It is the shortest path from "I do this by hand every week" to a working automation — pick Google Forms, pick Sheets, map the fields, switch it on. Since 2024–2025 it has added an AI Copilot builder, AI Agents, Zapier Tables and MCP support, so an assistant like Claude can trigger a Zap directly. → The catch is task-based billing: a five-step Zap costs five tasks per run, and the free tier is 100 tasks a month with two-step Zaps only.
1.1Before you start
1.2After this chapter you can
→Build a two-step Zap from a template and switch it on
→Know what counts as a "task" — and why multi-step Zaps get expensive
→Pick Zapier over n8n/Make when the app catalogue is what matters
→Recognise its limits: polling intervals, awkward branching, no self-hosting
1.3Best for
The largest app catalogue of any no-code tool, and the lowest barrier to a first win: form → sheet, email → task, Slack → tracker, mostly from a template, in minutes, with zero programming background.
1.4Watch out
Task-based billing escalates sharply — a 5-step Zap counts 5 tasks per run. Polling is 1–2 min at best, so it is not for real-time pipelines, and complex branching or data transformation is awkward next to n8n.
1.5Free vs paid
Free: 100 tasks/month, two-step Zaps only, 15-min polling. Professional $29.99/mo ($19.99 annual) for 750 tasks and multi-step Zaps. Team $103.50/mo ($69.50 annual) for 2,000 tasks and up to 25 users. Enterprise on request.
2Lessons 7
2.1 Create a two‑step Zap that moves new Google Form responses into a Google Sheet
A Zap is a trigger → action workflow built in the Zapier web UI.
You will have an automated pipeline that adds each new form submission as a row in a spreadsheet.
- Log into your Zapier account and click Create Zap.
- Select Google Forms as the trigger app, choose New Form Response and connect your Google account.
- Add Google Sheets as the action app, pick Create Spreadsheet Row, select the target sheet and map form fields to columns.
- Name the Zap, turn it on, and test with a fresh form entry.
- You'll see A new row appears in the chosen Google Sheet each time you submit the Google Form.
- Takeaway Mapping fields between apps lets you move data automatically without writing code.
2.2 Save labelled Gmail attachments into a Google Sheet
A Zap that watches Gmail for new messages with a specific label and adds parsed attachment data as rows in a Google Sheet.
Create an automated workflow that adds a spreadsheet row whenever a labelled email with an attachment arrives
- Click Create Zap to start a new workflow
- Select Gmail as the trigger app
- Choose the New Email Matching Search trigger and enter your label in the Search Query field (e.g., "label:Invoices")
- Add an action by clicking Add Action, then select Google Sheets
- Pick the Create Spreadsheet Row action
- Map the attachment data to the appropriate columns in the field‑mapping section and enable the Zap
- You'll see A new row appears in the chosen Google Sheet each time a matching email is received
- Takeaway Pairing triggers and actions removes repetitive manual data entry and keeps apps synchronised in real‑time
- Check Which Gmail trigger do you pick, and what decides which emails it matches?
2.3 Send Slack alerts for new Calendly bookings and record them in Google Sheets
A multi‑step Zap that reacts instantly to a Calendly booking, sends a formatted Slack message, and records the event in Google Sheets.
Build an automation that alerts your team in Slack and maintains a running log of bookings without any manual steps
- Click Make a Zap and set Calendly as the trigger app
- Choose Invitee Created from the Calendly options
- Click + Add Action, pick Slack, select Send Channel Message, and map date, time, attendee fields
- Click + Add Action, choose Google Sheets, select Create Spreadsheet Row, and map booking details to sheet columns
- Click + Add Step, pick Filter, and set the condition for a specific event type (optional)
- Use Test Zap for each step then toggle Turn on Zap
- You'll see Each time someone books through Calendly, a Slack channel receives an instant message with the booking details and a new row is added to your Google Sheet log
- Takeaway One trigger can drive coordinated updates across several tools keeping teams synchronised
- Check Which Calendly trigger event starts the Zap, and what two actions does one booking set off?
2.4 Insert an AI classification step before saving form data
Zapier AI actions let you run a model on data inside a Zap.
You will enrich each form response with an AI‑generated category that is stored in the sheet.
- Open the Zap from Lesson 1 and click + Add Step after the trigger.
- Choose Zapier AI as the app, select Run Prompt, and write a short prompt such as “Classify this feedback into Positive, Neutral or Negative”.
- Map the form’s text field to the prompt input, then add another Google Sheets action to create a row.
- Map both the original fields and the AI output (category) to columns, save and turn on the Zap.
- You'll see The spreadsheet now contains an extra column showing the AI‑assigned category for each submission.
- Takeaway AI actions can add intelligence to no‑code workflows, turning raw inputs into actionable insights.
2.5 Classify incoming support emails with AI and route them to Zendesk
A Zap that captures new support emails, uses an Anthropic AI step to determine urgency, then creates a Zendesk ticket with the appropriate priority tag.
Set up an automation that automatically tags and routes support requests based on AI‑generated classifications
- Create a new Zap and select Email by Zapier as the trigger, choosing “New Inbound Email”
- Add an Action step and pick Anthropic (Claude) – Classify Text, entering a prompt that labels the email as high, medium or low urgency
- Insert a Formatter step to convert the AI classification output into plain text if required
- Add another Action step, choose Zendesk – Create Ticket, map the email subject and body, and set the ticket priority using the classification result
- Run a test with sample emails and then enable the Zap
- You'll see When a new support email arrives, Zendesk creates a ticket whose priority matches the AI‑determined urgency
- Takeaway AI steps can enrich triggers with semantic insight, enabling smarter routing decisions without writing custom code
- Check What does the Claude step produce from the email, and which Zendesk field is set from it?
2.6 Set a restricted apps policy for your Zapier organization
App access policies control which third‑party integrations team members may use in Zaps.
You will configure an open‑policy with a list of restricted apps to tighten security while keeping most apps available.
- In Zapier, go to Settings → App Access Policies (available on Free, Professional, Team and Enterprise plans).
- Select the Restricted apps (open policy) option.
- Add any apps you want to block (e.g., a high‑risk CRM) by searching for them and clicking Add to restricted list.
- Save the policy and verify that a team member receives a notification when trying to add a blocked app.
- You'll see Attempts to use a restricted app in a new Zap are halted with a “step held due to the restricted app” notice.
- Takeaway Restricting apps lets you balance rapid innovation with governance by preventing unwanted integrations.
2.7 Enable Zap approvals so admins review new workflows before they run
Zap approvals add a gate where a designated reviewer must accept a Zap before it becomes active.
You will set up an approval step that requires admin sign‑off for any new or edited Zap in your account.
- Navigate to Settings → Approvals within the Zapier dashboard.
- Turn on Zap approvals, choose an approver (or a group) and define the notification method (email or Slack).
- Create a test Zap (e.g., a simple Gmail → Google Sheets flow) and attempt to turn it on.
- Observe that the Zap shows a pending status and wait for the designated approver to approve it before it runs.
- You'll see The test Zap remains inactive until an admin clicks Approve in the approval notification, after which it executes normally.
- Takeaway Approval workflows provide a safety net, ensuring that automated processes meet compliance and quality standards before they affect production data.
3You’ll know it worked 15 checkable outcomes in this chapter
- ✓A new row appears in the Google Sheet each time a labeled email with an attachment arrives
- ✓Team members see a Slack message with booking details immediately after a prospect schedules
- ✓Slack shows the celebration message and a new row appears in Sheets
- ✓Finance sees a daily Slack digest showing updated cumulative MRR after each Stripe event
- ✓Manager clicks approve link, HR sheet logs dates, employee gets confirmation email
- ✓Sales rep receives a Slack message with an edit link to the new PandaDoc proposal
- ✓Team lead sees low CSAT alerts in Slack within minutes of submission
- ✓A new support email instantly creates a Zendesk ticket that appears in the correct queue with the appropriate priority tag and team assignment
15 outcomes in all — one per recipe below.
4FAQ, Tips & How-to 17
one problem, one solution, one action
Internal tools & ops2
Tagging a Zendesk ticket as a bug
Support and engineering stay in sync without manual copy-paste; every filed bug has a Linear issue and agents can tell customers the issue number.
Booking & scheduling1
New Calendly booking happens
The whole team sees new bookings in real time so the right person can prepare.
Content & marketing2
New sign‑up forms don’t trigger welcome emails
New signups enter the nurture flow within seconds, improving first-impression timing.
Posting a job on three sites is slow
A role that took 30 minutes to post manually across three platforms is distributed in under a minute from a single Airtable record.
CRM & sales3
Closed-won deals aren’t announced or tracked
Wins are celebrated publicly and revenue is logged automatically — no hunting in the CRM for month-end numbers.
Deal reaches proposal stage and reps avoid copy‑paste
Reps skip the 20-minute copy-paste from CRM to proposal tool; the draft is ready to personalise in seconds after staging a deal.
Signature received but deal stays open
The gap between signature and CRM update disappears, and customer onboarding starts the same minute the contract is signed.
Commerce & payments2
Want automatic review requests
Review volume increases without any manual follow-up effort from the shop owner.
Failed card payments go unnoticed
Involuntary churn from failed card payments is reduced because recovery emails go out automatically within minutes, not days.
Dashboards & analytics1
Can’t keep revenue up to date
MRR and churn are always up to date without anyone manually pulling Stripe reports, giving finance a live revenue view.
Forms, surveys & feedback2
Managers have to approve PTO manually
Leave approvals that required chasing managers by Slack and manually updating a spreadsheet are handled end-to-end in one automated loop.
Need timely CSAT after tickets close
CSAT collection is automatic and timely; every low score is visible to the team lead within minutes of being submitted.
Customer & client portals1
Support emails land in the wrong queue
Support emails land in the right queue within seconds, cutting first-response time and preventing high-priority issues from sitting unseen.
What counts as a 'task' in Zapier?
A task is each action step that Zapier completes successfully — if a Zap sends an email and creates a record, that run uses two tasks. Triggers and steps that are filtered out do not count. Because billing is task-based, an automation that fires often can consume your monthly allowance quickly, so it pays to filter early and avoid unnecessary action steps.
How quickly do Zaps run — is it instant?
It depends on the trigger. Many app triggers use polling, which checks for new data on an interval (every few minutes on higher plans, longer on lower ones), so a Zap is near-real-time but not always instant. Triggers that support 'instant' delivery use webhooks and fire immediately. If timing matters, check whether your trigger app offers an instant trigger.
When a form response arrives
By connecting OpenAI's DALL·E 3 API to Zapier, you can trigger automatic creation of images whenever a new response lands in Google Forms. The workflow saves the generated picture to Google Drive, turning text feedback into visual summaries.
The same set on /recipes, filtered by tool and role.
5Videos 3
Learning Zapier in 2026: AI Automation for Beginners
The most current single-video overview. Watch to see how much of Zapier is now AI rather than plumbing.
Zapier for Beginners: Build AI Automations Without Coding! Complete tutorial!
The clean beginner on-ramp. Start here to learn the trigger-action model before the agents video.
Zapier Agents: The Only Tutorial You'll Ever Need
The deep dive on Zapier's agent layer — watch when you want automations that act on their own, not just trigger-action Zaps.
6FAQ 2
What counts as a 'task' in Zapier?
A task is each action step that Zapier completes successfully — if a Zap sends an email and creates a record, that run uses two tasks. Triggers and steps that are filtered out do not count. Because billing is task-based, an automation that fires often can consume your monthly allowance quickly, so it pays to filter early and avoid unnecessary action steps.
How quickly do Zaps run — is it instant?
It depends on the trigger. Many app triggers use polling, which checks for new data on an interval (every few minutes on higher plans, longer on lower ones), so a Zap is near-real-time but not always instant. Triggers that support 'instant' delivery use webhooks and fire immediately. If timing matters, check whether your trigger app offers an instant trigger.
7Glossary 11 terms
Show the 11 terms
Zapier
Zap- One automated workflow in Zapier: a trigger plus one or more actions.
Trigger- The event that starts a Zap — a new email, a new spreadsheet row, a form submission.
Action- A step a Zap performs after the trigger — create, update, or send something in another app.
Multi-step Zap- A Zap with more than one action chained together (a paid-plan feature).
Task- One action that completes successfully. Zapier bills by tasks, so each action that runs counts.
Path- Conditional branching — different actions run depending on the incoming data.
Filter- A step that stops a Zap from continuing unless its conditions are met.
Formatter- A built-in step that reshapes data — dates, text, numbers — between other steps.
Copilot- Zapier's AI that builds a Zap for you from a plain-English description.
Agents- Zapier AI agents that carry out multi-step tasks such as research or data lookups.
Tables- Zapier's built-in database for storing and reading data inside your automations.
8See also
💬 Discuss this chapter
Ask, share, or report — over on the Heidelberg AI community forum.