Scenario: I have a google sheet that has two columns, phone number and name:
I want to be able to lookup the name based on the phone number.
Using a google sheets node, I'm able to grab the data as an array:
Now, I'd like to be able to search through all of the sub-arrays using a phone number and find the matching name that corresponds to it.
To say it another way, I already have the phone number (in this case an incoming text from Twilio) and I want to be able to look up the name in this sheet using that phone number regardless of its position in the sheet. (to eventually use it in a customized response - that part I can handle, I'm just stuck on how to search through and find the match.)
Any ideas on the best way to accomplish this?