Score macro news impact with Groq, SerpAPI, Google Sheets and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 21 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, Groq Chat Model and Gmail. It also calls serpapi.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Fetch Existing News (Google Sheets): uses Google Sheets
- Fetch Macro Rules (Google Sheets): uses Google Sheets
- Fetch Macro News (SerpAPI) (HTTP Request): calls serpapi.com
- Normalize & Generate News ID (Code): runs custom JavaScript code
- Iterate News Articles (Loop Over Items (Split in Batches)): loops over the items in batches
- Remove Duplicate Articles (Code): runs custom JavaScript code
- Check If New Article (If): checks a condition and branches into true / false
- Apply Macro Rules Engine (Code): runs custom JavaScript code
- Combine Rule + AI Outputs (Merge): merges the data from its input branches
- Rate Limit (Wait): pauses before continuing
…plus 8 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)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Merge
n8n-nodes-base.merge - Gmail
n8n-nodes-base.gmail - Wait
n8n-nodes-base.wait - Edit Fields (Set)
n8n-nodes-base.set
From the author
Macro News: AI-Driven Market Impact Scoring Automation This workflow is a high-precision financial intelligence engine that monitors macroeconomic news to identify high-impact trading opportunities. It retrieves real-time data via SerpAPI, processes it…