From AI Made Simple · Episode 12
How to Build Your First AI Workflow
Automate a boring task in about 10 minutes — no coding required.
What is an AI workflow?
Trigger
Something starts it (e.g., a new email arrives)
AI Step
AI reads, summarizes, or sorts it
Action
The result goes somewhere useful (e.g., a spreadsheet)
Example we’ll build
When an invoice email arrives, AI pulls out the key details and adds them to a spreadsheet automatically.
What you need
- A free account on Zapier (zapier.com) or Make (make.com)
- A Gmail or Outlook email account
- A Google Sheet with 4 columns: Date | Vendor | Amount | Due Date
Step-by-step
Step 1 — Create a new workflow
In Zapier, click "Create" → "Zap". In Make, click "Create a new scenario".
Step 2 — Set the trigger
Choose your email app → "New Email" (or "Watch Emails"). Add a search word like "invoice" so it only runs on invoice emails. Connect your email account.
Step 3 — Add the AI step
Add a step and search for "AI" (e.g., AI by Zapier or a ChatGPT/OpenAI module). Paste this instruction:
AI instructionFrom this email, extract the vendor name, total amount, and due date. Reply only in this format: Vendor | Amount | Due Date.Map the email subject and body into the AI step.
Step 4 — Set the action
Add "Google Sheets → Add/Create Row". Pick your sheet and match each column to the AI’s answer.
Step 5 — Test it
Send yourself a sample invoice email and click "Test". If the result isn’t right, adjust the instruction and test again.
Step 6 — Turn it on
Publish or switch the workflow on. Done!
More workflows to try
Daily email digest → summary to your phone
Meeting notes → to-do list
Receipts → monthly spending summary
New video → blog + social media drafts



