Send AI stock watchlist alerts with Google Sheets, Groq, and Slack

Quick overview This workflow runs on a schedule, reads a stock watchlist from Google Sheets, fetches current NSE prices via an HTTP API and updates the sheet. When a stock’s move exceeds your threshold, it pulls related Google News RSS headlines, uses Groq to generate an AI explanation and posts Slack alert.

How it works Runs on a scheduled trigger to start monitoring at your chosen interval. Reads tickers and alert settings from a Google Sheets watchlist and processes them one at a time. Calls an external NSE quotes HTTP API to fetch the latest price and percentage change for each ticker, then writes the latest price back to Google Sheets. Checks whether the stock’s percentage move exceeds the alert threshold and, if it does, fetches related headlines from Google News via RSS. Filters and formats up to three headlines from the last 24 hours and combines them with the stock price data. Sends the price and headlines to a Groq chat model to generate a concise, structured JSON insight (market insight, sentiment, risk level, summary). Posts the AI insight and summary to a selected Slack channel, and sends a Slack error notification if any API/AI step fails.

Setup Connect your Google Sheets OAuth2 credential and update the spreadsheet and sheet selection to point to your watchlist. Ensure your watchlist sheet includes columns for ticker, buy_price, current_price, and alert_threshold_pct (and that ticker values match what the price API expects). Connect your Slack credential, choose the destination channel for alerts, and optionally set a separate channel/message for error notifications. Add your Groq API credentials for the LangChain Groq Chat Model used to generate the market explanation. Review the schedule interval and the HTTP API endpoint used for NSE quotes, and adjust them for your environment if needed.

Additional info How To Customize Nodes

Customize Alert Conditions

Node: Check Alert Threshold

Modify threshold logic: Greater than Less than Percentage range Absolute price movement

Customize AI Prompt

Node: Generate AI Stock Insight

You can modify: AI tone Output format Sentiment style Risk analysis depth JSON structure

Customize Slack Messages

Node: Send Slack Alert Message

Add: Emojis Markdown Price charts Rich blocks Threaded alerts

Customize News Filtering

Node: Format News Headlines

You can: Increase news count Change time range Add keyword filtering Ignore duplicate headlines

Customize Monitoring Frequency

Node: Schedule Stock Monitoring

Run: Real-time Every minute During market hours only Daily summaries

Add-ons

You can extend this workflow with additional features such as:

Telegram alerts Discord notifications Email alerts WhatsApp integration Technical indicators (RSI, MACD, EMA) Portfolio profit/loss tracking Multi-market support Stock chart generation AI-based buy/sell recommendations Historical trend analysis MongoDB or PostgreSQL storage Dashboard integration Sentiment trend tracking Multi-user watchlists

Use Case Examples

1. Real-Time Stock Movement Alerts

Receive immediate alerts when a stock crosses a configured percentage threshold.

2. AI-Based Market Context Analysis

Understand why a stock moved using AI-generated explanations and news analysis.

3. Portfolio Monitoring Automation

Track multiple stocks automatically without manual monitoring.

4. Trading Desk Notifications

Send market movement summaries directly into Slack channels used by trading teams.

5. Intelligent News-Based Alerts

Combine live stock movement with recent financial news for contextual insights.

Additional Possible Use Cases

This workflow can also be adapted for:

Crypto monitoring Commodity tracking Forex alerts ETF monitoring Mutual fund analysis Startup funding news monitoring Sector-wise sentiment analysis

Troubleshooting Guide

| Issue | Possible Cause | Solution | |---|---|---| | Google Sheets not updating | Incorrect sheet permissions | Reconnect Google OAuth2 credentials | | Slack alerts not sending | Bot not added to channel | Invite Slack bot to the target channel | | No stock data returned | Invalid ticker symbol | Verify ticker names in Google Sheets | | AI response parsing fails | Invalid AI JSON output | Improve prompt formatting in AI node | | Workflow stops unexpectedly | API request failure | Check error logs and API availability | | No news headlines found | RSS query returned empty results | Update stock symbol or query keyword | | Alert threshold never triggers | Threshold value too high | Reduce alert_threshold_pct | | Duplicate alerts received | Frequent schedule interval | Add cooldown logic or cache | | Groq API errors | Invalid or expired API key | Reconnect Groq credentials | | Workflow execution is slow | Too many stocks processed | Increase batch optimization |

Need Help?

Do you need help setting up or customizing this workflow?

Whether you want to:

Add advanced AI analysis Build a custom trading automation system Integrate additional financial APIs Create multi-platform alert systems Develop enterprise-grade workflow automations Add dashboards and reporting Scale this workflow for production use

The n8n automation experts at WeblineIndia can help you build, customize and scale intelligent n8n workflows tailored to your business needs.

You can also extend this workflow into:

Full trading automation systems AI-powered research assistants Market intelligence platforms Portfolio management dashboards Financial analytics pipelines