Real-Time Stock Monitor with Smart Alerts via Email & Telegram 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: upper_limit (e.g., 4000)
• C: lower_limit (e.g., 3600)
• D: direction (both/above/below)
• E: cooldown_minutes (e.g., 15)
• F: last_alert_price (auto-updated)
• G: last_alert_time (auto-updated)

2. API Keys & IDs to Replace:

• YOUR_GOOGLE_SHEET_ID_HERE - Replace with your Google Sheet ID
• YOUR_TWELVE_DATA_API_KEY - Get free API key from twelvedata.com
• YOUR_TELEGRAM_CHAT_ID - Your Telegram chat ID (optional)
• [email protected] - Your sender email
• [email protected] - 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:

symbol          upper_limit  lower_limit  direction  cooldown_minutes
TCS.NSE         4000         3600         both       15
AAPL            180          160          both       10
RELIANCE.BSE    2800         2600         above      20

Output Example:

Alert: TCS crossed the upper limit. Current Price: ₹4100, Upper Limit: ₹4000.