Automated Gmail Invoice Extraction to Google SheetsAutomated Gmail Invoice Extraction to Google Sheets
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Invoice emails into a Google Sheet, automatically, every hour.
If you copy-paste invoices and receipts from Gmail into a spreadsheet, this one's for you. I built a small Google Apps Script that runs inside your own Google account. Each hour it finds new invoice and receipt emails and adds one row per email: date, vendor, invoice number, total, currency, due date and a link back to the email. PDFs get saved to a Drive folder.
Three rules I built it around:
1. Never guess. If the total isn't clearly labelled, the row is flagged "Needs review".
2. Never log the same email twice.
3. Read-only. It never changes or deletes your mail (it only adds one label).
The screenshot shows the output on 10 fictional sample emails. Spend by vendor and by month is on a Summary tab. Built with AI assistance and checked by hand.
Post image
Maksim's avatar
IDM logo
Great call on flagging ambiguous totals for manual review instead of hallucinating values. Label-based deduplication in Gmail works reliably for hourly triggers. Have you run into Apps Script 6-minute execution quotas when a batch has large PDF attachments, or do you stream downloads directly to Drive via blob references?
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started