Send tiered contract renewal Slack alerts from Google Sheets
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 workflow has 13 nodes and runs on a schedule (every day at 09:00). Along the way it connects Slack and Google Sheets.
How it runs
Trigger: On a schedule (every day at 09:00).
- Read: SaaS Tab (Google Sheets): uses Google Sheets
- Read: Leases Tab (Google Sheets): uses Google Sheets
- Read: Services Tab (Google Sheets): uses Google Sheets
- Read: Insurance Tab (Google Sheets): uses Google Sheets
- Read: Other Tab (Google Sheets): uses Google Sheets
- Merge: merges the data from its input branches
- Calculate Tier & Days Left (Edit Fields (Set)): sets 4 fields: days_left, tier, vendor_label…
- Needs Alert Today? (If): checks a condition and branches into true / false
- Route by Tier (Switch): routes items into 3 branches
- Slack: uses Slack
…plus 2 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 (7)
- If
n8n-nodes-base.if - Switch
n8n-nodes-base.switch - Slack
n8n-nodes-base.slack - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Edit Fields (Set)
n8n-nodes-base.set
From the author
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 |…