Extract invoice data from PDFs with Gemini AI to 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) AI Agent - get targeted elements from text1 (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (13)
- Compare Datasets
n8n-nodes-base.compareDatasets - Extract from File
n8n-nodes-base.extractFromFile - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Limit
n8n-nodes-base.limit - Gmail
n8n-nodes-base.gmail - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
What it does
📄 Automated Invoice Processing (n8n + AI + Google Workspace) This workflow automates the extraction and processing of invoice data from PDFs stored in a Google Drive folder. It leverages Google Drive, Google Sheets, and Gemini AI to streamline invoice management. Key Features - Automatic Detection: Monitors a Google Drive folder for new invoices. - AI-Powered Extraction: Uses Gemini AI to extract structured data including Supplier, Buyer, Items, Total Amount, Tax, and Payment Terms. - Data Logging: Appends extracted invoice information to a Google Sheet and tracks processed documents to avoid duplicates. - Notifications: Sends email alerts once invoices are successfully processed. - Flexible & Extensible: Can be integrated with ERP/CRM systems, Slack/Telegram notifications, or OCR for scanned PDFs. 💡 Perfect for: Small to medium businesses, accountants, and operations teams looking to reduce manual invoice data entry and improve accuracy.