I made a Zap that will send a series of emails for new leads created in a table (I tried Google Sheets and Zapier Tables), I have a column titles “Active” and it can be Yes/No.
The Zap has Delays steps and a filter to continue only if the value in the Active column equals Yes.
My problem is that if I change it to No once it started it wont refresh the data so the filter keeps seeing Yes and not updating.
How can I force my Zap to refresh the data from the table before checking if the Only Continue Filter value is Yes/No? or is there a better way to do this?