I have an Action setup with a “Lookup Spreadsheet Row in Google Sheets”
I also have “Should this step be considered a "success" when nothing is found?” set as “No” but keeps going with the next step anyway.
Best answer by Troy Tessalone
View original
+12
Hi
Hmm, that doesn’t sound right, could you share an example from your Zap history of when this has happened? Specifically if we can see the data in and data out for the Google Sheets step, that would be super helpful. Don’t forget to remove or obscure any personal or private information in any screenshot you share in the community (eg full name, email address, etc).
Thanks!
+14
Hi
Good question.
Try this.
Set that GSheet step field condition to Yes, then add a Filter as the next step to check the conditions you want.
+12
Hi
Zapier independently evaluates each step when the zap runs so only steps dependent on the search step results will get stopped (steps that have data from the output of the search step). So as an example if i have a zap with 5 steps like so:
Trigger
Action 1 (Search Step)
Action 2 (not dependent on results from step 2.. ie. nothing from step 2 is mapped)
Action 3 (dependent on results from step 2.. ie. something from step 2 is mapped)
Action 4 (not dependent on results from step 2.. ie. nothing from step 2 is mapped)
Then when my search step throws a halted error only Action 3 would be skipped since Action 2 and Action 4 don’t use any output data from the search step.
I hope that helps!
if you want the entire zap to stop after the search step, you will need to either use a filter and stop when the Zap Data Was Found field is false or make sure every step after the search step uses at least 1 output field from the search step.
Thanks everyone. I believe I have it working correctly now. I changed the GSheet step field condition to Yes, then add a Filter as the next step to check the conditions before continuing.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
