Send tiered contract renewal Slack alerts from Google Sheets
What this workflow does Runs every morning at 9am. Reads every contract from the 5 tabs in your Contracts sheet, checks how many days are left until each Cancellation Deadline, and pings Slack with tiered alerts so no...
Template notes
What this workflow does Runs every morning at 9am. Reads every contract from the 5 tabs in your Contracts sheet, checks how many days are left until each Cancellation Deadline, and pings Slack with tiered alerts so no renewal slips through.
---
Alert tiers
| Days until deadline | Tier | Message | |---|---|---| | ā¤ 7 | š“ Urgent | Act now | | ā¤ 14 | š” Action needed | Plan this week | | ā¤ 30 | š¢ Heads-up | On your radar | | > 30 or past due | ā | No alert |
Auto-renewing contracts get a stronger warning than contracts that simply expire ā because that's the case where money is actually at stake.
---
Setup guide
1. Add two columns to every tab in your Contracts sheet Open your sheet and add these two columns to all 5 tabs (SaaS, Leases, Services, Insurance, Other): - Last Alert Tier - Last Alert Date