Track contract utilization and send risk alerts with Groq and Google Sheets
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 20 nodes and runs on a schedule (every 6 hours). Along the way it connects Groq Chat Model, Google Sheets, Gmail and Slack.
How it runs
Trigger: On a schedule (every 6 hours).
- Fetch Contracts Data (Google Sheets): uses Google Sheets
- Fetch Spend Data (Google Sheets): uses Google Sheets
- Filter Active Contracts (If): checks a condition and branches into true / false
- Normalize Spend Data (Edit Fields (Set)): sets 6 fields: spendId, contractId, vendor…
- Merge: merges the data from its input branches
- Calculate Utilization (Code): runs custom JavaScript code
- Check Low Utilization (If): checks a condition and branches into true / false
- Generate AI Insights (AI Agent): runs an AI agent, with model: Groq Chat Model
- Check High Utilization (If): checks a condition and branches into true / false
- Extract AI Output (Risk & Action) (Code): runs custom JavaScript code
…plus 8 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 (10)
- Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - Gmail
n8n-nodes-base.gmail - Slack
n8n-nodes-base.slack - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview This workflow runs every 6 hours to combine contract and spend data from Google Sheets, calculate utilization per contract, and then update the contracts sheet while sending low- and high-utilization alerts via Gmail and Slack, using Groq to…