Extract Invoice Data from Google Drive to Sheets with AI OCR

This n8n workflow transforms invoice processing by automatically detecting new PDFs or images dropped into a designated Google Drive 'Invoices Inbox' folder. It leverages Mistral's OCR API to extract text from documents in any supported language, then uses Gemini to intelligently match and structure the data based on headers in the first row of your Google Sheets. The result is a clean, appended row with fields like date, vendor, amount, and more—no manual entry required.

Key benefits include massive time savings for freelancers, agencies, and small finance teams on Google Workspace. It's fully schema-agnostic, adapting to any invoice format without coding. Self-hosted or cloud-compatible, it's free to modify and scales effortlessly. Works with phone snapshots or scanned PDFs, eliminating data entry errors and enabling quick reconciliation.

Ideal use cases: Freelancers logging client payments, agencies tracking vendor bills, or businesses automating AP workflows. Upcoming pro add-ons (pre-order available) add error alerts, currency conversion, and VAT breakdowns for enterprise needs. Import the JSON template and activate in minutes for instant productivity gains.