Gmail invoices and receipts logged into a Google Sheet automatic
Portfolio project

The problem. Small businesses get invoices and receipts by email, then someone copies each one into a spreadsheet by hand. It's slow and things get missed.
What I built. A Google Apps Script that runs every hour inside the client's own Google account. It finds new invoice and receipt emails in Gmail and adds one row per email to a Google Sheet with the date, vendor, invoice number, total, currency, due date and a link back to the email. PDF attachments are saved to a Drive folder, and each processed email gets a "Logged" label.
How it stays accurate. It only reads labelled totals (Total due, Amount due, Grand total), never subtotals or tax lines. It never logs the same email twice. Anything it can't read clearly is highlighted as Needs review instead of guessed. A Summary tab totals spend by vendor and by month.
Testing. The parser was tested on 17 sample emails covering USD, CAD, GBP and EUR. The image shows its real output on 10 of them, including one flagged for review.
No subscription, no third-party app, and no passwords shared. Fictional demo data. Built with AI assistance and checked before hand-off.
0 likes · 0 views · Nov 20, 2026
Hourly Apps Script logs Gmail invoices and receipts into a Google Sheet with vendor, invoice #, total and due date. PDFs to Drive. Fictional demo.