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”

THE WORKFLOW18 NODES
{}Split AttachmentsMDownloadAttachments≡Parse OutputSFor Each Message–Message Ref✦MessageClassifier▭Extract from FileMMarkdown≡Empty Response⏸︎Wait▽Filter Invoices⑂Has Invoice?◷Schedule TriggerMGet RecentMessagesLModelMMicrosoft Excel365↯InvoiceClassifier With …↯File-Based OCRwith Gemini 2.0
DIFFICULTY
Advanced
NODES
18
USES AI
Yes
PUBLISHED
April 2025

001 / WHAT HAPPENS

  1. 01

    A schedule trigger fetches recent messages from the accounts Outlook mailbox.

  2. 02

    Each message is classified to decide whether it is a supplier invoice.

  3. 03

    Attachments are downloaded and Gemini vision filters out documents that are not invoices.

  4. 04

    Gemini reads each remaining invoice and extracts its details.

  5. 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? →

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→