Never Miss a Contract Renewal Again with Automated Reminders
An n8n workflow that reads contract end dates from a Google Sheet and sends the owner a reminder 60, 30 and 7 days before each renewal — so no auto-renewal sneaks through and no revenue contract lapses because a date slipped past everyone.
- 1
Run daily
A
Schedule Triggerruns each morning and aGoogle Sheetsread pulls every contract row. - 2
Compute the window
A
Codenode calculates days-until-renewal for each contract and keeps only those hitting 60, 30 or 7 days today. - 3
Send the reminder
A
Gmailnode emails the owner the contract name, renewal date and value, with the urgency scaled to how close it is. - 4
Escalate the last call
An
IFon the 7-day window also posts toSlackor copies a manager, so imminent renewals get the attention they deserve.
Frequently asked questions
What does the contract sheet need?
One row per contract with the vendor/client name, end date, owner email, and value. The daily run computes days-until-renewal for each and fires a reminder when it hits 60, 30 or 7. You maintain one sheet; the reminders take care of themselves.
Can it escalate the closest deadlines?
Yes — the 7-day reminder can also copy a manager or post to Slack, since that's the point where inaction has real consequences. Earlier reminders stay low-key so people aren't desensitized before the deadline matters.
Log Stripe Payments from Zapier into a Google Sheets Accounting Ledger
An n8n workflow that receives successful Stripe charges relayed by Zapier, calculates fees and net amount, and appends a clean bookkeeping row to a Google Sheets ledger — giving small businesses a real-time revenue log without paying for accounting software.
Free recipeGenerate a Weekly Cohort Retention Report Automatically
Know if customers are sticking — build a weekly cohort retention report from your usage data and deliver it to the team without touching a spreadsheet formula.
Free recipeGet Alerted the Moment a Supplier Changes Their Prices
An n8n workflow that periodically fetches your suppliers' price lists, compares them to the last known prices, and alerts you to any increases or drops with the exact delta — so cost creep never silently erodes your margins and you can renegotiate or re-price in time.