How to compare domain and links

(Mike Wow) #1

Hello!
Kinda complicate to explain, but I’ll try to make it simple.

So we expect users to send bot a links, for example https://flowxo.com/c/questions/l/new
And bot should compare it with a Google Sheet table and if it finds something like “flowxo.com” in a column, it should respond to user with next column.

So in sheets we have something like:
google.com | Respond 1
flowxo.com | Respond 2

If user asks “flowxo.com/smth/smthmore” he gets Respond 2.

Is it possible with flowxo? And if yes, how to do it?

Thank you so much!

#2

Hi @MikeWow,

start read this https://support.flowxo.com/article/35-google-sheets
the there are 2 interesting lessons on https://medium.com/flowxo:

(Karen Barker) #3

Hi Mike,

Yes this would be possible.

You’ll be able to use our Google Sheets integration to search one column for the value the user sent. This would need to be an exact match to what is stored in the sheet though. The search will bring back any matching results. you can then use collection outputs to use the value from the next column.

We have a couple of tutorials on using Google Sheets with Flow XO here:

Hope this helps. :slight_smile:

1 Like
(Mike Wow) #4

Thank you for the replies, but unfortunately it didn’t help. I’ve already read all of those.

Karen, you say that “This would need to be an exact match to what is stored in the sheet though”. My question is about situation in which user’s message not exactly the same as value in column.

Again, its if user send “https://flowxo.com/c/questions/l/new” and it should find column that contain “flowxo.com”.

Are you saying there is no way to do it with flowxo?

(Karen Barker) #5

Hi Mike,

Using our built in integration with Google Sheets then no there is no way to search on the field contains this value.

There are 2 workarounds that you could explore:

  1. Use the list rows option which will give you all data in your Google Sheet and then you’d need to write some custom javascript code to create a “Contains” search and return the valid row.

  2. I’m not sure whether the Google Sheets API itself supports searching for a field that contains a particular value. If it does you would be able to use the Webhooks feature in Flow XO to add this functionality.

(Mike Wow) #6

Ok thank you very much.