Remind contract owners before a renewal

Contracts renew automatically when nobody is watching the date. Every morning at 9:00 this reads your Contracts sheet and emails the owner of each contract that is exactly 30 days from its renewal date, so there is time to review or renegotiate.

Your sheet needs columns named Contract, Renewal date and Owner email. Each contract is reminded once, because only the one day matches.

Run every day at 09:00.Run every day at 09:00.

Contracts sheetSet contractsSheet to blank.

Contracts renewing in 30 daysRead the rows of contractsSheet. Save it as renewing.Google Sheets

Each contractFor each contract in renewing.rows:

Email the contract ownerSend an email to contract["Owner email"]. Save it as emailed. Subject: contract.Contract renews in 30 daysHi, The contract.Contract contract renews on contract.date_display, 30 days from today. Please review it and decide whether to renew.Gmail