Lab: Introduction to Zapier Automation
Build your first automated workflow (Zap) that connects Google Forms to email notifications — no coding required.
Lab Objectives
- Create a free Zapier account and navigate the dashboard.
- Understand Zapier terminology: Zaps, Triggers, Actions, and Filters.
- Build a Zap that sends an email notification when a Google Form is submitted.
- Test the Zap and verify it runs successfully.
- Explore multi-step Zaps and conditional logic.
Prerequisites
- A web browser (Chrome, Firefox, or Edge).
- A Google account (for Google Forms and Gmail).
- An email address for testing notifications.
Part 1: Zapier Terminology
Before building, understand the key concepts:
| Term | Definition |
|---|---|
| Zap | An automated workflow connecting two or more apps. Each Zap has a trigger and one or more actions. |
| Trigger | The event that starts a Zap. Example: "New form submission" or "New email received". |
| Action | What happens after the trigger fires. Example: "Send an email" or "Create a spreadsheet row". |
| Filter | A conditional step that only lets the Zap continue if certain criteria are met. |
| Task | Each time an action runs successfully, it counts as one task. Free plans have a monthly task limit. |
Part 2: Create a Zapier Account
- Go to zapier.com and click Sign Up.
- Sign up with your Google account or email address.
- Select the Free plan (100 tasks/month, 5 Zaps).
- Complete the onboarding questions (you can skip them).
- You should now see the Zapier dashboard with a Create Zap button.
Part 3: Create a Google Form
Create a simple form that will serve as the trigger for your Zap.
- Go to forms.google.com and click Blank form.
- Title the form: Security Incident Report.
- Add the following fields:
- Reporter Name (Short answer)
- Incident Type (Dropdown: Phishing, Malware, Unauthorized Access, Data Breach, Other)
- Severity (Multiple choice: Low, Medium, High, Critical)
- Description (Paragraph)
- Click the Send button and copy the form link — you will use it for testing later.
- Submit one test response now so Zapier can see sample data when you configure the trigger.
Part 4: Build the Zap
Step 1: Set up the Trigger
- In Zapier, click Create Zap.
- For the Trigger App, search for and select Google Forms.
- For the Trigger Event, select New Response in Spreadsheet.
- Click Continue and connect your Google account when prompted.
- Select your Security Incident Report form and its linked spreadsheet.
- Click Test Trigger — Zapier should find your test submission.
- Click Continue.
Step 2: Set up the Action
- For the Action App, search for and select Email by Zapier (or Gmail).
- For the Action Event, select Send Outbound Email.
- Click Continue.
- Configure the email:
- To: Your email address
- Subject:
Security Incident Report - [Severity](click the + button to insert the Severity field from the trigger) - Body: Include fields from the form:
New Security Incident Report Reporter: [Reporter Name] Type: [Incident Type] Severity: [Severity] Description: [Description] Submitted at: [Timestamp]
- Click Continue.
Step 3: Test and Publish
- Click Test Action — Zapier will send a test email using the sample form data.
- Check your inbox for the test email. Verify all form fields appear correctly.
- Click Publish Zap (or Turn on Zap).
- Your Zap is now live.
Part 5: Test the Live Zap
- Open your Google Form link in a browser.
- Submit a new response with realistic test data:
- Reporter: Jane Smith
- Incident Type: Phishing
- Severity: High
- Description: Received a suspicious email impersonating the CEO requesting a wire transfer. Email contained a spoofed domain.
- Wait 1–5 minutes (free plans check triggers every 15 minutes; you can manually trigger in the Zapier dashboard by clicking Run).
- Check your email inbox for the notification.
- In the Zapier dashboard, click Zap History to see the run log.
Record in your lab notebook:
- Screenshot of the Zap editor showing trigger and action configuration.
- Screenshot of the email received with the form data.
- Screenshot of the Zap History showing a successful run.
Part 6: Bonus – Add a Filter
Add a filter so the email only sends for High or Critical severity incidents.
- In the Zap editor, click the + between the trigger and action to add a step.
- Select Filter by Zapier.
- Set the condition: Severity → (Text) Contains → High.
- Click + Or and add: Severity → (Text) Contains → Critical.
- Click Continue and test with a "Low" severity submission — the filter should block it.
- Test with a "High" severity submission — the email should send.
Deliverables
- Screenshot of your Google Form with all fields configured.
- Screenshot of the Zap editor showing trigger and action steps.
- Screenshot of the notification email received with form data.
- Screenshot of the Zap History showing successful task completion.
- Screenshot of the filter configuration (bonus).
- A short written answer: Name two real-world cybersecurity workflows that could be automated with Zapier or a similar SOAR tool.
Zapier Free Plan Limits
- 100 tasks/month
- 5 Zaps (active workflows)
- Single-step Zaps only (plus filters)
- 15-minute trigger check interval
Popular Security Integrations
- Slack — Alert channels for incidents.
- Google Sheets — Log incidents to a spreadsheet.
- Jira / Trello — Create tickets from alerts.
- PagerDuty — On-call escalation.
- Webhooks — Connect to any API.
SOAR Connection
Zapier demonstrates the same principles as Security Orchestration, Automation, and Response (SOAR) tools:
- Orchestration — Connecting multiple tools together.
- Automation — Triggering workflows without human intervention.
- Response — Taking action based on events (alerts, notifications, tickets).
Enterprise SOAR tools (Splunk SOAR, Palo Alto XSOAR) work the same way but integrate with security-specific platforms.