How do I set up an email notification in Google Sheets 30 days before a specific date?

  • 13 February 2024
  • 4 replies

- I have a sheet created on Google Sheets.
- The sheet contains dates in the following format: "2013-05-07" in column "D"

I need an email notification to arrive 30 days before the date entered.
Furthermore, all the data in the other columns must be included in the email.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +14

Hi @Alessandro_M 

I recommend using Airtable instead of GSheets.

Airtable has Date fields:

Airtable has Automations:

Airtable Automations have a native Gmail action step:

When records meet the conditions of an Airtable Automation (e.g. Date is 30 days from now), then an email can be sent via Gmail.

However, the sheet I created is synchronized via a Wix automation.
Do you think I can do it anyway?

Userlevel 7
Badge +14


Wix Automations can be connected to Airtable.

Wix Automations:


Userlevel 7
Badge +8

Hi @Alessandro_M 


You can do that by having a zap create a Google Calendar event which has the start date 30 days from the date in Google Sheet. You can then have another zap trigger from Google Calendar once the event date is there and it can then send the email.