PICKED FROM N8N.IO · FINANCE & ADMIN
The workflow watches Gmail for unread emails with attachments, saves the PDFs to a Google Drive folder and renames them. OpenAI then reads each invoice and records the date, description and amount in a Google Sheets reconciliation sheet, so you keep both the file and a running list.
Template by Juan Carlos Cavero Gracia · 39.9k views on n8n.io · listed there as “Invoices from Gmail to Drive and Google Sheets”
- DIFFICULTY
- Intermediate
- NODES
- 14
- USES AI
- Yes
- PUBLISHED
- February 2025
001 / WHAT HAPPENS
- 01
A Gmail trigger starts on unread emails and checks that they have attachments.
- 02
The PDF is uploaded to a Google Drive folder, then renamed and moved to the right place.
- 03
Text is extracted from the PDF file so it can be read by the AI.
- 04
OpenAI pulls out the invoice date, description and amount using set extraction rules.
- 05
A new row is appended to the Google Sheets reconciliation sheet with the extracted details.
WHO IT SUITS
Suits a small business that gets supplier invoices by email and wants a tidy Drive folder and a running list for the bookkeeper.
CONNECTS
- Gmail
- Google Drive
- Google Sheets
- OpenAI
002 / BEFORE YOU USE IT HERE
- !Customer or staff details sent to an overseas AI provider such as OpenAI is a cross-border disclosure under APP 8 of the Privacy Act, so say so in your privacy policy.
- !It saves every email attachment it sees, so check that the invoice filter works on your inbox and does not file unrelated PDFs.
- !Folder IDs, sheet name and column names in the Setup node are set for the author and must be replaced.
- !Amounts are recorded as the AI reads them, so check currency and GST treatment against the invoice before reconciling.
LOCAL SWAP
Swap the Google Sheets node for the Xero node to send the extracted details to Xero as a draft bill.
Need n8n and the AI hosted in Australia? →003 / MORE FOR FINANCE & ADMIN
- 18 NODESAI
FINANCE & ADMIN
Parse Outlook invoice emails with AI vision into an Excel sheet
Microsoft OutlookMicrosoft Excel 365Google GeminiAdvancedby Jimleuk21.9k views - 7 NODESAI
FINANCE & ADMIN
Scan receipts in Google Drive and log them to Google Sheets
Google DriveMistral AIOpenAIGoogle SheetsBeginnerby Aemal Sayer20.1k views - 14 NODESAI
FINANCE & ADMIN
Extract invoice data with AI and approve it by email into Sheets
GmailGoogle DriveGoogle SheetsOpenAIAdvancedby Billy Christi14.3k views
004 / QUESTIONS
Anything else is quicker to answer on a call. Thirty minutes, free, with the people who would build it.
Yes. Every template on this list is free on n8n.io. You need an n8n account (n8n Cloud or self-hosted) and accounts for the apps it connects to, some of which charge for API use.
We adapt templates to your systems, add approval steps where customers are involved, host n8n in Australia when the data calls for it and hand it over documented.
Book a free call→