Invoice processor & validator with OCR, AI & Google Sheets
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) Text 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 - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Split Out
n8n-nodes-base.splitOut - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - Read/Write Files from Disk
n8n-nodes-base.readWriteFile - Extract from File
n8n-nodes-base.extractFromFile - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets
What it does
📝 Say goodbye to manual invoice checking! This smart workflow automates your entire invoice processing pipeline using AI, OCR, and Google Sheets. --- ⚙️ What This Workflow Does: 📥 1. Reads an invoice PDF — Select a local PDF invoice from your machine. 🔍 2. Extracts raw text using OCR — Converts scanned or digital PDFs into readable text. 🧠 3. AI Agent processes the text — Transforms messy raw text into clean JSON using natural language understanding. 🧱 4. Structures and refines the JSON — Converts AI output into a structured, usable format. 🔄 5. Splits item-wise data — Extracts individual invoice line items with all details. 🆔 6. Generates unique keys — Creates a unique identifier for each item for tracking. 📊 7. Updates Google Sheet — Adds extracted items to your designated sheet automatically. 📂 8. Fetches master item data — Loads your internal product master to validate against. ✅ 9. Validates item name & cost — Compares extracted items with your official records to verify accuracy. 📌 10. Updates results per item — Marks each item as Valid or Invalid in the sheet based on matching. --- 💼 Use Case: Perfect for businesses, freelancers, or operations teams who receive invoices and want to automate validation, detect billing errors, and log everything seamlessly in Google Sheets — all using the power of AI + n8n. > 🔁 Fast. Accurate. Zero manual work. --- OCR AI Invoices Automation.