<- All use cases

Send emails based on dates in MySQL

Never miss an important deadline, expiration, or follow up again. Trigger emails based on dates in MySQL 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

This automation sends emails triggered by specific dates stored in a MySQL database, ensuring stakeholders receive reminders or updates at just the right time. It enhances workflow management by automating time-sensitive communications, helping teams stay on track with deadlines and reducing the risk of oversight in critical processes. This is crucial for maintaining efficiency and accountability in projects or operational routines.

How it Works

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

Schedule an onboarding callTry this in Lido for free ->

Once per day pull the latest data from MySQL

Connect your MySQL database to Lido's spreadsheet, no code required. Once per day, Lido will pull in the latest data from MySQL.

Check if today’s date is equal to the date in the MySQL table

Use spreadsheet formulas to work directly with your connected MySQL data.

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

Send an email if today's date matches the email trigger date

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

Ideal for IT professionals, project managers, and operational staff who need to track key dates and ensure timely communication related to deadlines or milestones. This tool is especially useful for managing schedules, project timelines, or subscription expirations.
Talk to a product specialistTry this in Lido for free ->

Related Use Cases

Discover more workflows you can automate with Lido.

Send SMS text messages based on dates in a Google Sheet

Extract PDF Data to Sheets

Convert Credit Card Statements to Google Sheets

Send Slack messages when a new row is added to a Google Sheet

Send emails triggered by values in PostgreSQL columns

Convert Credit Card Statements to Excel

View all