Extract invoice data from Google Drive to Sheets with Mistral OCR and Gemini
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Field Extractor (v1.8) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent
What it does
Extract data from any PDF or image invoice dropped in Google Drive directly into Google Sheets – powered by AI OCR. Free, fully modifiable n8n workflow. Optional add-ons for pro features. 🚀 What this template does Stop typing invoice data by hand. Drop a PDF or phone-snapshot into your Invoices Inbox folder in Google Drive and this n8n workflow will: Auto-OCR the document with the Mistral OCR API Match any fields you list in Row 1 of your Google Sheet (totally schema-agnostic) Append a clean, structured row – every time Works with both PDFs and images, in any language supported by Mistral. Template JSON included, ready to import into self-hosted or n8n Cloud 👀 Who’s this for? Freelancers & agencies processing client invoices Small finance teams on Google Workspace Anyone self-hosting n8n who wants an AI OCR flow without glue-code No coding skills required – but flow tweaking is possible for power users. 🛠 Upcoming PRO Add-Ons I am also working on PRO add-ons for this template: Add-On 1 – Error Handling & Alerts (ships Jul 2025)• Flags missing fields, branches to Email/Slack notification; prevents silent failures Add-On 2 – Auto-Currency Converter (ships Jul 2025)• Detects invoice currency symbol/code → converts Total into your base currency via a free FX API Add-On 3 – VAT / GST Breakdown (ships Jul 2025)• Extracts VAT number, net, tax rate, tax amount, gross – ready for EU/UK/AU filings To pre-order these please see: https://ysqander.gumroad.com/l/N8N-AI-Workflow-Invoice-Data-Extraction-LITE