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...

Avez-vous trouvé votre réponse?