Extract & process invoices with Gemini AI, Google Sheets & Gmail notifications
Ready for 3.0What this workflow does
This AI workflow has 16 nodes and runs when a chat message arrives. Along the way it connects Google Gemini, Google Gemini Chat Model, Google Sheets and Google Drive and 1 more.
How it runs
Trigger: When a chat message arrives.
- Analyze image (Google Gemini): analyze (image)
- Upload invoice to drive (Google Drive): uses Google Drive
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model
- Make data in json structure format (Edit Fields (Set)): sets 1 field: output
- Get data (Google Sheets): uses Google Sheets
- check if Data exist or not in table (If): checks a condition and branches into true / false
- New data add using payload (Code): runs custom JavaScript code
- Duplicate entry send mail (Gmail): uses Gmail
- Check Mandatory fields (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
…plus 4 more steps. See the full node list below.
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 (10)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Google Drive
n8n-nodes-base.googleDrive - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail
From the author
AI-Powered Invoice Extraction & Automation System Workflow Aim The aim of the Invoice Data Automation workflow is to streamline invoice processing by extracting, validating, and storing invoice details automatically. It uses AI to read invoices (from…