Manage portfolio assets via webhook with Google Sheets and real-time totals
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 22 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Normalize Input Data (Edit Fields (Set)): sets 5 fields: asset, amount, price…
- Validate Amount & Price (If): checks a condition and branches into true / false
- Route by Action (Add/Update/Delete) (Switch): routes items into 5 branches
- Error: Invalid Amount/Price (Respond to Webhook): sends the response back to the webhook caller
- Check Asset Exists (Add) (Google Sheets): uses Google Sheets
- Update Existing Asset (Google Sheets): update
- Check Asset Exists (Delete) (Google Sheets): uses Google Sheets
- Error: Missing Action (Respond to Webhook): sends the response back to the webhook caller
- Error: Invalid Action Value (Respond to Webhook): sends the response back to the webhook caller
- Asset Exists? (Add) (If): checks a condition and branches into true / false
…plus 11 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 (8)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Switch
n8n-nodes-base.switch - Google Sheets
n8n-nodes-base.googleSheets - Respond to Webhook
n8n-nodes-base.respondToWebhook - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code
From the author
Webhook-Based Portfolio Manager (n8n + Google Sheets + API) This workflow turns your n8n instance into a portfolio management API using a webhook and Google Sheets. You can add, update or delete assets via a simple POST request and it automatically calculates…