Track contract renewals with Google Sheets, Slack, and Groq chat models
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 week at 09:00). Along the way it connects Google Sheets, Slack and Groq Chat Model.
How it runs
Trigger: On a schedule (every week at 09:00).
- Fetch Contract Tracker Data (Google Sheets): uses Google Sheets
- Check Unprocessed Contracts (If): checks a condition and branches into true / false
- Validate Required Contract Fields (If): checks a condition and branches into true / false
- Calculate Days to Expiry (Code): runs custom JavaScript code
- Send Invalid Data Alert (Slack): uses Slack
- Calculate Renewal Priority Score (Code): runs custom JavaScript code
- Mark Invalid Contract Data (Google Sheets): update
- Check High Priority Renewal (If): checks a condition and branches into true / false
- Generate Renewal Strategy (AI Agent): runs an AI agent, with model: Chat Model
- Prepare Monitor Recommendation (Edit Fields (Set)): sets 3 fields: ContractID, PriorityLevel, Recommendation
…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 (8)
- Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - Edit Fields (Set)
n8n-nodes-base.set - Slack
n8n-nodes-base.slack - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq
From the author
Quick overview This workflow runs weekly to review contracts stored in Google Sheets, calculates days to expiry and a renewal priority score, uses a Groq-hosted chat model to draft renewal recommendations for high-priority items, posts alerts to Slack, and…