Track household expenses from receipts and emails into a spreadsheet
ChatGPT Work reads receipt photos, Gmail purchase emails and card notifications, sorts them into a spreadsheet and saves receipt images to Google Drive.
Done withChatGPT
- What they did
- The author connected Google Drive (which also covers Sheets), Gmail and optionally Google Calendar through ChatGPT's plugin settings. They photograph a receipt on an iPhone and send it to a pinned ChatGPT Work thread. The agent logs it in a spreadsheet and saves the image to Drive. A daily 9 PM scheduled Gmail check flags card notifications and purchase emails not yet organized.
- How it went
- Receipts are logged by photo alone, with a Drive link stored in each row. It cannot pull bank balances or card statement amounts automatically. The author also uses it to create invoices.
- Worth knowing
- Only one Google account can apparently be connected, so consolidate your purchase emails into a single address first.
Try it yourself with ChatGPT
Help me track household expenses. Read the receipt photos in [folder or upload], purchase emails in my [Gmail label], and card notifications in [source], then add each expense to a spreadsheet with date, merchant, amount, and category from [my categories]. Save receipt images to [Google Drive folder]. Show me the first 10 rows for approval before filling the rest, and don't delete or send anything.
Want help getting this working? Join the Vibe Coding Academy ↗ Run by Alex Finn, who also runs this site.
Source: note.com · Undated
Related use cases
Generate LEGO CAD models in LDraw with AI agents
A toolset and docs let ChatGPT and Claude agents write LDraw source files that become LEGO CAD models, packaged as a dockerized web app.
Turn spoken answers into a Todoist task list
Alexa sends spoken answers to ChatGPT, which organizes them into a formatted list of tasks for the household workflow.
Accelerate scientific research with Codex
A researcher uses Codex and ChatGPT extensively for scientific research, getting a week's work done in a day, though recent usage limits reduced output.
Shop for umbrella insurance through your personal agent
Personal AI agents use Coverage Cat's Agent API/MCP to size umbrella coverage and compare carrier options with price ranges, backed by a licensed broker.
Custom agent
File FSA reimbursement claims from invoice PDFs
Claude Code with the Chrome extension parsed Amazon invoice PDFs and spotted duplicates, but couldn't upload files and was slow, so the user had to step in.
Do taxes by selecting the right invoices
The poster says they used GPT Agent for their taxes, reading invoices and picking the right ones.
Get 5 like this every morning
The best things people got an AI agent to do, each with the prompt to try it.