Lido is trusted by sales, marketing, and operations teams at:
and 100s of other companies

Why you should use this

How it Works

This automation checks to see if today's date matches a date specified in a spreadsheet and automatically sends an email if TRUE.

Once per day pull the latest Sheets records

Once per day pull the latest records from a Google sheet

Check if today’s date is equal to the date in the Google Sheet

IF(TODAY() = C2,SENDGMAIL(<>,B2,”Reminder, task due”….)

Send an email

Send a personalized email from Gmail or Outlook account for each row that meets the criteria

SENDGMAIL(<my_credential>,B2,"Deadline in 3 days","[Task] is coming due in 3 days")

Tutorials to help you get started

Step-by-step instructions to guide you through setting up this automation in Lido.