Create a Survey and Export the responses to a Google Sheet (Part 1)
Have feedback on this article? Email product@mobilemonkey.com
In this two-part guide, we'll walk through how to create a survey in your MobileMonkey Chatbot, then export the responses using Zapier to a Google Sheet.
Part 1 of the guide focuses on creating the survey and exporting the raw data to a CSV. In Part 2, we'll go over how to set up an ongoing sync to the Google Sheet.
Step 1: Create your Survey dialogue from a Comment Guard (or any Chat Starter)
There are lots of different places you might want to conduct a survey, but a popular way in MobileMonkey is to use a Comment Guard, which sends a private reply to any user who comments on your Facebook post(s).
Navigate to:
- Chatbot
- Chat Starters
- Comment Guards
And click Create Comment Guard
(Tip: you can also follow the rest of these steps to make a survey on a Messenger Ad, Facebook Page Welcomer, Customer Chat Widget, Share Link, and more)
![](https://files.helpdocs.io/jlaj445u4q/articles/ewsi7awo9a/1594755843740/image.png)
Give your Comment Guard a name and choose which posts to respond to
Give your Comment Guard a memorable name! For this example, I'm going to have my Comment Guard respond to all posts, but you can narrow down to a single post if you'd like.
![](https://files.helpdocs.io/jlaj445u4q/articles/ewsi7awo9a/1594757479845/image.png)
Update the first question in the Comment Guard dialogue
Change the first Quick Question in the Comment Guard Dialogue to ask the user if they want to take a quick survey
![](https://files.helpdocs.io/jlaj445u4q/articles/ewsi7awo9a/1594757599547/image.png)
Create the Survey Dialogue
If they respond with Yes, then take them to a new Dialogue -- use the + New Dialogue button in the dropdown to create your Survey dialogue
![](https://files.helpdocs.io/jlaj445u4q/articles/ewsi7awo9a/1594757736686/image.png)
Step 2: Add your Survey Questions
Now for the fun part!
Use the widget adder to add as many survey questions as you'd like:
![](https://files.helpdocs.io/jlaj445u4q/articles/ewsi7awo9a/1594757840368/image.png)
In each question, ensure you are saving the answers to an attribute
You can use a mix of Multiple (for provided answers) and Text (for freeform) User Replies in your survey.
![](https://files.helpdocs.io/jlaj445u4q/articles/ewsi7awo9a/1594757951031/image.png)
Step 3: Test your survey and activate your Comment Guard!
You can test your survey first by clicking the Preview button at the top of the Page
![](https://files.helpdocs.io/jlaj445u4q/articles/ewsi7awo9a/1594758216275/image.png)
If it doesn't come out like this, then contact support@mobilemonkey.com for help!
![](https://files.helpdocs.io/jlaj445u4q/articles/ewsi7awo9a/1594758262474/image.png)
Next up, just activate your comment guard and you are off to the races!
![](https://files.helpdocs.io/jlaj445u4q/articles/ewsi7awo9a/1594758315663/image.png)
Step 4: Export your survey responses to a CSV
Once you have some survey responses, you can export them to a CSV from the Leads tab
![](https://files.helpdocs.io/jlaj445u4q/articles/ewsi7awo9a/1594758403176/image.png)
The CSV will be sent to your email where you can download it and import it into your favorite spreadsheet software for further charting an analysis.