Ensure compliance with automated training and certification renewal reminders.
This automation checks to see if today's date matches an employee certification expiration date specified in a Google Sheet and automatically sends an email if TRUE.
Lido connects to anywhere your employee training and certification 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 employee certification row that requires a reminder email.
SENDGMAIL(<sender-credential>,B2,"Renewal deadline in 3 days","[Certificate] is up for renewal in 3 days")