N8N + AI Invoice Data Extraction – Lite Template (Free)

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:

1. Auto-OCR the document with the Mistral OCR API
2. Match any fields you list in Row 1 of your Google Sheet (totally schema-agnostic)
3. 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.

🔧 What’s inside

• Google Drive Trigger – watches a specific folder for new files
• OCR pipeline (Mistral) – upload → signed-URL → document/image OCR
• Schema Auto-Detect – reads the header row in your Sheet and builds the extraction prompt dynamically
• Field Extractor (Gemini 2.5 Flash) – returns strict JSON (no hallucinations, no markdown)
• Google Sheets Append – writes the data + file ID to your chosen sheet
  

🛠 Upcoming PRO Add-Ons (pre-order-only price $9 each, first 20 copies, $19 each after that)

• 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
• Bundle (1 + 2 + 3) – $19 for first 20 buyers ($39 regular)• All three add-ons at a bigger launch discount
• If for any reason, I fail to ship these products, a full refund will be provided.

🤔 FAQ

Does this run on n8n Cloud? Yes. Any plan that allows custom credentials and HTTP Request nodes.

Do I need a subscription? You’ll need a Mistral API key and a pay as you go subscription (billing enabled) pricing is $0.001/page (https://mistral.ai/pricing#api-pricing) You will also need a Google Gemini API key for the Gemini 2.5 flash model. Pricing per 1m token is amongst the lowest in the industry - you will be paying <$0.001 per page (https://ai.google.dev/gemini-api/docs/pricing)

What happens if an invoice is processed twice? The base template skips files that already exist in the sheet (checks Drive ID).

Refund policy? Full refund within 30 days for paid items – no questions asked.

>> Download the FREE Lite template 📥

>> Lock in your PRO add-on discounts now before the price goes up 🔒