Search Group Phrases in Google Spreadsheet

(Sarah Powers) #1

I reviewed the tutorial where you list the group name and answer.

However, I’d actually like the Google Spreadsheet to house the list of potential user responses the group is listening for. Is there a way to do this? It would be a bit more manageable as I get feedback from users to look in a spreadsheet for the queues I’m listening for and have a sheet per group to manage better.



(Daniel Beckett) #2

Hi @Sarah_Powers

You could do something similar by having a list of key words and phrases setup in one column on the sheet and then the ‘group’ names on another column. When the flow is triggered you could then search for the word or phrase and pull back the group - from that point it will all depend on filters in your flow.


(Sarah Powers) #3

Hi Daniel,

OK that’s interesting! If I get it going I’ll send back some screenshots. :slight_smile: