I’ve just been given a list of 100+ categorised website links / title / description that I need my bot to be able to recommend as responses to certain questions. I was just wondering if anybody had thought of a way to use Google sheets or something to search and retrieve a response, rather than me having to input every single one as a ‘Card’ and then using conditional logic to find and retrieve them that way. It could take me weeks if I have to input them all manually! 
Using Google Sheet to search / list a directory of links
pete_nexus
(Pete)
#1
johnjackson
(John Jackson)
#2
What you need to do here is use the Google Sheets search method and search for some field value based on the message received.
You’ll get the whole row back so can pick out the cols in the row that hold the info and feed that into your send a card action.
Usually you’d use a catch-all to trigger it.
The details would depend on exactly what you need to do but this is the basic idea.
1 Like