Question

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

  • 13 February 2024
  • 4 replies
  • 71 views

- 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: https://support.airtable.com/docs/date-and-time-field

Airtable has Automations: https://support.airtable.com/docs/getting-started-with-airtable-automations

Airtable Automations have a native Gmail action step: https://support.airtable.com/docs/google-workspace-actions

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

@Alessandro_M 

Wix Automations can be connected to Airtable.

Wix Automations: https://zapier.com/apps/wix/integrations#triggers-and-actions

Airtable: https://zapier.com/apps/airtable/integrations#triggers-and-actions

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.