Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

  • Home
  • Get Help
  • How Do I
  • Google Sheet Lookup Step success/fail result not showing up in subsequent filter options unless "Create Row if nothing exists" is selected

I have multiple zaps that use the Google Sheets look up row action and previously, I could use whether the look up was successful or not in a later filter or path, but now it is only giving me that option if I also choose the “Create row if nothing exists” option, which I don’t always want. Otherwise the “Zap Data Was Found” filter for that look up action doesn’t exist.

I have the “Should This Step Be Considered A "success" When Nothing Is Found?” setting set to True. Has something changed in how the look up action results are able to be used in filters or has something gone wrong?

Hi @AshleighDLC 

The Zap will now return this data point that can be used in Filters

 

Hi @Troy Tessalone 

I just checked one of my zaps again and it is still doing the same thing. Unless I check “Create row if none exists”, it does not return a search result status to use in a filter. 

I have attached some screen shots. I left Action 3 as is, without the create row box checked, and in the filter did several field searches that should have brought up the look up result and you can see nothing comes up. 

Then I changed Action 4 (which is normally set up the same way as 3) by checking the create row box, and you can see in the filter search that the look up result comes up immediately. 

When I first opened this zap to make an adjustment, the filter dropdown where I had previously entered the zap look up result in was empty. I have multiple zaps that use a filter like this and I’m concerned that they may be filtering incorrectly if this isn’t working.

@AshleighDLC 

I was able to replicate the use case.

I’ve gone ahead and flagged this post for the Zapier Team to review.

I’ve also submitted a ticket to Zapier Support on your behalf here: https://zapier.com/app/get-help

@AshleighDLC

Here’s the response I got from Zapier Support:

I took a look a the article and I was able to reproduce it as well.

It looks like it's a platform level issue as I could reproduce with Airtable and Google Sheets searches.

I don't think it was intentional.

I've gone ahead and created a bug report so that we can look into this and we'll notify you automatically when it's resolved.

Hi @Troy Tessalone  Thanks for that. When they say that they will update automatically, will that update also go to me?

@AshleighDLC 

Not sure since I opened the ticket, but mentioned this Zapier Community article indicating you were the original reporter.

You can always reach out to Zapier Support to have them make sure you are included on the update statuses.

Hi @AshleighDLC!

I’ve added a link to this thread in that bug report, so an update should be posted here when that’s been resolved :)

Just wanted to let everyone on this thread know that this issue has been resolved! You should no longer be running into this problem 🙂 If for some reason you continue to experience this bug, please contact our Support team to let them know.

Terms & Conditions