The monthly receipt hunt, made easier

An AI-powered expense tracker that scans your Gmail for receipts, categorises every expense, and logs everything to a Google Sheet - so the most tedious part of being a freelancer takes care of itself.

Claude API

Gmail API

Google Sheets

The idea

Every month, the same ritual - scrolling back through emails hunting for the Spotify invoice, the Adobe renewal, the hosting bill. It's not hard, it's just relentless. I built this to kill that habit entirely. Connect your Gmail, pick a month, and Claude does the rest: reading every receipt email, pulling out the vendor, amount, date and category, and logging it all to a Google Sheet with a direct link back to the original email.

How it works?

  1. Connect Gmail via OAuth - no passwords stored

  2. Claude scans my inbox for the past month, identifying receipt and invoice emails

  3. Each one is read and categorised - Software, Hosting, Marketing, Travel, Meals, Professional Services, and more

  4. Everything logs to a Google Sheet automatically, one row per expense, with a link back to the source email

  5. I set this up as a scheduled task so it runs on the last day of the month for the existing month and creates a new tab for each month.

Limitations

I wanted Claude to download the receipts attached the email and add them to a dropbox folder. This wasn't do-able, and neither was taking a screenshot of the attachment. The best Claude could offer was a direct link to the email to download the attachment. So whilst this spreadsheet saves time, the manual task of downloading receipts still exists. I will continue to investigate further.