Automate Contract Renewal Alerts via Slack with Google Sheets

Never miss another contract renewal deadline again. This automated n8n workflow monitors your Google Sheets contract database and sends intelligent Slack alerts based on approaching cancellation deadlines, ensuring you stay ahead of renewals and avoid unwanted auto-renewals.

What this workflow does

This workflow runs automatically every morning at 9am, scanning all 5 tabs of your Contracts Google Sheet (SaaS, Leases, Services, Insurance, Other) to monitor cancellation deadlines. It calculates days remaining until each contract's cancellation deadline and sends tiered Slack notifications:

• 🔴 Urgent (≤7 days): Act now alerts for immediate action
• 🟡 Action needed (≤14 days): Plan this week notifications
• 🟢 Heads-up (≤30 days): Early warning system

Auto-renewing contracts receive stronger warnings than simple expiring contracts, prioritizing situations where money is at stake. Smart de-duplication prevents spam by tracking alert history in your spreadsheet.

Use cases

• SaaS management: Avoid surprise renewals and budget overruns on software subscriptions
• Vendor contracts: Negotiate better terms before auto-renewal kicks in
• Insurance policies: Ensure continuous coverage without lapses
• Office leases: Plan relocations or renegotiate terms in advance
• Service agreements: Review performance and pricing before renewal

Technical details

Built with essential n8n nodes including Google Sheets integration for data reading, conditional logic nodes (if, switch) for alert tier determination, merge and set nodes for data processing, and Slack integration for notifications. The workflow requires OAuth credentials for both Google Sheets and Slack, plus two additional tracking columns (Last Alert Tier, Last Alert Date) in your existing contract spreadsheet.

Perfect for finance teams, operations managers, and anyone managing multiple contracts who needs reliable automation to prevent costly oversights in contract renewals.