n8n NSE Stock Alerts: Google Sheets Watchlist + Gmail

n8n NSE Stock Alerts: Google Sheets Watchlist + Gmail

Turn your Google Sheets stock watchlist into live, rule-based trading alerts: this n8n workflow polls NSE prices every five minutes during weekday market hours and emails BUY/SELL notifications via Gmail when your price crosses the thresholds—while logging every triggered alert back to Google Sheets.

What this workflow does

• Runs on a schedule: uses a schedule trigger to execute every 5 minutes during configured weekday market hours.
• Reads your watchlist: pulls rows from the Stock Watchlist sheet and keeps only entries marked active.
• Fetches live NSE quotes: sends the active symbols to an NSE quotes HTTP API to retrieve the latest prices.
• Evaluates buy/sell rules: compares each current price against buy_below and sell_above thresholds to generate BUY/SELL alert records.
• Sends email alerts: if alerts are generated, routes them by direction (above for SELL, below for BUY), formats the email subject and message, and sends each alert via Gmail.
• Logs alert events: appends alert details (timestamp, symbol, price, direction, threshold) to an AlertLog sheet in Google Sheets.
• Stops when no alerts occur: if no alerts are triggered, it does not send emails for that run.

Use cases

• Notify yourself when NSE stocks hit predefined entry (buy_below) or exit (sell_above) levels.
• Run an always-on “watchlist monitor” for SaaS operations—complete with an audit trail in AlertLog.
• Automate alerting for multiple symbols without manually checking prices throughout market hours.

Technical details

• Google Sheets: reads Stock Watchlist (Name, active, buy_below, sell_above) and writes to AlertLog.
• NSE quotes HTTP API: fetches live quotes for active symbols.
• Gmail: sends BUY/SELL alert emails to configured recipients.
• n8n nodes used: if, set, code, no op, gmail, merge.

Setup note: connect your Google Sheets and Gmail credentials, confirm the NSE quotes endpoint is reachable, and adjust the schedule to match your market hours.