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.

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.

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?)

@JHC 

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

@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.

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.

@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.

Hi @JHC,

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