Track and analyze Google Sheets expenses with Gemini and Gmail alerts
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 13 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, Google Gemini and Gmail.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Read Expenses from Google Sheet (Google Sheets): uses Google Sheets
- Settings — Change These Before Running (Edit Fields (Set)): sets 17 fields: Budget Limit, Send Report To Email, Email Sender Name…
- Clean and Categorise Each Expense Row (Edit Fields (Set)): sets 5 fields: Expense Amount, Description Lowercase, Expense Date…
- Add Up Total Spent per Category (Summarize): summarizes / groups the items
- Build AI Prompt Fields (Edit Fields (Set)): sets 8 fields: Category Name, Total Amount Spent, Expense Status…
- Ask Gemini to Write Expense Report (Google Gemini): uses Google Gemini
- Collect Report Fields for Sheet and Email (Edit Fields (Set)): sets 12 fields: AI Report Text, Category Name, Total Amount Spent…
- Save Report to Sheet (Google Sheets): append
- Keep Data Alive After Sheet Write (Edit Fields (Set)): sets 12 fields: AI Report Text, Category Name, Total Amount Spent…
- Check Expense Level — High or Normal? (If): checks a condition and branches into true / false
…plus 2 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 (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Summarize
n8n-nodes-base.summarize - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail
From the author
Expense Leak Detector Smart Expense Monitoring in Minutes --- This n8n workflow reads your expenses from Google Sheets, categorizes them using predefined keywords, summarizes spending per category, generates AI-powered financial advice using Gemini, stores…