Broadcast/trigger/? bot users attributes

(Danylo Burykin) #1

Dear FLOWXO support team and all the community,

I do love Flowxo and quite experienced user, but for some reason dives into it is a bit slowly. PLEASE, advice me exactly what should I put in the flow along with the parameters.

  1. My bot asks a couple of questions and set them as an attribute. I can’t see how to use those answers as a Response Path etc? Please, advice)

  2. After some users have answered those two question I’d like to set following options:

2.1 After new user follows the same way, according to his answers his bot send to some of those users his photo and a link with his name. Which exactly again refers to the attributes. Is this feature about using Trigger a Flow? What would be the expression in the Response Path field looks like if I need to filter the recipient bot users with their attributes according to what they have answered? And what is the expression to make clickable user photo or combine a url address with the attributes?

2.2. Again, after new user follows the same way, according to his answers he receives list or a set of cards of some of those users photos and user names, according to their attributes. What is the expression in the bot message field?

Thank you!!!

Dan)

(Sarah Palombo) #2

Hi Dan

Welcome to the community! Glad your enjoying using Flow Xo.

Just to share some thoughts.

What you’re explaining here (i think), is that a user (Bill) answers some questions. You save his preferences as attributes.Once another user (we’ll call her Sarah :blush:) follows this same process you want to then send Sarah’s Photo (URL and other info) to Bill (and possibly other previous users) - is that right?

This really is outside the scope of Flow XO, you’d perhaps need to use logic outside of Flow XO to match users. for instance save and match users inside a Database. You could then send information back to the bot.

I know lots of users are enhancing their bots using external services to make decisions or to provide the bot with logic.MySQL is an integrated database so that could be an option?

Sarah

1 Like
(Danylo Burykin) #3

Ok. Thank you very much, Sarah! I think I will try to build it via Google Sheets. Anyway, would you give me a tip how to set sending messages to certain users according to specific attributes? And how to put in the message certain data form the Sheet?

(John Steer-Fowler) #4

Hi Danylo,

What you are specifically asking to do is a little complicated and maybe beyond my level of knowledge.

However, I can hopefully shine some light on some of your questions:

  1. My bot asks a couple of questions and set them as an attribute. I can’t see how to use those answers as a Response Path etc? Please, advice)
  • Create a Bot > Question service in your Flow that will ask the user a ‘question’ that will return an ‘answer’
  • Use the Attributes service > Set an Attribute. Click ‘Add’ and for the Attribute ‘Name’ you can type what you want to store the attribute as. For the ‘Value’, click the FlowXO icon and scroll down the list and select the ‘Answer’ from the question you created.
  • To use this attribute in other Flows or with other Services, you can click the FlowXO icon, scroll down the list and select ‘Attributes {}’, this should insert something that looks like this: {{my_flow.attributes}}.
  • To get access the specific attribute value you want, you use this syntax (replace with your own Flow and Attribute Name values: {{quiz_start.attributes__attributename}} (note the double underscore __, not single _)
  1. After some users have answered those two question I’d like to set following options:
  • For the clickable user photo I would recommend using a Bot > Card service. You could populate the url, image and name (title) fields from a SQL database using the My_SQL integration service (specifically using a SQL Query).
  • With regards to how you match the other user’s answers with the original user’s answers, I am not 100% sure and this is probably a bit advanced for me. I would probably experiment with database queries, perhaps populating a RegularExpression (Text Service) or Text Match service. I might even consider looking into using Natural Language Processing (Api.ai or Wit.ai) on the Attribute results to try and match similar responses and then pulling matches from the database. If you work out a solution to this, I would be interested to know how you did it.

I hope this helps a little, I have done some fun and complicated things with FlowXO, but I have never quite gone to the level you are facing here :grinning:

John

1 Like
Trigger Broadcast from new Google Sheets row
(Danylo Burykin) #5

Thank you very much, John. Meanwhile, I’m trying to work out with what you explain, I have some more difficulties:

A. What should response path be looks like? As long as for some reason it works only with strange parameter: {{588632d5ba26560012765193.response_path}}

B. I’m trying to save data into Google Sheet row. It works ok with user entries, but don’t put their data it the row. I’m trying to put user ID, but it save exactly the “{{user_id}}” string, but not the actual number

С. Attributes are displayed the same way((

Thanks!!!

(Danylo Burykin) #6

And one more thing: how to work with Google Sheets “search rows” function? does it returns only number of rows or the array of each certain row cells? How to display a list of them? THANKS!

(Danylo Burykin) #7

And again - the darkest place is still how to deliver the message to every certain user, from retrieved list, whether it can be got via “search rows” or “list rows” function of Google Sheets integration - how to alert/push/deliver user entry to certain users? Or I need to use attributes? Still don’t get where to put them in order to make selective broadcast/push(((

(Sarah Palombo) #8

Me again :blush:

The response path is always caught when a user first speaks to your bot so you then output this in a task to save the response path to a google sheet you’d be choosing to send through the Response Path in your google sheets task.

Not sure what’s going wrong with the user ID are you saying the google sheet has {{USER_ID}} instead of the IS i.e 15344545845 ? … did you click on the XO icon and select the userid from the drop down list to pass this into your google sheet task?

When you use Google Sheets “search rows”, you will get a results count i.e 3 you’ll also have the data from row 1, row 2 and row 3
If you searched for a row you’ll see the results contain a [reply to] You can then use this in your next task.
Send a message back to a user. You’d have to have several tasks if you had 3 results you’d have three tasks to send back messages with filters result 1 etc
For this reason, if you had 100 results (you had 100 people to send a response to, I’d definitely avoid using google sheets

Instead, I’d look again at a way to use attributes and the broadcast and maybe attributes.

If you can email a brief about what you want the bot to do and what you want to send to the user perhaps I can highlight some steps :smiley:

Feel free to reach out by emailing support@flowxo.com if you need help