<- All use cases

Send reminder email 1 day before a date in Google Sheets

If you keep track of important dates in a Google Sheet, this automation is for you! Automatically send a reminder email 1 day before an expiration date in a Google Sheet.

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

Schedule an onboarding callTry this in Lido for free ->

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:

=G2-1

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>, "recipient@email.com", "Reminder!", "Deadline is tomorrow!!"))

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 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.
Talk to a product specialistTry this in Lido for free ->

Related Use Cases

Discover more workflows you can automate with Lido.

Send emails based on dates in MySQL

Send emails based on dates in a Google Sheet

Send email notifications for Google Forms

Send SMS from Google Forms responses

Send Slack messages based on dates in a Google Sheet

Convert Invoices to Excel

View all