Real-Time Stock Monitor with Smart Alerts for Indian & US Markets

This n8n workflow provides real-time monitoring of Indian (NSE/BSE) and US stock markets, fetching live prices from Twelve Data API every 2 minutes during market hours. It reads a customizable watchlist from Google Sheets, including symbols, upper/lower limits, directions (both/above/below), and cooldown periods. Advanced logic checks price conditions against thresholds, applies cooldowns to avoid alert fatigue, and triggers notifications only when criteria are met.

Key benefits include multi-channel alerts (email for detailed reports, Telegram for instant mobile push), automatic tracking of last alert times/prices in Sheets for history, and robust error handling with admin success/failure notifications. This saves traders hours of manual monitoring, reduces emotional trading decisions, and ensures no missed opportunities on breakouts or breakdowns.

Perfect use cases: Day traders watching volatile stocks like TCS or AAPL; portfolio managers overseeing diverse IN/US holdings; investors setting custom alerts for swing trades. Setup is straightforward— just configure Google Sheets with exact columns (symbol, upper_limit, lower_limit, direction, cooldown_minutes, last_alert_price, last_alert_time) and API credentials. High reliability with built-in workflow monitoring makes it production-ready for serious market participants.