<- All use cases

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 an onboarding call
Watch demo video
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.

Schedule an onboarding callTry 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.

Convert Financial Statements to Excel

Extract PDF Data to Sheets

Send email notifications for Google Forms

Convert Financial Statements to Google Sheets

Send Slack messages based on dates in a Google Sheet

Zone OCR Software

View all