Real-Time Portfolio Manager: n8n, Webhooks & Google Sheets

Transform your n8n instance into a powerful portfolio management API that automatically tracks and calculates your investment portfolio value in real-time. This webhook-based workflow seamlessly integrates with Google Sheets to provide instant portfolio updates through simple POST requests.

What This Workflow Does

This n8n automation acts as a REST-like API for managing investment portfolios, receiving data via webhooks and performing operations directly on your Google Sheets. The workflow supports three essential portfolio operations:

• Add new assets to your portfolio with automatic validation
• Update existing holdings with current amounts and prices
• Delete assets from your portfolio when needed

Each request is thoroughly validated to ensure data accuracy and prevent duplicate entries or invalid operations. After processing any action, the workflow automatically fetches your complete portfolio, calculates the total portfolio value, and returns a structured JSON response with all updated data.

Use Cases

Perfect for developers building financial dashboards or APIs who need real-time portfolio tracking capabilities. Ideal for active traders who want to automate portfolio updates through external applications or trading bots. Also valuable for no-code users leveraging n8n and Google Sheets to create custom investment tracking solutions without complex database setups.

Integration scenarios include connecting trading platforms to automatically update positions, building custom portfolio dashboards that pull data via API calls, or creating automated reporting systems that track investment performance over time.

Technical Details

Built using core n8n nodes including webhook, if, set, code, merge, and switch nodes for robust data processing and flow control. Requires Google Sheets OAuth2 credentials for seamless integration with your portfolio spreadsheet.

Your Google Sheet must include columns for Asset, Amount, Price, and Value. The workflow accepts JSON POST requests with asset details and action parameters, making it easy to integrate with external applications or trigger from other n8n workflows. Ready to activate immediately after importing and credential setup.