Monitor budget variance with Google Sheets, Gemini, Slack, and Gmail
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 15 nodes and runs on a schedule (every day at 09:00). Along the way it connects Gmail, Google Sheets, Google Gemini and Slack.
How it runs
Trigger: On a schedule (every day at 09:00).
- Retrieve Budget Data (Google Sheets): uses Google Sheets
- Retrieve Actual Spend Data (Google Sheets): uses Google Sheets
- Merge: merges the data from its input branches
- Calculate Budget Variance (Code): runs custom JavaScript code
- Add Status & Context Details (Edit Fields (Set)): sets 5 fields: processed_at, status_label, over_under…
- AI-Based Budget Analysis (Google Gemini): uses Google Gemini
- Extract AI Insights (Code): runs custom JavaScript code
- Check Variance Alert Condition (If): checks a condition and branches into true / false
- Send Budget Alert to Slack (Slack): uses Slack
- Set No-Alert Status (Edit Fields (Set)): sets 1 field: alert_sent
…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 (9)
- Gmail
n8n-nodes-base.gmail - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack
From the author
Quick overview This workflow runs daily to compare department budgets and actual spend from Google Sheets, calculates variance, uses Google Gemini to generate root-cause insights, sends Slack alerts when variance breaches a threshold, logs results back to…