A lightweight workflow that automatically converts actionable emails into structured task data using Zapier’s free tier.
This project demonstrates clear automation logic, operational workflow design, and the fundamentals needed for AI-enabled process automation.
Many teams receive tasks by email, but inboxes are unstructured and hard to track.
This automation solves that by:
- Watching Gmail for emails containing task-related keywords
- Extracting relevant information
- Logging each task into a structured Google Sheet
This creates visibility, reduces cognitive load, and forms a foundation for more advanced AI-driven workflow automation.
Task requests arrive in email with no structure, no categorization, and no tracking.
Operations teams waste time manually logging tasks or, worse, lose visibility entirely.
Create an automation that:
- Identifies actionable emails
- Extracts structured data
- Logs the information to a central source of truth
- Works entirely on free-tier tools
- Demonstrates clean automation design for portfolio purposes
- Zapier (Free Tier)
- Gmail
- Google Sheets
App: Gmail
Event: New Email Matching Search
Search Query: