Every morning, emails the owner of any contract in your Google Sheet that renews in exactly 30 days.
Uses
Gmail
Google Sheets
Remind contract owners before a renewal
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