Skip to main content
Question

Send reminder email as deadline passes


I have different deadline dates in google sheets and would like an email reminder sent to me once the deadline date has passed. I would like this also done for another row, but for an email to be sent when the date is approaching. 

I see this is possible with google calendar, however I can not figure out how to set up a trigger for specifically google sheets and for a trigger only to be done once the date in the cell has passed. 

 

Thank you

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @jenCAL 

I recommend using Airtable instead of GSheets.

Airtable has Date fields.

Airtable has Automations.

Airtable Automations have a native integration with Gmail.

Concept would be to configure Airtable Automations trigger steps to fire when conditions are met. (e.g. Date X = Today)


  • Author
  • New
  • 1 reply
  • February 15, 2024

Hi Troy, thank you for the response. Changing platform isn't possible at the moment. Are you saying my request isn't possible? or do I need to hire a company to do custom automation?


Troy Tessalone
Forum|alt.badge.img+14

@jenCAL 

There is not native functionality to trigger a Zap when a cell date matches certain conditions.

You would either have to use some sort of formula, which can be tricky.

Or you would have to configure a Zap to run on a Schedule to check for rows that match conditions. (e.g. Date = Today)

NOTE: This approach can use excessive Zap Tasks if doing frequent checks. (e.g. run every hour vs run once a day at noon)

 

Then you would likely have to use the Looping app to handle 1+ results found on the GSheet: https://zapier.com/apps/looping/help