Automation Recipe: Route Your Inbox Automatically with Zapier
For General Administrative Assistants ·
No Coding Required
Tools: Zapier + Gmail or Outlook | Time to build: 1-2 hours | Difficulty: Intermediate Prerequisites: Comfortable using ChatGPT or Claude for email drafting (see Level 3 guide: "Build a Correspondence Template System with ChatGPT")
What This Builds
Instead of manually sorting emails into folders, forwarding invoices to accounts payable, or flagging urgent items for your manager (all actions you do dozens of times per week), you'll have automated rules running in the background that handle these tasks the moment emails arrive. Set it up once; it runs forever.
Prerequisites
- A Zapier account (free tier works for 1-2 automations; $20/month Starter for more)
- Access to your email account (Gmail or Outlook)
- Permission to connect third-party tools to your work email (check with IT for work accounts)
The Concept
Zapier is a connector platform. It watches for a trigger ("a new email arrives that contains the word 'invoice'") and then performs an action ("forward it to accounting@company.com and label it 'Invoices'"). Each trigger → action pair is called a "Zap."
The analogy: it's like having a mail sorting robot that reads the subject line and routing slip on every email and automatically puts it in the right pile, without you touching it.
You don't write any code. You fill out a few fields in a form-like interface, click a button, and the automation is live.
Build It Step by Step
Part 1: Identify which emails to automate
Before building anything, spend 10 minutes listing 3-5 email actions you perform manually, repeatedly. Good candidates:
- "Every time I get an invoice from a vendor, I forward it to accounts@company.com"
- "Every time someone emails requesting a meeting, I label it 'Meeting Requests' so I don't lose it"
- "When the CEO's assistant emails something urgent, I immediately text/Slack my manager"
- "Every time I get a travel confirmation email from United Airlines, I label it 'Travel' and forward to my calendar"
Pick one to start. The simpler the trigger, the more reliable the Zap.
Part 2: Create your Zapier account
Go to zapier.com → click "Sign up for free" → use your personal or work email.
The free plan allows you to have 5 Zaps running simultaneously, with up to 100 tasks per month, enough for most automations. If you need more volume, the Starter plan is $20/month.
What you should see: The Zapier dashboard, a "My Zaps" page listing any automations you've created.
Part 3: Build your first Zap (email labeling + forwarding)
Click "+ Create Zap" in the dashboard.
Set the Trigger:
- In the Trigger box, search for "Gmail" or "Outlook" (whichever you use)
- Select "New Email" as the trigger event
- Click "Connect account" → authorize Zapier to read your email
- Set a filter: "Subject contains [keyword]" (e.g., "invoice") OR "From contains [vendor domain]" (e.g., "@vendor.com")
What you should see: Zapier shows you a sample email from your inbox that matches the filter, to confirm it's working.
Set the Action: 5. In the Action box, search "Gmail" or "Outlook" again 6. Choose "Add Label to Email" (for organizing) or "Send Email" (for forwarding) 7. For a forward: set "To" as the destination address (e.g., accounts@company.com), "Subject" as {{Subject}} (the original subject), and "Body" as "Forwarded by [your name]: {{Body}}" 8. Click "Test & Review" → Zapier runs the action on the sample email → confirm it worked
Turn on the Zap: 9. Click "Publish" → your Zap is live
What you should see: The Zap status shows "On" with a green indicator. From now on, every email matching your filter automatically triggers the action.
Part 4: Add a second Zap (Urgent Email Slack Notification)
This Zap watches for emails from specific VIP senders and immediately sends a Slack or Teams message to alert you, even if you're away from your inbox.
- Create a new Zap → Trigger: Gmail/Outlook "New Email"
- Filter: "From contains [vip-sender@company.com]" (add multiple if needed)
- Action: search "Slack" or "Microsoft Teams"
- For Slack: "Send a channel message" → Channel: your admin DM or a private channel → Message: "URGENT EMAIL from {{From}}: {{Subject}}"
- Connect your Slack account → Test → Publish
What you should see: When a VIP email arrives, you get an immediate Slack ping, even on your phone if you have Slack mobile.
Part 5: Build a library of 3-5 Zaps
The power compounds when you have multiple Zaps running. Suggested library:
| Zap | Trigger | Action |
|---|---|---|
| Invoice routing | Email subject contains "invoice" | Forward to accounts@; label "Invoices" |
| Travel confirmations | From: airlines/hotels | Label "Travel"; forward to your calendar email |
| VIP alert | From: [executive names] | Slack/Teams DM to yourself |
| Meeting requests | Subject contains "meeting request" | Label "Meeting Requests"; add to a task list (Zapier can create Planner/Asana tasks too) |
| Expense approvals | Subject contains "approved" + "expense" | Label "Approved Expenses"; forward to your tracking folder |
Real Example: An Automated Month
Before: You sort 40-50 emails per day manually. Vendor invoices go to 3 different accounting contacts depending on the vendor. Travel confirmations get buried until you need them. Urgent emails from the CEO get missed when you're in a meeting.
After: You have 4 Zaps running:
- All incoming invoices auto-forward to accounts payable with an "Invoice" label
- Travel confirmations auto-label "Travel" and auto-forward to your calendar app
- Emails from the CEO or CFO trigger a Slack ping to your phone
- Emails containing "action required" label as "Priority"
Setup: 1.5 hours to build all four Zaps.
Ongoing time spent on email routing: Near zero.
Time saved: 20-30 minutes per day in manual email triaging. Over a month, that's 8-10 hours.
What to Do When It Breaks
- Zap runs but emails don't match the filter → Check spelling in your keyword filter. Try a broader term. Test by sending yourself an email with the keyword and confirming the Zap triggers.
- The forwarding email looks wrong → Review the Action step in Zapier → check how you formatted the Subject and Body fields → retest.
- Zapier says "Task limit reached" → You've hit the free tier's 100 tasks/month limit. Upgrade to Starter ($20/month) or deactivate lower-priority Zaps.
- IT blocks the Zapier connection → Use Microsoft Power Automate instead, since it's the Microsoft equivalent built into M365, so IT is less likely to block it. The logic is identical (trigger → action); only the interface differs.
Variations
- Simpler version: Use Gmail's built-in Filters (Settings → Filters → Create new filter) for basic labeling and forwarding. No Zapier account is needed, but it is less flexible.
- Extended version: Connect Zapier to Microsoft Planner or Asana so that emails containing "action required" automatically create a task in your task manager with the email subject and sender. This turns your inbox into an auto-populating to-do list.
What to Do Next
- This week: Build your first Zap (invoice forwarding or VIP alert) and watch it work
- This month: Add 2-3 more Zaps until your top 5 repetitive email actions are automated
- Advanced: Connect Zapier to your calendar so incoming meeting requests can automatically create calendar event drafts waiting for your review
Advanced guide for General Administrative Assistant professionals. Zapier requires account creation at zapier.com. The free tier is sufficient for 1-5 Zaps. For M365 environments, Microsoft Power Automate (included in M365) is a supported alternative. Check with IT before connecting third-party tools to work email accounts.