Monitor company budgets with Bexio, Google Sheets 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 workflow has 19 nodes and runs on a schedule (every week). Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: On a schedule (every week).
- Batch Size (Edit Fields (Set)): sets 1 field: batchSize
- Set Offset (Edit Fields (Set)): sets 1 field: offset
- Get Records (HTTP Request): calls an HTTP API
- Update Records (Google Sheets): append or update
- Delay (Wait): waits 2 seconds
- Add Offset (Edit Fields (Set)): sets 1 field: new_offset
- Read Budgets (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Compose Report (Code): runs custom JavaScript code
- Add Budgets (Merge): merges the data from its input branches
…plus 8 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)
- Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Wait
n8n-nodes-base.wait - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Merge
n8n-nodes-base.merge - Gmail
n8n-nodes-base.gmail - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
This n8n template allows you to automatically monitor your company's budget by comparing live Bexio accounting data against targets defined in Google Sheets, sending automated weekly email reports. It also exports your financial data from Bexio into a…