Track multi-broker investment portfolio with Google Sheets and Telegram 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 12 nodes and runs on Telegram events (message) (plus 1 other trigger). Along the way it connects Google Sheets and Telegram.
How it runs
Trigger: On Telegram events (message) (plus 1 other trigger).
- Edit Fields (Edit Fields (Set)): sets 1 field: myId
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- If: checks a condition and branches into true / false
- Aggregate: combines items into one
- Switch: routes items into 2 branches
- Code: runs custom JavaScript code
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Total PNL Update (Telegram): uses Telegram
- Code: runs custom JavaScript code
- Broker PNL Update (Telegram): uses Telegram
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)
- If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Switch
n8n-nodes-base.switch - Aggregate
n8n-nodes-base.aggregate - Code
n8n-nodes-base.code - Telegram Trigger
n8n-nodes-base.telegramTrigger - Telegram
n8n-nodes-base.telegram - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set
From the author
All-in-One Portfolio Tracker & Telegram Finance Updates Workflow for n8n: Multi-Broker, Real-Time, Global 🚀 Overview Take control of all your investments—across multiple brokers and platforms—in one place, with live updates sent directly to your Telegram!…