The simplest solution is to connect Botnation to Google Sheet via the Zapier connector. You will be able to export your data collected during the conversation to a Google Sheet.
How to do :
First and foremost: You must have an account on Zapier
1 - Create your conversation flow
2 - Use the "Webhook" function once the variables that interest you (first name, mail, phone number, etc. collected)
3 - Copy paste the "webhook" that Zapier will have communicated to you. Do not forget to test your bot for validation on Zapier.
4 - Connect Zapier with your Google Account to feed the Google Sheet and configure it.
5 - it's done! Your zap is connected. You will automatically receive the data collected by your chatbot in your google sheet.
📺 Because a video tells much more than talking, I recommend you to look at this:
💡 Having a hard time creating your zap at Zapier?
Here are the steps to connect your Google Account and get the data from your chatbot at Zapier.👇
1- Click on "Make a zap" to create your zap.
2- Click on “Webhooks”.
3- Select "Catch Hook".
4 - Copy the URL of your webhook then click on "continue".
5- Click on "continue".
6- Your webhook is created. You just have to connect your zap to a Google Sheet. It couldn’t be easier.
7- Click on "Google Sheets".
8- Select "Create spreadsheet row" and click on "continue".
9- Select your Google Sheets Account.
10- Once you have selected your Google Sheets Account, create your Google Sheet by choosing the name of your column which variables to use...