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.

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.

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(<>,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.

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.