Manage portfolio assets via webhook with Google Sheets and real-time totals
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 PO...
Template notes
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 your total portfolio value in real-time.
Quick Implementation Steps
1. [Import the workflow into your n8n account](https://n8n.partnerlinks.io/om1efg2qgvwi) 2. Connect your Google Sheets OAuth2 credentials 3. Ensure your sheet has columns: Asset, Amount, Price, Value 4. Activate the workflow 5. Send a POST request to the webhook with: json { "asset": "BTC", "amount": 2, "price": 30000, "action": "add" }
What This Workflow Does
This workflow acts as a REST-like API for managing investment portfolios using n8n. It receives data via a webhook, processes it and performs operations on a Google Sheet.
It supports three core operations:
Add a new asset Update an existing asset Delete an asset