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

Why you should use this

This automation sends reminders 30 days 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 30 days before a specified date, then automatically triggers an email based on the calculated 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 30 days before a date in Google Sheets

Use Lido's spreadsheet to calculate a reminder date 30 days before a Google Sheets date.

For example, if your 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 in 30 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 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.