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")

Similar Apps

Use Lido to make your forms, spreadsheets, and communication apps all talk to each other.

Google Forms
Google Drive
Google Calendar