n8n Contract Renewal Tracker: Google Sheets + Slack Alerts

Automatically review contract renewals and alert your team in Slack—every week

This n8n Contract Renewal Tracker workflow scans your Google Sheets contract list weekly, calculates days to expiry and a renewal priority score, then sends Slack alerts with AI-generated renewal recommendations for high-priority contracts—while updating each row as processed.

What this workflow does

• Runs weekly using a schedule trigger.
• Reads contract rows from your Google Sheets contract tracker and keeps only rows that are not marked as processed.
• Validates required fields—specifically ContractID, SupplierName, and ExpiryDate. If validation fails, it sends a Slack message and marks the row as Processed = Yes.
• Calculates urgency by computing DaysToExpiry and assigning a `PriorityLevel` based on contract value, risk level, performance score, and expiry urgency.
• Generates renewal strategy for High priority items by using a Groq-hosted chat model via LangChain, then posts a formatted renewal alert to your Slack channel.
• Updates Google Sheets for each processed row with Processed = Yes, the computed PriorityLevel, and either the AI recommendation (high priority) or a “monitor for now” recommendation (non-high priority).

Use cases

• SaaS operators who need weekly visibility into expiring supplier or customer agreements.
• Automation engineers consolidating contract tracking in Google Sheets and routing actions to Slack.
• Teams prioritizing renewal outreach based on risk, performance, and time-to-expiry.

Technical details

• Integrations/credentials: Google Sheets, Slack, Groq (via LangChain chat model).
• n8n nodes referenced: if, set, code, slack, sticky note, google sheets.
• Setup steps: configure spreadsheet ID + sheet name, set Slack channel for renewal/invalid-data alerts, add Groq API credentials for the chat model.