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.

  • Home
  • Get Help
  • Troubleshooting
  • Failed to find a spreadsheet row in Google Sheets: Error from halted execution; nothing could be found for the search
Best answer

Failed to find a spreadsheet row in Google Sheets: Error from halted execution; nothing could be found for the search

  • 23 June 2023
  • 5 replies
  • 324 views
Skippy

I have 1 zap that creates a Google Sheet spreadsheet row (below) that works perfectly. In that zap I have an action that sends the phone number to storage by zapier for later use.

 

My issue is with a 2nd independent zap whereas when performing lookup Google sheet spreadsheet row (below) using the phone number (from storage) it returns:

Failed to find a spreadsheet row in Google Sheets

Error from halted execution: Nothing could be found for the search.

 

Here’s a screenshot of my Google Sheet:

 

icon

Best answer by Skippy 23 June 2023, 17:55

View original

5 replies

GetUWired
Userlevel 7
Badge +12

Hi @Skippy 

My first inclination here is to test if the “+” in front of the phone number. It may be causing the issue as it would not match identically.

I would do a few tests to see if that is the case.

Skippy

I thought the same thing. When you click on the field the + shows in the formula bar. I just ran another test whereas I put the number in the phone field of the 1st zap (which is fine for troubleshooting but would never work in practice). then tested my lookup action in the 2nd zap and got the same failed result. 

GetUWired
Userlevel 7
Badge +12

In the second zap with the lookup step, could you replace the mapped field with a static value of a number you want to search for?

 

By that I mean, you would change

to look like this where the number would be an exact match of what is in the spreadsheet.

Then test the action.

Skippy

I just solved it! In the 1st zap I used formatter to do away with any country codes and it worked. Thanks for the input.

ken.a
Userlevel 7
Badge +6

Hi @Skippy,

Awesome! Glad to hear that you solved the issue with the help of GetUWired.

If you have any other questions, please don’t hesitate to ask in the Community. We’re always happy to help! 😊

Reply


Terms & Conditions