Extract and validate invoice data with Google Gemini and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 11 nodes and runs when a chat message arrives. Along the way it connects Google Gemini, Google Sheets and Gmail.
How it runs
Trigger: When a chat message arrives.
- Analyze document (Google Gemini): work with document
- Code: runs custom JavaScript code
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Code: runs custom JavaScript code
- If: checks a condition and branches into true / false
- Append row in sheet (Google Sheets): append
- Code: runs custom JavaScript code
- Summarize: summarizes / groups the items
- Format Duplicate Alert (Gmail): uses Gmail
- Send a message (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - If
n8n-nodes-base.if - Summarize
n8n-nodes-base.summarize
From the author
Quick overview This workflow accepts an invoice file via an n8n chat trigger, uses Google Gemini to extract structured invoice data, validates it against an existing Google Sheets log, appends valid line items to the sheet, and sends a formatted confirmation…