Exporting Messenger bot answers to a Google Sheet

(Ollie) #1

Hi there,

I’m trying to set up a flow which exports all the answers that user’s give to my bot’s questions into a Google Sheet, with each answer in a different column.

I’m sure this is possible using the Google Sheets integration, but I can’t quite work out how.

Can anyone help?

Thanks!

(Kellsey Shaw) #2

Hi Ollie,

All you need to do is add a task for Google Sheets > Add a Row and when you’ve connected your Google sheets account and select the book and sheet that you want to use our system will create an input form with all the available columns so that you can pop in your bot answers (you can select outputs such as the question answer from a list using the Flow XO icon to the right of the input field).

(Ollie) #3

Perfect - thank you!