Best answer

How to send reminder email 1 week before date in Google spreadsheet?

  • 22 July 2021
  • 2 replies

Use case: Remind managers new hire is starting next week


Hi, I’d like setup a zap to send a reminder email 1 week before a date in a google spreadsheet. 


So, i’d need zapier to look at all of the rows in  column D in a spreadsheet and find where that date = 1 week before today. For those rows, send an email to manager’s email in row E to remind them of something. 


Can this be done? 





Best answer by SamB 26 July 2021, 18:01

View original

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

2 replies

Userlevel 7
Badge +14

HI @SYoung 

Try using this instead: GCal - Event Start


Userlevel 7
Badge +11

Hey @SYoung,

What Troy’s suggested here should do the trick. I just wanted to add that when using the Event Start trigger, you’d need to add each spreadsheet row into a Google Calendar as an event for it to work.

If you’d got another Zap that’s adding the rows to the Google Sheet spreadsheet, then you can just add a Create Detailed Event Google Calendar action to it - that will allow you to automatically create the events. Otherwise, you’ll want to set up a Zap that triggers when a New Spreadsheet Row is added in Google Sheets and then use the Create Detailed Event action to add it into Google Calendar.

Then you can set up a separate Zap that uses the Event Start trigger (set to trigger 1 week before) and a Send Email action to send the reminder email.

Hope that helps! :)