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

Description

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