Send emails based on dates in PostgreSQL

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

How it Works

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

Once per day pull the latest data from PostgreSQL

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

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

Use spreadsheet formulas to work directly with your connected PostgreSQL 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.