Extract invoice data to Google Sheets automatically

# Extract invoice data from Google Drive using OCR and AI, save to Sheets

This workflow automates the processing of incoming invoices by eliminating manual data entry and minimizing errors. It´s ideal for professionals who regularly handle digital documents and use Google Sheets for financial tracking.

## Who it´s for
- Accountants manually processing multiple invoices
- Finance departments in small and mid-sized businesses
- Freelancers tracking income and expenses via Google Sheets
- Companies automating primary document processing

## What the automation does
- Monitors a specified Google Drive folder for new invoice files
- Downloads each file and detects its type (document or image)
- Routes the file through Mistral AI’s OCR API based on MIME type
- Sends extracted text to a Google Gemini-powered agent for structured field extraction (invoice number, date, amount, etc.)
- Saves results into a designated Google Sheet
- Prevents duplicates by tracking processed file IDs across runs
- Supports both event-based (file created) and manual triggers

## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic based on file MIME types
- Integrations with Google Drive, Google Sheets, Mistral AI, and Google Gemini
- Basic textual guide for setup and adaptation

## Requirements for setup
- n8n instance with external API access
- Google account with Drive and Sheets APIs enabled
- Mistral AI API key
- Google Gemini API key
- Access to LangChain Agent (integrated into processing logic)

## Benefits and outcomes
- Fully eliminates manual data entry from PDFs and scans
- Reduces risk of errors in invoice processing
- Accelerates accounting and reporting workflows
- Ensures centralized data storage in Google Sheets
- Prevents duplication via file ID tracking
- Scales seamlessly with high document volumes
- Handles hybrid formats (scans, photos, PDFs)

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat