Send multi-stage SaaS renewal alerts from Google Sheets to Slack

Your automated SaaS contract renewal monitor that sends multi-stage Slack alerts 45, 30, 14, and 7 days before each contract expires.

Stop missing renewal deadlines and overpaying on auto-renewals. This workflow monitors your contract calendar in Google Sheets, sends progressive Slack notifications with manual research checklists, and tracks alert history to prevent duplicate notifications. You manage the vendors; it manages the reminders.

This is not a generic reminder bot. It is a production-ready procurement intelligence system designed to give finance and operations teams the advance notice needed to research alternatives, negotiate better terms, and avoid costly auto-renewals.

---

How the workflow works

The workflow executes in four stages:

1. TRIGGER & SCHEDULE The workflow runs daily at 9:00 AM using a cron trigger (0 9 ). The schedule runs in your configured timezone (default: UTC). A single daily check scans your entire contract portfolio and identifies which renewals are entering their alert windows.

2. LOAD & VALIDATE Using Google Sheets' native integration, the workflow reads your contract tracking spreadsheet (columns A-F: Contract Name, Vendor Name, Renewal Date, Annual Cost, Pricing URL, Status). A validation engine checks each row for: - Valid contract names (non-empty) - Proper ISO dates (YYYY-MM-DD format) - Positive costs (allows zero for free-tier contracts) - Valid HTTP/HTTPS URLs - Active status (skips Cancelled/Renewed contracts)