Pulling in data from external sources

#1

Newbie question but I have a single flow that will be use across customers.

Rather than setting up/copying/replicating flows for each customer is there a way I can pull data from something like Google Sheets?

So, for example, in response to dietary options for restaurants, I have 5 restaurants that will have 5 different responses to the same question (yes the flow is static).

Is there a way to pull sheets cell data per customer? So I am working with customer number 2 and all of their variable content is held in row 3 of Sheets, is there a way of pulling the data specific to this customer in this way?

TIA,
John

(Daniel Beckett) #2

Hi John,

What information are you using to determine which restaurant will be responding to the customer? You may not need to use Google Sheets since you could filter responses based on the restaurant.

For example, you could use Bot > Ask a Question > "What Restaurant would you like to eat at?" that presents the 5 options to the user. You can then have Bot > Send a Message > *Restaurant 1 response* filtered on the user’s previous answer being equal to "Restaurant 1".

With that said it’s still certainly possible to use Google Sheets for this. You could separate restaurants into individual worksheets or rows and then have the responses listed under columns - a dietary column for example, and then use Collection Outputs to filter results from Get Row. Again, you would need to know the desired restaurant for this to work.

If you’re still having trouble getting this to work then I’d suggest emailing us at support@flowxo.com with a brief explanation of what your bot needs to do, how you picture the user interaction going and the end result required. You can also share your flow by clicking the ‘Private’ button at the top right of your flow editor.

Thanks,
Dan

1 Like
#3

Thanks a mill for that Dan, I’ll have a bash at this tomorrow. If I get stuck I’ll get on to your support team but thanks a lot.

John