Filtering Google Calendar for specific timeframe

Question

I have multiple zaps set up to send emails at 2 weeks, 1 week, 1 day and 45 min before the event, so when I set up an event it will run all of these and send multiple emails if the timeframe has passed.

ie. I set one up today for tomorrow and it sent 3 emails, but I really only need it to send the 1 day and 45 min before emails. How can I get it to skip over the others that are past the timeframe?

Thanks for the help, I don’t even know how to effectively search google for this problem because I don’t really know how to describe it.

GetUWired · Accepted Answer

@AshearerThere might be a better way to do this but you could try using a datetime formatter step that subtracts the amount of time before the event you want the zap to trigger then compare the output from the formatter step in a filter.If the start time is before the formatter output time let the zap continue.So if i want Zapier to trigger 1 week before then something like this should work. You may need to play with the subtraction method to find an acceptable range.

Danvers · Answer

Hi @Ashearer!How are you getting on with your Zaps, did @GetUWired’s suggestion help? Let us know if you need some more help with this!

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded