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.

🚀 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
  

Note: PRO Bundles discussed in the youtube video are not being produced anymore.