If you use a Google Sheet to monitor crucial lease renewal dates, this automation will help you ensure that you never overlook an important date.
This automation checks to see if today's date matches a lease renewal date specified in a spreadsheet and automatically sends an email if TRUE.
Lido connects to anywhere your lease renewal tracking dates live, most commonly Google Sheets.
IF(TODAY() = C2,SENDGMAIL(<tim@gmail.com>,B2,”Reminder", "Upcoming lease renewal date”….)
Send a personalized email from Gmail or Outlook account for each tracked lease renewal row that requires an alert.
SENDGMAIL(<sender-credential>,B2,"Renewal deadline in 3 days","[Contract] is up for renewal in 3 days")