Manage personal expenses with webhooks and Google Sheets automated tracker
Needs changesNeeds changes. This template uses 2 thing(s) that n8n 3.0 removes: Function (legacy), Cron. 2 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 9 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Google Sheets.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Validate and Format Expense Data (Function): runs custom JavaScript (legacy Function node)
- Read Today's Expenses from Sheet (Google Sheets): uses Google Sheets
- Save Expense to Google Sheets (Google Sheets): append
- Calculate Daily Total (Function): runs custom JavaScript (legacy Function node)
- Calculate Monthly Summary (Function): runs custom JavaScript (legacy Function node)
- Send Success Response (Respond to Webhook): sends the response back to the webhook caller
- Send Error Response (Respond to Webhook): sends the response back to the webhook caller
Services it uses
Before you upgrade to n8n 3.0
2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- Function (legacy) in Validate and Format Expense Data, Calculate Monthly Summary, Calculate Daily Total: replace with Code node, mode 'Run Once for All Items'.
- Cron in Daily Summary Schedule: replace with Schedule Trigger.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Validate and Format Expense Data, Calculate Monthly Summary, Calculate Daily Total | Code node, mode 'Run Once for All Items' |
| Cron Daily Summary Schedule | Schedule Trigger |
Nodes used (5)
- Webhook
n8n-nodes-base.webhook - Function
n8n-nodes-base.function - Google Sheets
n8n-nodes-base.googleSheets - Respond to Webhook
n8n-nodes-base.respondToWebhook - Cron
n8n-nodes-base.cron
From the author
- How it works: This system functions by receiving expenses via webhook POST. It validates the data, stores it in Google Sheets, and, daily at 8 PM, generates and sends financial summaries. Automatic categorization simplifies the organization of expenses. -…