Lido is trusted by sales, marketing, and operations teams at:
and 100s of other companies

Why you should use this

This automation sends reminders 1 day before a scheduled date in Google Sheets, ensuring that all necessary preparations or actions are taken well in advance. It enhances workflow management by automating alerts, helping prevent missed deadlines and maintaining smooth operational continuity.

How it Works

This Lido automation connects to your Google Sheet, calculates a reminder date 1 day before a specified expiration date, then automatically triggers an email on the reminder date.

Connect your Google Sheet to Lido

Connect your Google Sheet to Lido with one-click. Updates in your Google Sheet are automatically pulled into Lido.

Calculate 1 day before a date in Google Sheets

Use Lido's spreadsheet to calculate a reminder date 1 day before a Google Sheets date.

For example, if your expiration dates are in column G, then your formula is simply:


Send reminder email

Write another formula to check if today's date is equal to your calculated reminder date. If it is, then automatically trigger an email with Lido's SENDGMAIL formula. You can include details from a Google Sheets row in the subject or body of your email.

IF(TODAY()=H2, SENDGMAIL(<sender-email>, "", "Reminder!", "Deadline is tomorrow!!"))

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 project managers, HR professionals, and administrative staff who need to manage deadlines, events, or compliance requirements that are date-sensitive. This automation is particularly useful for keeping teams and individuals on track with upcoming obligations.