Monitor negative news for watchlist companies with Google Sheets, SerpAPI, Groq, and Gmail
Ready for 3.0What this workflow does
This AI workflow has 18 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Groq Chat Model, Google Sheets and Gmail. It also calls serpapi.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Read Watchlist (Google Sheets): uses Google Sheets
- Loop Over Watchlist (Loop Over Items (Split in Batches)): loops over the items in batches
- Results Aggregation (Aggregate): combines items into one
- Fetch News (HTTP Request): calls serpapi.com
- Filter Article List (Code): runs custom JavaScript code
- Process Articles (Code): runs custom JavaScript code
- Loop Over Articles (Loop Over Items (Split in Batches)): loops over the items in batches
- Lookup Existing Articles (Google Sheets): uses Google Sheets
- Filter New Articles (If): checks a condition and branches into true / false
- Throttle API Calls (Wait): waits 2 seconds
…plus 5 more steps. See the full node list below.
Services it uses
HTTP calls to: serpapi.com
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 (13)
- Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Gmail
n8n-nodes-base.gmail - Aggregate
n8n-nodes-base.aggregate - Edit Fields (Set)
n8n-nodes-base.set - Wait
n8n-nodes-base.wait - Manual Trigger
n8n-nodes-base.manualTrigger
From the author
AI-Powered Risk Monitor: Negative News Tracker This workflow acts as an automated early-warning system for corporate risk. It pulls a list of companies from a Google Sheet, uses SerpAPI to scout the latest global news and employs Groq-powered AI to detect…