Send AI stock watchlist alerts with Google Sheets, Groq, and Slack
Ready for 3.0What this workflow does
This AI workflow has 17 nodes and runs on a schedule (every minute). Along the way it connects Google Sheets, Groq Chat Model and Slack.
How it runs
Trigger: On a schedule (every minute).
- Read Stock Watchlist (Google Sheets): uses Google Sheets
- Stock price API (HTTP Request): calls an HTTP API (POST)
- Process Stocks One By One (Loop Over Items (Split in Batches)): loops over the items in batches
- Send Error Notification (Slack): uses Slack
- Transform Stock API Response (Code): runs custom JavaScript code
- Update Latest Prices In Sheet (Google Sheets): update
- Extract Current Price (Edit Fields (Set)): sets 5 fields: symbol, current_price, buy_price…
- Check Alert Threshold (If): checks a condition and branches into true / false
- Fetch Stock Related Market News (RSS Read): reads an RSS feed
- Format News Headlines (Code): runs custom JavaScript code
…plus 5 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - HTTP Request
n8n-nodes-base.httpRequest - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - Slack
n8n-nodes-base.slack - If
n8n-nodes-base.if - RSS Read
n8n-nodes-base.rssFeedRead
From the author
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…