Real-Time Stock and Crypto Price Monitoring with Automated Alerts
A scheduled workflow pulls live candles, moving averages, and volume for a watchlist of stocks and crypto pairs, and pushes a Telegram alert the moment a symbol crosses a threshold worth acting on.
Tracking a watchlist meant checking charts manually throughout the day, easy to miss a real move while away from the screen.
A scheduled n8n workflow reads the watchlist from Google Sheets, pulls live quotes, candles, and 30/90/200-day moving averages for each symbol, and writes the update back to the sheet. A separate branch filters for symbols crossing a defined threshold and sends a Telegram alert immediately, so the first place anyone hears about a move is their phone, not a chart they happened to be looking at.
Stack
How It Works
Read the watchlist
Symbols to track are read from Google Sheets on a schedule.
Pull live data
Current quote, candles, and moving averages are fetched for every symbol in the loop.
Write back the update
Fresh data updates the sheet, keeping it as a live reference.
Alert on threshold
Symbols crossing a defined threshold trigger an immediate Telegram alert.
Results
Telegram alerting
moving averages tracked
no manual chart-checking
The Workflow
