Send NSE stock watchlist alerts with Google Sheets and Gmail

by WeblineIndia ✓ · 52 views · created 2026-08-04 · Crypto Trading

What this workflow does

This workflow has 14 nodes and runs on a schedule (cron */5 9-15 * * 1-5). Along the way it connects Google Sheets and Gmail. It also calls memic-nse-quotes-api.hf.space over HTTP.

How it runs

Trigger: On a schedule (cron */5 9-15 * * 1-5).

1. Load Stock Watchlist (Google Sheets): uses Google Sheets
2. Filter Active Stocks (Code): runs custom JavaScript code
3. Prepare NSE Quote Request (Edit Fields (Set)): sets 2 fields: apiBody, watchlistRows
4. Fetch NSE Market Quotes (HTTP Request): calls memic-nse-quotes-api.hf.space (POST)
5. Detect Buy Sell Signals (Code): runs custom JavaScript code
6. Check Alert Availability (If): checks a condition and branches into true / false
7. Route Alert Type (Switch): routes items into 2 branches
8. Build Sell Alert Message (Edit Fields (Set)): sets 6 fields: alertMessage, subject, symbol…
9. Build Buy Alert Message (Edit Fields (Set)): sets 6 fields: alertMessage, subject, symbol…
10. Combine Alert Streams (Merge): merges the data from its input branches

…plus 2 more steps. See the full node list below.

Services it uses

Google SheetsGmail

HTTP calls to: memic-nse-quotes-api.hf.space

Before you upgrade to n8n 3.0

Nodes used (10)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• Edit Fields (Set)n8n-nodes-base.set
• Ifn8n-nodes-base.if
• No Operation, do nothingn8n-nodes-base.noOp
• Switchn8n-nodes-base.switch
• Mergen8n-nodes-base.merge
• Gmailn8n-nodes-base.gmail
• HTTP Requestn8n-nodes-base.httpRequest

From the author

Quick overview This workflow polls a Google Sheets stock watchlist every five minutes during weekday market hours, fetches live quotes from an NSE quotes HTTP API, and sends Gmail alerts when prices cross buy-below or sell-above thresholds while logging each…

View the original on n8n.io → Check your own copy