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

Hi @Ali3332

Good question.

Try this Zap action: GSheets - Lookup Row

@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?

@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.

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

@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?

@Ali3332

One option would be to create Paths.

One Path per column to search.

Paths require a Zapier Pro+ plan.

Sign up