Skip to main content
Question

delayed notifications from google sheets

  • 7 March 2023
  • 8 replies
  • 124 views

Hi I have a google sheet that is populated by orders I receive through woocommerce. I would like to get a notification after 3 days and after 7 days to serve as reminders that I still have an order to fulfill. Any idea how to do this?  I don’t need the notification at the time of change in the sheet bc woocommerce already does that. its the reminder I need.

(ideally there would be someone to automatically tell the spreadsheet when the order has shipped but haven’t figured that out either)

Alternatively, could Zapier automatically create a reminder in my iphone Reminder app? 

Thanks for any help!

 

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

8 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @JHC 

Good question.

One approach is to add Delay steps to the Zap at your desired intervals, then follow that with a GSheet Lookup Row step to get the current data for a row, then follow that with a Filter step to determine if the Zap should continue.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
JHC

Okay I think I am following you. There is a row that is “Order Date”. So I could delay the zap notification for 72 hours to get an email notification on day 3?

I am a newbie so not really sure how to do this though.

JHC

okay I set up a Zap with a delay of 4 days (compromise). I guess i could set up a second Zap with a delay of 7 days? is there anyway to see if this works? (without waiting 4 days?)

 

Troy Tessalone
Userlevel 7
Badge +14

@JHC 

You’d have to use a shorter Delay (e.g. 1 hour) and test.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Troy Tessalone
Userlevel 7
Badge +14

@JHC

If you wanted to save Zap Tasks, then you can use Airtable instead of GSheets.

Airtable has Views. (segments of data)

Views have Filters. (e.g. Date was X days ago.)

Views can be used to trigger Zaps.

Views can also be used to trigger Airtable Automations.

Airtable Automations can be configured to send an email.

 

Airtable essentially removes the need for the delay, recheck, filter steps.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
JHC

one more update- I was able to set up the Zap with the Delay, but because the zap now has two steps I need to update to the premium plan, so that is too expensive for this one task. any other ideas are welcome.

Troy Tessalone
Userlevel 7
Badge +14

@JHC 

If you wanted to save Zap Tasks, then you can use Airtable instead of GSheets.

Airtable has Views. (segments of data)

Views have Filters. (e.g. Date was X days ago.)

Views can be used to trigger Zaps.

Views can also be used to trigger Airtable Automations.

Airtable Automations can be configured to send an email.

 

Airtable essentially removes the need for the delay, recheck, filter steps.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
ken.a
Userlevel 7
Badge +6

Hi @JHC,

 

Just following up here. Have you had the time to try out Troy’s suggestion? Please let us know if it worked! 😊

Terms & Conditions