Are you wondering if it’s possible to integrate a Google spreadsheet with a survey form on your website?
The answer is yes! If you have a WordPress website, you can easily connect a survey form to a Google Sheet.
In this article, we’ll show you all the steps you need to set this up!
Create Your WordPress Survey Form Now
Can You Make a Survey in Google Sheets?
No, you can’t directly make a survey in Google Sheets. However, you can send responses from a survey builder tool to Google Sheets. This allows you to maintain a record of all of your survey responses in a spreadsheet so you can analyze and sort your data the way you see fit.
How to Connect a Survey Form to a Google Sheet
Step 1: Install WPForms With the Surveys and Polls Addon
WPForms is the best WordPress plugin for creating surveys and polls. It allows you to build survey forms and generates survey reports with visual charts and graphs that can be viewed from the WordPress admin area.
What’s more, you can connect your survey forms with Google Sheets for additional data storage and tracking.
To get started, you’ll need the WPForms Pro license, which allows you to easily build a survey form using a number of useful fields like the Likert scale, Rating field, Radio buttons, and so on.
You can install WPForms by downloading the plugin from your WPForms account area and then uploading it to your site. If you’d like a bit of help with this, take a look at this guide to installing wordPress plugins for beginners.
Once you have WPForms Pro installed, you’ll need to activate the Surveys and Polls addon. To do this, simply head over to the Addons page by clicking WPForms » Addons.
Scroll down till you find the Surveys and Polls Addon — you can search for it using the search bar too, then click Install Addon.
That’s all you need to do for now. Next, we’ll install and set up the Google Sheets addon before we create our survey form.
Step 2: Install and Connect the Google Sheets Addon
WPForms Pro includes the Google Sheets addon, which allows you to integrate your WordPress forms directly with Google Sheets. With Google Sheets connected, you’ll be able to create forms that send data to a spreadsheet automatically.
To install the Google Sheets addon, follow the same steps as before by heading into the WPForms addons page and then activating the Google Sheets addon once you’ve found it.
There’ll be one extra step to get it working, though. Head over to the Integrations tab of the WPForms settings dashboard.
You can get here by clicking WPForms » Settings » Integrations.
Scroll down till you see Google Sheets, then click on it.
You’ll now see the option to activate the integration. Click Add New Account.
Now, you’ll be prompted to log into your Google account to give WPForms access to it. Click Allow, and that will do it.
When the page redirects back to the WPForms Integrations page, you’ll see that the Google Sheets integration is now connected.
Now, we can get on with creating a survey form and connecting it to a Google Sheets spreadsheet.
Step 3. Create a Survey Form
At this point, click on WPForms » Add New.
Both options will take you to the WPForms template library, where you’ll be able to either choose one of the 500+ pre-built form templates or click on Blank Form to build a form from scratch.
And if you’re pressed for time, you can simply use the WPForms survey form template.
When you open the Survey Form Template, you’ll now see your form template on the right of the screen, with additional form fields on the panel on the left.
To add form fields to your form, you can simply drag and drop them onto the template.
The survey form template already has most fields that you’d need for a regular survey, so we’re not going to make any changes to it. But if you’d like to customize yours, here’s a handy guide to creating survey forms to get you started.
Step 4. Connect Your Survey Form to a Google Sheets Spreadsheet
Now, we’re ready to connect this form with Google Sheets. To do this, we’ll simply navigate over to the menu on the left of the form builder, and click Settings » Google Sheets » Add New Connection.
You’ll need to enter a nickname for the new connection. For this guide, we’ll just call ours Survey Form and then press OK.
There are two ways to proceed. If you already have a spreadsheet created to collect survey results, you can connect this sheet now. But if you don’t, the WPForms Google Sheets integration allows you to create one from right within the form builder.
If you do have an existing spreadsheet that you’d like to connect your form to, click on the Spreadsheet dropdown and choose the spreadsheet you want to use. You’ll also have to choose the worksheet within the spreadsheet where you want to send your form data.
Once this is done, you can set up form field mapping, which allows you to specify which column in your spreadsheet should receive data from specific fields on your form.
One thing to remember is to always keep the first column in your sheet free for the automatically generated Entry ID data. To set up form field mapping, scroll down to the Field Mapping section.
Select the column that you want to be mapped to a form field.
Next, choose the form field that you want to sync with the column you chose.
Once you save these settings, that will be all. Your survey form will now send survey entries to the Google spreadsheet you selected.
If you don’t already have a spreadsheet set up for your survey form, it’s super easy to set one up. Click on the Spreadsheet dropdown as we showed before, but this time, select Create New Spreadsheet.
You’ll need to enter a name for the spreadsheet and for the sheet you want to use within the spreadsheet.
As before, you can then go through the steps to map form fields to columns. We’re leaving off the name and email field since this might not be useful for your data analysis, but you can include them if you prefer (you can click the Entry ID links to directly view all the entry details from your WordPress dashboard).
You can check your spreadsheet now and you’ll see that your survey sheet has columns labeled by the fields in your form.
At this point, we’re all set up with a survey form that’s connected to a Google spreadsheet. Let’s see how this works when we go live with the survey form!
Step 5. View the Results!
After the steps above, we’ll need to publish our form and then create a test entry to see how it all works. If you need a bit of guidance with this step, here’s our guide to embedding a contact form on a page in WordPress.
Once you’ve published your form, go ahead and submit an entry as a user would.
Now, just open your survey spreadsheet in your Google Drive and you’ll see that the sheet has been updated with your response.
And that’s it! You now know how to connect a survey form with Google Sheets using WPForms.
Next, Protect Your Forms With hCaptcha
The last thing you want is to have spam entries mess with your data collection and analysis when you connect your survey forms to Google Sheets. One way to do this is by protecting your site using hCaptcha.
And if you’d like to explore some of the other powerful spam-blocking tools that WPForms offers, check out our guide to preventing bots from filling out your forms.
Create Your WordPress Survey Form Now
Ready to start building WordPress forms? Get started with the easiest-to-use WordPress form builder plugin today. WPForms Pro includes a free file upload feature and free file upload form and offers a 14-day money-back guarantee.
And don’t forget, if you liked this article, then please follow us on Facebook and Twitter.