PICKED FROM N8N.IO · FINANCE & ADMIN
On a schedule, the workflow reads recent Outlook messages from an accounts mailbox and classifies which are invoices from suppliers. It downloads attachments, uses Gemini vision to filter out non-invoices and extract the details, and appends each invoice to a Microsoft Excel 365 workbook.
Template by Jimleuk · 21.9k views on n8n.io · listed there as “Parse incoming invoices from Outlook using AI Document Understanding”
- DIFFICULTY
- Advanced
- NODES
- 18
- USES AI
- Yes
- PUBLISHED
- April 2025
001 / WHAT HAPPENS
- 01
A schedule trigger fetches recent messages from the accounts Outlook mailbox.
- 02
Each message is classified to decide whether it is a supplier invoice.
- 03
Attachments are downloaded and Gemini vision filters out documents that are not invoices.
- 04
Gemini reads each remaining invoice and extracts its details.
- 05
The extracted details are added as a row in an Excel 365 workbook.
WHO IT SUITS
Suits businesses on Microsoft 365 whose accounts mailbox receives supplier invoices as PDFs or images and who want them listed for reconciliation.
CONNECTS
- Microsoft Outlook
- Microsoft Excel 365
- Google Gemini
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 calls the Google Gemini API over HTTP, so a Google AI API key is needed and invoice content is processed by Google outside Australia.
- !Review extracted totals, GST and ABNs against the original invoices before posting anywhere.
- !Mailbox name, workbook and column mapping belong to the author and must be changed.
LOCAL SWAP
Swap the Excel node for the Xero node to create draft bills in Xero instead.
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 - 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→