📈 Send NSE stock watchlist alerts with Google Sheets and Gmail
⚡ 53 views · 📈 Crypto Trading & Stock Market
Description
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 triggered alert back to Google Sheets.
How it works
- Runs every 5 minutes during configured weekday market hours using a schedule trigger.
- Reads the watchlist from Google Sheets and keeps only rows marked as active.
- Sends the active symbols to an NSE quotes HTTP endpoint to retrieve the latest prices.
- Compares each symbol’s current price against the watchlist’s buy_below and sell_above thresholds to generate BUY/SELL alert records.
- Stops if no alerts are generated, otherwise routes alerts by direction (above for SELL, below for BUY) and formats the email subject and message.
- Sends each alert via Gmail and appends the alert details (timestamp, symbol, price, direction, threshold) to an AlertLog sheet in Google Sheets.
Setup
- Connect Google Sheets credentials and set the spreadsheet and sheet names/IDs for both the Stock Watchlist and AlertLog tabs.
- Create/verify the Stock Watchlist columns used by the workflow (at minimum: Name, active, buy_below, sell_above).
- Connect Gmail credentials and set the recipient(s) in the Gmail node to receive BUY/SELL alerts.
- Confirm the NSE quotes API endpoint is reachable from your n8n instance, and adjust the schedule cron expression if your market hours or timezone differ.
Additional info
Add-ons (Additional Features)
Possible extensions:
- Telegram alerts
- WhatsApp notifications
- Slack delivery
- Portfolio dashboard integration
- Daily summary emails
- Price trend tracking
- Technical indicator filtering
- Webhook notifications
- Database storage
- Multi-market support
- TradingView integration
- Position sizing calculations
Use Case Examples
1. Buy Zone Monitoring
Track stocks and receive alerts when prices fall below preferred entry levels.
2. Profit Booking Alerts
Notify investors when stocks cross exit targets.
3. Portfolio Watchlist Automation
Monitor multiple NSE stocks from a single Google Sheet.
4. Manual Strategy Tracking
Implement custom entry/exit strategies without trading platforms.
5. Historical Alert Analytics
Use AlertLog data for reviewing triggered signals.
Additional use cases can be built by extending notification channels, market APIs and analytics logic.
Troubleshooting Guide
| Issue | Possible Cause | Solution |
|---|---|---|
| No alerts received | Stock row inactive | Set active = TRUE |
| Workflow runs but no stocks processed | Missing Name column | Ensure Name column exists |
| Gmail sending fails | OAuth issue | Reconnect Gmail credentials |
| Alert history not saved | Missing AlertLog columns | Create required columns |
| API request fails | Endpoint unavailable | Verify API availability |
| No BUY / SELL events generated | Threshold values not reached | Adjust buy/sell limits |
| Empty API response | Schema mismatch | Ensure compatible output structure |
| Workflow runs outside desired time | Schedule mismatch | Update cron expression |
| Missing symbols | Incorrect stock names | Verify NSE symbol values |
| Alert messages incorrect | Message node customization issue | Review BUY/SELL Set nodes |
Need Help?
Do you need help deploying, customizing or extending this workflow?
WeblineIndia can assist with:
- n8n workflow setup
- Market automation customization
- Google Sheets integrations
- Alert systems
- Financial workflow automation
- Multi-channel notification systems
- Custom add-ons and dashboards
- Similar automation development
Whether you want Telegram alerts, advanced analytics, custom APIs or additional market integrations, the workflow can be expanded further based on your requirements.
Contact WeblineIndia to hire n8n developers for implementation assistance and custom workflow development.
🔗 Nodes Used
Google Sheets, HTTP Request, Gmail, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File