Send emails based on dates in a Google Sheet

Never miss an important deadline, expiration, or follow up again. Trigger emails based on dates in a Google Sheet to remind yourself about upcoming deadlines, follow up on late invoices, and more.

Try this in Lido for free ->Schedule a demo with a product specialist
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.

Talk to a product specialistTry this in Lido for free ->

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(<tim@gmail.com>,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.
Instructions from the Lido blog ->
Youtube video ->
Talk to a product specialistTry this in Lido for free ->

Who should use this

Talk to a product specialistTry this in Lido for free ->

Related Use Cases

Discover more workflows you can automate with Lido.

Create Google Calendar events from Google Sheets

Send email when a new row is added to Google Sheets

Create Purchase Orders from Google Forms

Create Google Calendar events from Google Forms Submissions

Send email notifications to different people based on Typeform responses

Send emails to different people based on a Google Sheets column

View all