Benchmark procurement prices and flag overpricing with Google Sheets, Groq, and Slack
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 16 nodes and runs on a schedule (every day at 09:00). Along the way it connects Groq Chat Model, Google Sheets and Slack.
How it runs
Trigger: On a schedule (every day at 09:00).
- Fetch Procurement Data (Google Sheets): uses Google Sheets
- Group Latest & Historical Prices (Code): runs custom JavaScript code
- Calculate Market Benchmark Metrics (Code): runs custom JavaScript code
- Process Items for Market News (Loop Over Items (Split in Batches)): loops over the items in batches
- Merge: merges the data from its input branches
- Fetch Market News (Google RSS) (RSS Read): reads an RSS feed
- AI Procurement Risk Analysis (AI Agent): runs an AI agent, with model: Groq Chat Model
- Extract Market Trend Signals (Code): runs custom JavaScript code
- Parse AI Response to Structured JSON (Code): runs custom JavaScript code
- Rate Limit Control (Wait): waits 2 seconds
…plus 4 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 (12)
- Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - RSS Read
n8n-nodes-base.rssFeedRead - Merge
n8n-nodes-base.merge - AI Agent
@n8n/n8n-nodes-langchain.agent - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Slack
n8n-nodes-base.slack
From the author
Quick overview This scheduled workflow benchmarks internal procurement prices from Google Sheets against historical averages, enriches each item with Google News RSS trend signals, and uses Groq (Llama 3.3) to assess pricing risk, recommend target ranges and…