Google sheets!how to make search rows from 3 columns

(Coli Fo) #1

Hi… I have a problem…I have more than 100 hotels on my site. My chatbot asking customer to which hotel customer is interested, and then customer choosing he can ask a question about that specific hotel. If im using google sheets with Q & A columns then I need to have in total 200 steps in my flow with 100 google sheets and 100 send message actions… I tried to have 1 google sheet with Hotel name, Q and A columns…and 1 send message action… but then I cant find how to make it right…because I need “Send message” like this: Text (is the Answer from google sheets column Answer)… but answer should be from correct row, I mean should match hotel name and question: i.e.
hotel name Q A
AA Rooms 100
AA Gym Yes
BB Rooms 50
BB Gym No

So If customer typed name of the hotel : AA , and asked Gym, system should show the answer Yes…

or is there any other way, to make bot answer to the same questions, but about different hotels?

(Daniel Beckett) #2

Unfortunately there’s no way to search based on multiple values. If you had a sheet setup with each hotel and the facilities it has then you could return all results for those hotels.

For example, the first column would be the hotel name, second column would be number of rooms, third column Gym = Yes or No etc.

This way you could either bring back all the information for a specific hotel by searching for its name or setup multiple actions that bring back a specific answer.