{"product_id":"n8n-nse-stock-alerts-google-sheets-watchlist-gmail","title":"n8n NSE Stock Alerts: Google Sheets Watchlist + Gmail","description":"\u003ch3\u003en8n NSE Stock Alerts: Google Sheets Watchlist + Gmail\u003c\/h3\u003e\n\u003cp\u003eTurn 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns on a schedule\u003c\/b\u003e: uses a \u003cb\u003eschedule trigger\u003c\/b\u003e to execute every 5 minutes during configured \u003cb\u003eweekday market hours\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReads your watchlist\u003c\/b\u003e: pulls rows from the \u003cb\u003eStock Watchlist\u003c\/b\u003e sheet and keeps only entries marked \u003cb\u003eactive\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFetches live NSE quotes\u003c\/b\u003e: sends the active symbols to an \u003cb\u003eNSE quotes HTTP API\u003c\/b\u003e to retrieve the latest prices.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eEvaluates buy\/sell rules\u003c\/b\u003e: compares each current price against \u003cb\u003ebuy_below\u003c\/b\u003e and \u003cb\u003esell_above\u003c\/b\u003e thresholds to generate BUY\/SELL alert records.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends email alerts\u003c\/b\u003e: if alerts are generated, routes them by direction (above for \u003cb\u003eSELL\u003c\/b\u003e, below for \u003cb\u003eBUY\u003c\/b\u003e), formats the email subject and message, and sends each alert via \u003cb\u003eGmail\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLogs alert events\u003c\/b\u003e: appends alert details (timestamp, symbol, price, direction, threshold) to an \u003cb\u003eAlertLog\u003c\/b\u003e sheet in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eStops when no alerts occur\u003c\/b\u003e: if no alerts are triggered, it does not send emails for that run.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eNotify yourself when NSE stocks hit predefined entry (\u003cb\u003ebuy_below\u003c\/b\u003e) or exit (\u003cb\u003esell_above\u003c\/b\u003e) levels.\u003c\/li\u003e\n  \u003cli\u003eRun an always-on “watchlist monitor” for SaaS operations—complete with an audit trail in \u003cb\u003eAlertLog\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eAutomate alerting for multiple symbols without manually checking prices throughout market hours.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e: reads \u003cb\u003eStock Watchlist\u003c\/b\u003e (Name, active, buy_below, sell_above) and writes to \u003cb\u003eAlertLog\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eNSE quotes HTTP API\u003c\/b\u003e: fetches live quotes for active symbols.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail\u003c\/b\u003e: sends BUY\/SELL alert emails to configured recipients.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003en8n nodes used\u003c\/b\u003e: \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003eno op\u003c\/b\u003e, \u003cb\u003egmail\u003c\/b\u003e, \u003cb\u003emerge\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cb\u003eSetup note\u003c\/b\u003e: connect your Google Sheets and Gmail credentials, confirm the NSE quotes endpoint is reachable, and adjust the schedule to match your market hours.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45758731026611,"sku":"N8N-17799","price":58.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/F0vi5hC8KNKXMilZWpuG1_kZZ67QdP.png?v=1785834153","url":"https:\/\/buyflowscripts.com\/products\/n8n-nse-stock-alerts-google-sheets-watchlist-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}