PICKED FROM N8N.IO · FINANCE & ADMIN
When a new receipt lands in a Google Drive folder, the workflow reads its text using Mistral OCR. An OpenAI agent then organises the vendor, date, total and tax into set fields, and the result is added as a new row in a Google Sheet.
Template by Aemal Sayer · 20.1k views on n8n.io · listed there as “Receipt scanning & analysis workflow”
- DIFFICULTY
- Beginner
- NODES
- 7
- USES AI
- Yes
- PUBLISHED
- August 2025
001 / WHAT HAPPENS
- 01
A Google Drive trigger starts when a new receipt file is added to a folder.
- 02
The file is sent to Mistral OCR to extract the text.
- 03
An OpenAI agent structures the text into vendor, date, total and tax fields.
- 04
The structured data is appended as a row in Google Sheets.
WHO IT SUITS
Suits sole traders and small teams who photograph or scan receipts and want a simple expense list for the bookkeeper or tax time.
CONNECTS
- Google Drive
- Mistral AI
- OpenAI
- Google Sheets
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.
- !Mistral OCR is called over HTTP with an API key, and receipts are processed by an overseas provider, so mention it in your privacy policy.
- !Check that GST is captured correctly, since the template's tax field may not match Australian GST handling.
- !Folder ID and sheet columns belong to the author and must be replaced.
LOCAL SWAP
Swap the Google Sheets node for the Xero node to create expense or bill records 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 - 18 NODESAI
FINANCE & ADMIN
Parse Outlook invoice emails with AI vision into an Excel sheet
Microsoft OutlookMicrosoft Excel 365Google GeminiAdvancedby Jimleuk21.9k 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→