Monitor supplier risk daily with Groq, Google Sheets, Slack and Gmail
Ready for 3.0What this workflow does
This AI workflow has 24 nodes and runs on a schedule (every day at 09:00). Along the way it connects Groq Chat Model, Google Sheets, Slack and Gmail. It also calls api.exchangerate-api.com over HTTP.
How it runs
Trigger: On a schedule (every day at 09:00).
- Fetch Supplier Master List (Google Sheets): uses Google Sheets
- Process Each Supplier (Loop Over Items (Split in Batches)): loops over the items in batches
- Fetch Today's Logged Results (Google Sheets): uses Google Sheets
- Fetch Supplier News (HTTP Request): calls an HTTP API
- Fetch Industry Benchmarks (HTTP Request): calls an HTTP API
- Get Currency Exchange Rates (HTTP Request): calls api.exchangerate-api.com
- Deduplicate & Slim Data (Code): runs custom JavaScript code
- Combine Research Data (Merge): merges the data from its input branches
- Generate Executive Briefing (AI Agent): runs an AI agent, with model: Groq Chat Model
- Pre-AI Data Formatting (Code): runs custom JavaScript code
…plus 10 more steps. See the full node list below.
Services it uses
HTTP calls to: api.exchangerate-api.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 (12)
- Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - Switch
n8n-nodes-base.switch - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set
From the author
Quick overview This workflow runs daily at 9 AM to assess supplier risk using Google Sheets KPIs, Google News RSS headlines, OpenSanctions screening, and currency rates, then uses Groq LLM analysis to alert via Slack/Gmail, log results to Google Sheets, and…