About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Lookup Google Sheet Row - Zap doesn't stop on failure - Part 2

  • 7 October 2022
  • 5 replies
  • 57 views
W

The linked post details a fix to stop your zap from running following a failed Google Sheet lookup. 


The purposed solution is to “add a filter checking the value of “Zap Search was Found Status”

Can someone please elaborate on how to do that? I can not figure out how to add a filter to check for this value.

ModRobotics wrote:


1. switch to setting “Should this step be considered a "success" when nothing is found? “   to true, 
2. add a filter checking the value of “Zap Search was Found Status” .
icon

Best answer by MohSwellam 11 October 2022, 20:48

View original

5 replies

MohSwellam
Userlevel 7
Badge +8

Hi @Wilson 

 

The very last field in the Find Many Spreadsheet Rows or Get Many Spreadsheet Rows is “Should this step be considered a "success" when nothing is found?” with the options Yes and No. The default is No, i.e.: the zap will not continue if it doesn't find the required data in Google Sheets. This is what the other topic is referring to. 

 

HOWEVER, the default is for the zap to stop, if that is what you are looking for? The other thread he wanted to continue one or more steps before stopping the zap. This is why he added this option then the filter. 

 

your zap SHOULD by default stop if it doesn't find the data

Founder of GeekyAir.com
W

Hi MohSwellan, 

Thanks for your help here! In my case, if nothing is found on the spreadsheet, I want the zap to stop and not send a notification. 

For additional context, I am using an RSS feed to be alerted to changes in certain stock symbols on my sheet. If the alerts are not for those symbols, they can be discarded. However, in the event there is a change to a symbol in my database I want to be notified. 

Here is the run data from the last zap on Friday which prompted this post. Nothing was found on the sheet (spirit airlines is not part of our database) However, the zap still continued and sent a slack message. 

 

MohSwellam
Userlevel 7
Badge +8

Hi @Wilson 

 

Sorry for the late reply :) 

 

I see, this means that th Slack message doesn't have any input from the Google Sheets step, I though something was depending on on this step and so this would have worked :) 

 

This is actually easier, you will just add a Filter step under Google Sheets step and above Slack step, the filter will be zap_search_success = True, in this case the zap will not continue if this step fails to find a value in Google Sheet 

Founder of GeekyAir.com
christina.d
Userlevel 7
Badge +9

Heya @Wilson@! Wanted to pop in and see how you were doing with this? Did @MohSwellam’s recommendations get ya sorted?

Keep us posted! 🤗

W

Heya @christina.d -- I think so, I have been waiting to see a test case work in real-time, but I think MohSwellam got me there. 

Reply


Terms & Conditions