I got into Zapier because a friend in sales was running his entire client pipeline out of a Microsoft Excel spreadsheet. No CRM. Just a spreadsheet, manual emails, and a lot of dropped balls. I taught myself Zapier from scratch in a week and built him something that actually worked. That turned into a bigger thing: building workflows that fit how people already work instead of asking them to change.
The Problem
The common thread across everything here is the same: tasks that are easy to forget and annoying to do manually. Follow-up emails, outreach tracking, lead logging. None of it is hard, but all of it is repetitive and prone to human error. The right automation makes those problems disappear.
My Approach
I don't start with tools. I start with the workflow. What's the trigger? What's the outcome? What's the user already doing that I shouldn't ask them to change? For most of these, the answer was to stay inside existing tools like Outlook and Excel. The automation should feel invisible.
Technical Implementation
Each automation below is a published Zapier template. They're modular, so you can copy any one to your own account and be running in under 10 minutes. Where AI is involved, I use OpenAI through Zapier's native integration to generate drafts without ever auto-sending anything.
Results
These are all in active use. The follow-up system has recovered conversations that would've gone cold. The AI drafting means every message sounds like a person wrote it, because the final call always is a person.
What I Learned
The best automation is one the user never thinks about. If someone has to remember to do something, the automation has already half-failed.
Automations
Microsoft OutlookMicrosoft ExcelOpenAI GPT-4.1Zapier
AI Follow-Up Reminder
Never let a lead go cold — AI-drafted follow-ups, always your call to send.
A friend of mine in sales was running his entire client pipeline out of a Microsoft Excel spreadsheet, manually tracking contacts and sending follow-up emails one by one. I'd never used Zapier before, so I spent a week learning it from scratch. By the end of that week I had something that monitored his outreach and automatically drafted follow-ups using GPT-4.1. He was genuinely thrilled, and it's still running. I've since adapted it for my own outreach too.
AI-written drafts
Each follow-up is generated by GPT-4.1 using the original subject line and recipient's name. No generic templates. Every draft reads like you wrote it.
Three escalating tiers
Day 3: a friendly nudge. Day 7: a more direct check-in. Day 14: a gracious close-out. Tone is tuned to each stage automatically.
Non-invasive by design
It never auto-sends anything. Every draft lands in your Outlook Drafts folder for you to review, edit, and send when you're ready.
Smart reply detection
Before drafting, the Zap checks whether the recipient has already replied. If they have, the sequence stops entirely. No awkward emails to someone who already got back to you.
Full Excel tracking
Every follow-up attempt is logged in your OneDrive spreadsheet with the stage and AI-generated draft, so you always know where each lead stands.
Setup
1.Copy the template to your Zapier account and connect your Microsoft Outlook.
2.Customize the email domain filter (e.g. @company.com) to scope which outgoing emails trigger the Zap.
3.Connect your OneDrive Excel spreadsheet — ensure it has columns for email, follow-up stage, and draft content.
4.Adjust delay intervals if needed (defaults: 3, 7, 14 days).
5.Connect your OpenAI API key. Default model is GPT-4.1 nano — swap to GPT-4o for richer output.
6.Send a test email to your target domain, verify the draft appears in Drafts, and confirm your spreadsheet updates.
7.Publish and forget — it runs silently in the background on every outreach email you send.
StripeNotionZapier
Stripe → Notion Revenue Tracker
Every payment logged automatically — your revenue dashboard updates itself.
Once Diet Decoder started processing real users, I needed a way to keep tabs on revenue without opening Stripe every time I wanted a number. I already lived in Notion, so I built this to pipe every new Stripe payment directly into a Notion database — amount, customer, timestamp, all of it. Now my revenue dashboard updates the moment a payment lands, and I never have to manually log anything.
Instant logging
Every new Stripe payment triggers the Zap immediately — no polling, no delays. Your Notion tracker reflects the current state of your revenue in real time.
Structured records
Each entry captures payment amount, currency, customer email, payment ID, and timestamp — cleanly mapped to Notion database properties.
Zero manual input
Once set up, you never touch it. Payments flow in, Notion updates, and your revenue history builds itself passively in the background.
Works for any Stripe product
Whether you're running a SaaS, a one-time product, or a freelance invoice setup, the trigger fires on any successful charge — no product-specific config needed.
Setup
1.Copy the template and connect your Stripe account. Zapier needs read access to payment events.
2.Connect your Notion account and select (or create) the database you want to track revenue in.
3.Map the Stripe fields to your Notion columns — at minimum: amount, customer email, and created date.
4.Run a test with a real or test-mode Stripe payment to confirm the row appears correctly in Notion.
5.Turn on the Zap. Every future payment logs automatically.
GmailGoogle SheetsZapier
Gmail → Job Application Tracker
Log every application automatically the moment you hit send.
Internship recruiting season is a spreadsheet nightmare — dozens of applications, different timelines, and no good way to remember what you sent where. I built this during my own job search because I kept losing track of which companies I'd reached out to and when. Now every email I send to a recruiter or company automatically gets logged to a Google Sheet with the subject, recipient, and timestamp. I open the sheet and my entire pipeline is already there.
Auto-logs on send
The Zap triggers the moment a matching email leaves your Gmail outbox — no copy-pasting, no manual entry, no forgetting.
Domain or label filtering
Scope it to specific email patterns or Gmail labels so only job-related emails trigger the Zap. Keeps your tracker clean and focused.
Full pipeline visibility
Each row captures company name (parsed from recipient), subject line, send date, and email address — everything you need to follow up intelligently.
Works with any outreach style
Cold emails, referral requests, recruiter replies, follow-ups — if it's in your Sent folder and matches the filter, it gets logged.
Setup
1.Copy the template and connect your Gmail account. The trigger watches your Sent folder for outgoing emails.
2.Set up a filter — either a Gmail label you apply to application emails, or a keyword in the subject line (e.g. 'application', 'internship', 'role').
3.Connect your Google Sheets account and select (or create) your tracking spreadsheet.
4.Map Gmail fields to sheet columns: recipient email, subject, date sent, and any other fields you want.
5.Test by sending a matching email and confirming it appears as a new row in your sheet.
6.Turn on the Zap and let your pipeline track itself.