Hi all,
I’m trying to add in my bot a search action in google sheets.
There’s a way to search a cell inside a sheet in this way?
For example:
BOT: What is your place of departure?
USER: Start place 2
BOT: What is your place of arrival?
USER: Arrival place 2
BOT: To get to PLACE 2, you have to take BUS NUMBER 2
Thanks to all!
You can get a row from the Google Sheets selected by the search criteria you provide in a query.
Try Google Sheets and choose ‘Get a row’ in the actions list. Then point to the spreadsheet and worksheet to look in, pass by Row ID and fill the criteria below: ‘Column’ and ‘Value’. It will return the row where the value in a column will match yours. Then you can deal with the row and get what you need from it.
You need to organise your worksheet properly, of course, so that such a search gives you the info you need.
Thank you a lot, Peter.
Can you tell me if I can find some example flow?
Well, everything I had to base my first knowledge on is in the manual: http://support.flowxo.com/article/35-google-sheets
Below is a sample screenshot of the action I used to test the Google Sheet. I has a Spreadsheet called allcources and the worksheet with the same name in there. Yes, I know it is misspelled. 
Sorry.
There are a lot of (over 20) columns there and one is called Area_6. So what this example does is it selects a row where the value in the Area_6 column equals 1 and outputs this row to me.
