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