<- All use cases

Send reminder email 30 days 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 30 days before a 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 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.

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

=G2-30

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 in 30 days"))

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.

Lease Abstraction Software

Financial Contract Abstraction Software

Convert Event Attendee List to Google Sheets

Convert Image to OCR PDF

Invoice OCR Software

OCR Invoice Extraction

View all