Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

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

S

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? 

 

Thanks!

 

Best answer by SamB

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! :)

View original
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.

2 replies

Troy Tessalone
Forum|alt.badge.img+14

HI @SYoung 

Try using this instead: GCal - Event Start

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 7547 replies
  • Answer
  • July 26, 2021

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! :)

Terms & Conditions