← Back to Tools
Operations, Augmented

AI Automations

Three personal workflow builds running on Google Apps Script and the Gemini API, free tier only.

These are personal AI-automation builds, not client work, not a product, just workflows I got tired of doing by hand and decided to automate. All three run on Google Apps Script plus the Gemini API's free tier, so the total cost to build and run them is $0. It's the same idea behind everything else on this site: point AI at a real, recurring task and let it carry the repetitive part, while I stay in the loop on anything that actually matters.

Automation 01

Receipt-to-Spreadsheet Pipeline

Diagram of the receipt to spreadsheet automation workflow

Whenever a receipt lands in my Gmail, Gemini reads the email and pulls out the vendor, date, amount, and category, then logs it as a new row in a Google Sheet automatically. No forwarding receipts to myself, no typing numbers into a spreadsheet after the fact. It also sends me a weekly spending summary email, so I get a running read on where the money's actually going without ever opening the sheet myself.

Automation 02

Scheduled Research Digests

Diagram of the scheduled research digest automation workflow

Two separate digests run every morning, one for AI and Tech, one for Heart Health and Nutrition. Each pulls from a set of RSS feeds, and Gemini goes through what came in overnight, picks out the stories that are genuinely significant, and cuts anything that's a duplicate or a rehash of something I already saw. Then it emails me a clean summary, so I start the day with the signal instead of scrolling through a dozen feeds myself.

Automation 03

Inbox Triage Assistant

Diagram of the inbox triage assistant automation workflow

Gemini reads new unread mail in my Gmail and labels each one, Needs Reply, Urgent, Action Item, FYI, or Newsletter. For anything urgent, it drafts a reply, but it never sends anything on its own. I review every draft before it goes out. It's a triage layer, not an autopilot, it just means I'm not the one deciding what's worth my attention first.

Stack: Google Apps Script + Gemini API (free tier)  ·  Cost to build: $0