How to connect a survey form to a google sheet

How to Connect a Survey Form to a Google Sheet

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

WPForms is the best WordPress Form Builder plugin. Get it for free!

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.

WPForms pricing

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.

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.

install surveys and polls 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.

google sheets addon active

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.

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.

wpforms google sheets integration

Now, you’ll be prompted to log into your Google account to give WPForms access to it. Click Allow, and that will do it.

Google login

When the page redirects back to the WPForms Integrations page, you’ll see that the Google Sheets integration is now connected.

Google sheets account 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.

Add new model release form

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.

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.

Survey-Form-to-create-a-survey-online

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.

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

survey form

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.

new survey spreadsheet

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.

sheet column mapping

Next, choose the form field that you want to sync with the column you chose.

mapping form fields

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.

create new 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).

survey form field mapping

You can check your spreadsheet now and you’ll see that your survey sheet has columns labeled by the fields in your form.

Survey form labels

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.

filled survey form

Now, just open your survey spreadsheet in your Google Drive and you’ll see that the sheet has been updated with your response.

Survey spreadsheet entries

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.

Using WordPress and want to get WPForms for free?

Enter the URL to your WordPress website to install.

Add a Comment

We're glad you have chosen to leave a comment. Please keep in mind that all comments are moderated according to our privacy policy, and all links are nofollow. Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.

This form is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.