Is searching, matching, and grabbing all data in a Google Sheet row based on a phone number possible?

I have an integration i’m planning to build later today. Just wanted to see if the following was possible.

I have a lot of property owner data within a google sheets.

I’m planning to have a (changing) phone number. That needs to be searched and matched to the existing one within a google sheet.

Next I need all the data within that specific row with the matching number. To be grabbed and sent to the next step.

Is this possible? Thanks in advance

Page 1 / 1

@Ali3332

One option would be to create Paths.

One Path per column to search.

Paths require a Zapier Pro+ plan.

@Troy Tessalone If I add another two lookup steps.. And for example, the number is found within the first lookup step. Will that mess up the zap?

Okay ill try that thanks for the quick reply. Congrats on almost 15,000 replies

@Ali3332

You can create multiple lookup steps.

Alternatively, if you use Airtable instead of GSheets, you can use a Search Formula in the Find Record action.

@Troy Tessalone Now i’m creating the integration however. I’m runnning into an obstacle…

I need to search multiple columns, not just a single one. For example. I have multiple columns

I phone Phone number 1 , Phone number 2, Phone number 3, Phone number 4, & 5 searched to find the right match.

However I see it only shows two for the lookup columns.

Should I create a second search step including the next columns?

Hi @Ali3332

Good question.

Try this Zap action: GSheets - Lookup Row

Sign up