P
AI for Executive Assistant

Automation: Email-to-Task Workflow for Action Item Capture

For Executive Assistants

Tools: Zapier + Asana (or Notion) | Time to build: 1.5 hours | Difficulty: Intermediate-Advanced Prerequisites: Comfortable using ChatGPT for daily tasks — see Level 3 guide: "Build a Persistent EA Assistant with ChatGPT Projects"

What This Builds

Every email that arrives with an action item buried in it will automatically create a task in your project management tool — with the email subject, sender, and AI-extracted task description included. Instead of spending 15–30 minutes per day manually transferring email action items to your tracker, the system does it for you the moment the email arrives.

Prerequisites

  • Zapier account (free plan allows 5 Zaps; Starter plan $20/month for more)
  • Asana, Notion, or Trello account for task management
  • Gmail or Outlook account
  • Basic comfort with "if this, then that" thinking

The Concept

Zapier is like a set of automatic rules for your apps. Think of it as a staff member who sits between your email and your task manager: "Whenever an email arrives with certain words in it, create a task." You set the rule once; Zapier runs it forever.

The more advanced version adds an AI step: instead of just copying the email subject, the AI reads the email body and extracts the actual action item in plain language — "Follow up with vendor by Friday" rather than "Re: Re: Re: Q2 vendor meeting."

Build It Step by Step

Part 1: Create your Zapier account and connect your email

  1. Go to zapier.com and create an account (free tier works for testing)
  2. In the Zapier dashboard, click "Create Zap"
  3. For the Trigger (what starts the automation): search for and select "Gmail" or "Outlook"
  4. Choose the trigger event: "New Email" or "New Email Matching Search"
  5. Connect your Gmail or Outlook account by clicking "Sign in" and authorizing Zapier

What you should see: A trigger step showing "New Email in Gmail" with a green "Connected" indicator.

Part 2: Add a filter to catch only action-item emails

  1. After the Trigger, click the "+" to add a step — choose "Filter"
  2. Set the filter: "Continue if... Email Body... contains... [action required OR please follow up OR could you OR I need you to]"
  3. This ensures only emails with action language trigger the rest of the workflow — not every email

What you should see: A filter step with your keyword conditions listed.

Part 3: Add an AI step to extract the actual task

  1. Click "+" to add another step — search for "OpenAI" or "ChatGPT by Zapier"
  2. Choose the action: "Send Prompt"
  3. In the Prompt field, type:
Copy and paste this
Extract the action item from this email. Output only the action item as one sentence starting with a verb. If there are multiple action items, list each on its own line.

Email subject: [insert Subject field from Step 1]
Email body: [insert Body field from Step 1]
  1. Test this step — you should see the AI output a clean action item like "Schedule a follow-up call with the facilities team by end of week."

What you should see: The AI output field populated with a clean action item sentence.

Part 4: Create the task in Asana (or Notion/Trello)

  1. Click "+" to add a final step — search for "Asana"
  2. Choose action: "Create Task"
  3. Connect your Asana account
  4. Map the fields:
    • Task Name: [AI Output from Step 3]
    • Notes/Description: [Email Body from Step 1]
    • Assignee: Your Asana username
    • Due Date: Leave blank (or use a formula to set "7 days from now" as a default)
  5. Publish the Zap

What you should see: A complete Zap with 4 steps: Trigger → Filter → AI → Asana.

Part 5: Test and Refine

  1. Send yourself a test email containing "could you please follow up with the catering team about the Q3 offsite venue?"
  2. Wait 2–3 minutes, then check Asana — a task should appear
  3. If the AI extracted the wrong text or the task didn't appear, check the Zap history in Zapier to see which step failed

Real Example: Complete Workflow

Setup: Zap watches inbox for emails containing action language.

Input: An email arrives from your executive's chief of staff: "Subject: Board prep — [Executive name] — could you make sure the board deck is sent to all board members at least 48 hours before Thursday's meeting? Also, please confirm the conference room is booked."

Output: Two tasks appear in Asana:

  1. "Send board deck to all board members 48 hours before Thursday's meeting"
  2. "Confirm conference room booking for Thursday board meeting"

Time saved: 5 minutes of manual task capture, multiplied by 10–15 action emails per day = 50–75 minutes/day.

What to Do When It Breaks

  • The Zap isn't triggering → Check Zapier's "Task History" to see if the trigger fired; verify your email account is still connected (re-authenticate in Zapier)
  • AI is extracting the wrong thing → Edit the prompt in the AI step to be more specific; add "Focus on tasks assigned to the EA, not the executive themselves"
  • Tasks are being created for emails that aren't action items → Tighten the Filter keywords; add more specific phrases that appear in your actual action emails
  • Asana connection expired → Re-authenticate Asana in Zapier Settings → Connected Accounts

Variations

  • Simpler version: Skip the AI step — just create a task with the email subject line as the task name (faster to build, less accurate)
  • Extended version: Add a "Slack DM" step after Asana that sends you a message: "New task created from email: [task name]" so you're aware in real time

What to Do Next

  • This week: Build the basic version (no AI step) and let it run for 5 days
  • This month: Add the AI step once you're confident the basic version works
  • Advanced: Build a second Zap that emails you a morning digest of all tasks created in the last 24 hours

Advanced guide for Executive Assistant professionals. Zapier's interface and pricing may change.