Real-time stock monitor with smart alerts for Indian & US markets

Monitor Indian (NSE/BSE) and US stock markets with intelligent price alerts, cooldown periods, and multi-channel notifications (Email + Telegram). Automatically tracks price movements and sends alerts when stocks cross predefined upper/lower limits. Perfect for day traders, investors, and portfolio managers who need instant notifications for price breakouts and breakdowns. How It Works Market Hours Trigger - Runs every 2 minutes during market hours Read Stock Watchlist - Fetches your stock list from Google Sheets Parse Watchlist Data - Processes stock symbols and alert parameters Fetch Live Stock Price - Gets real-time prices from Twelve Data API Smart Alert Logic - Intelligent price checking with cooldown periods Check Alert Conditions - Validates if alerts should be triggered Send Email Alert - Sends detailed email notifications Send Telegram Alert - Instant mobile notifications Update Alert History - Records alert timestamps in Google Sheets Alert Status Check - Monitors workflow success/failure Success/Error Notifications - Admin notifications for monitoring Key Features: - Smart Cooldown: Prevents alert spam - Multi-Market: Supports Indian & US stocks - Dual Alerts: Email + Telegram notifications - Auto-Update: Tracks last alert times - Error Handling: Built-in failure notifications Setup Requirements: 1. Google Sheets Setup: Create a Google Sheet with these columns (in exact order): - A: symbol (e.g., TCS, AAPL, RELIANCE.BSE) - B: upperlimit (e.g., 4000) - C: lowerlimit (e.g., 3600) - D: direction (both/above/below) - E: cooldownminutes (e.g., 15) - F: lastalertprice (auto-updated) - G: lastalerttime (auto-updated) 2. API Keys & IDs to Replace: - YOURGOOGLESHEETIDHERE - Replace with your Google Sheet ID - YOURTWELVEDATAAPIKEY - Get free API key from twelvedata.com - YOURTELEGRAMCHATID - Your Telegram chat ID (optional) - your-email@gmail.com - Your sender email - alert-recipient@gmail.com - Alert recipient email 3. Stock Symbol Format: - US Stocks: Use simple symbols like AAPL, TSLA, MSFT - Indian Stocks: Use .BSE or .NSE suffix like TCS.NSE, RELIANCE.BSE 4. Credentials Setup in n8n: - Google Sheets: Service Account credentials - Email: SMTP credentials - Telegram: Bot token (optional) Example Google Sheet Data: Output Example: