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 Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Apps 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.

Question

Find all partial matches for lookup of Google Sheets rows

  • 8 December 2021
  • 6 replies
  • 434 views
D

I have a Google Sheet full of country codes (of various sizes) and am looking to create a Sheets lookup to find what country a clients’ number falls under.

In my search, I have found solutions for finding exact matches - but not partial.

Since the country codes are of various lengths, I cannot truncate the clients’ number and expect a match - as it might be eating into the country code.

Therefore, is there a way where I can use Zapier to search if the country code is contained within a clients’ phone number?

Been running into a few issues trying it out, as it seems the “Lookup spreadsheet row” in Sheets is only for exact matches.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

D

I’ve also found the “Lookup Many” rows - but the max limit is 20. 

My spreadsheet has 200+ rows & I want to keep my Zap as efficient as possible (i.e. I dont want to do a lookup 10 different times to fulfil the 200+ rows)

Troy Tessalone
Userlevel 7
Badge +14

Hi @Daniel Galea 

Confirming the GSheets Lookup Row(s) Zap actions work on exact matches.

 

Are you able to provide a few different examples for us to have more context about the input data and expected output data (match)?

 

You may want to consider using Airtable instead of GSheets: https://zapier.com/apps/airtable/integrations

Airtable has a Find Record Zap action that can use an advanced Search Formula: https://support.airtable.com/hc/en-us/articles/218151657

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
D

Please see attached list of country codes I have put in Airtable.

If I have a clients’ phone number, e.g. starting country code +93 (Afghanistan) - I want to search the whole Airtable and find which Country it relates to.

However on Zapier, this is difficult to do - as some country codes are longer than others, i.e. I cannot truncate the clients’ phone number.

Hence the partial match, yet I cannot see how to search for a partial match

1 Attachment
D

E.g. search spreadsheet for “+5512992”, and +55 would come up as a partial match & output the country

D

So it’s kind of doing a backward search - i.e. not searching the spreadsheet for a country code, but the whole value & outputting a partial match that it fits under

Troy Tessalone
Userlevel 7
Badge +14

@Daniel Galea 

How do you intend on handling countries that share the same country code?

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions