- 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.
Hi
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?
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
Hi
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.