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 😁
+14
Hi
Good question.
Try this Zap action: GSheets - Lookup Row
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?
+14
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 😁
+14
One option would be to create Paths.
One Path per column to search.
Paths require a Zapier Pro+ plan.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
