PICKED FROM N8N.IO · FINANCE & ADMIN
Invoices arrive by Gmail attachment, a Google Drive folder or an upload form. The workflow reads the PDF text, has OpenAI pull out the invoice fields, and emails an approver. Approved invoices are added to Google Sheets, and rejected ones trigger a rejection email.
Template by Billy Christi · 14.3k views on n8n.io · listed there as “Automated PDF invoice processing & approval flow using OpenAI and Google Sheets”
- DIFFICULTY
- Advanced
- NODES
- 14
- USES AI
- Yes
- PUBLISHED
- May 2025
001 / WHAT HAPPENS
- 01
Three triggers watch Gmail attachments, a Drive folder and an upload form for new invoice PDFs.
- 02
The text is extracted from each PDF using a file extraction step.
- 03
An OpenAI agent pulls out the invoice details in a set format.
- 04
An approval email is sent and the decision is checked.
- 05
Approved invoices are added to Google Sheets, while rejected ones send a rejection email.
WHO IT SUITS
Suits a small finance team that receives invoices through several channels and wants a human sign-off before anything is recorded.
CONNECTS
- Gmail
- Google Drive
- Google Sheets
- OpenAI
- n8n Form
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.
- !Check the extracted amounts, GST and ABN fields against real invoices, because the AI prompt may not capture Australian tax details.
- !Scanned or image-only PDFs may return no text, so test with the invoices your suppliers actually send.
- !Sheet columns, folder IDs and approver emails are set for the original author and must be replaced.
LOCAL SWAP
Swap the Google Sheets node for the Xero node to create bills in Xero instead of rows in a sheet.
Need n8n and the AI hosted in Australia? →003 / MORE FOR FINANCE & ADMIN
- 14 NODESAI
FINANCE & ADMIN
Save Gmail invoice attachments to Drive and log them in Sheets
GmailGoogle DriveGoogle SheetsOpenAIIntermediateby Juan Carlos Cavero Gracia39.9k views - 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
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→