Menu

1 / 3

I built an AI agent that turns Gmail receipts into a spreadsheet — automatically

DEV Community·John Dreic·6 months ago
#hjsuzWM7
#ai#agents#automation#productivity#agent
Reading 0:00
15s threshold

Are you sitting on a stack of receipts you've been meaning to deal with? I was too. Here's how I fixed it once and for all.

I had an inbox full of them. Subscriptions, hotels, that one cab in Lisbon — all the SaaS I forgot I subscribed to. My accountant wanted them in a spreadsheet. My bookkeeping app wanted the PDFs. I didn't want to deal with any of it.

Now when a receipt lands in my Gmail, an AI agent spots it, looks at the PDF, pulls out the vendor, date, amount, and category, and writes a row to a Google Sheet. The original PDF gets filed away in a Drive folder. I never have to think about it again.

The receipts test

I gave it a five-page PDF with four real receipts and one deliberately scrappy one — a half-faded "Joe's Cafe £8.50" with no clear date.

Four went straight to a "Ready to post" tab — Office World, Figma, Bianca Bistro, Paddington Hotel — vendor, date, amount, all clean. The Joe's Cafe one landed in a "Needs review" tab with a note saying the date was unclear.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.