WPForms Blog

WordPress Tutorials, Tips, and Resources to Help Grow Your Business

How to Save Contacts From WordPress Forms to Google Sheets

by Shahzad Saeed on Sep 5, 2017

Want to monitor your form entries in a spreadsheet? When you connect WordPress to Google Sheets, you and your team members can easily sort through and analyze the data. Here’s how to send data from your WordPress form to a Google Sheet.

Saving Form Entries in Google Sheets

A few benefits of saving form entries in Google Sheets are:

  • Easy team collaboration: Your team members can easily monitor form entries. You don’t need to provide login credentials to your WordPress dashboard.
  • Quick data analysis: Generate personalized reports based on the data your visitors submit and make informed decisions quickly and easily. For example, if you’re creating a poll, you can easily interpret the user inputs by connecting them with Google Sheets.
  • Save entries automatically: You don’t need to enter the form entries by hand. Simply connect your form with Google Sheets and all the entries will be saved automatically.

Integrate WPForms With Google Sheets

To add your form entries to Google Sheets, the first thing you need to do is to install and activate the WPForms plugin. Here’s a step by step guide on how to install a WordPress plugin.

After the installation, you’ll need to create a simple WordPress form. You can see our tutorial on creating a simple contact form in WPForms. Let’s rename the form as Google Sheets for the sake of this example.

rename form as google sheets

In order to import entries into Google Sheets from your form, you’ll need to install and activate Zapier addon on your site. The Zapier addon lets you connect your WordPress forms to over 500+ web apps, including the Google Sheets app.

For more help with this step, you can check out our tutorial on how to install and use the Zapier addon.

Now let’s take a look at how to connect WordPress forms to Google Sheets.

Log into your Zapier account and click the Make a Zap button in the top navigation.

WPForms connecting to Zapier

Then, follow Zapier’s step by step guide to create a Zap. To see screenshots of every step, you can refer to our tutorial on using Zapier with WPForms.

Make sure to choose the Google Sheets form you just created, when you’re asked to setup Edit Options. You must have at least one test entry on your form before fetching existing entries.

You should then see a successful confirmation message.

Connect WordPress Forms to Google Sheets

After connecting Zapier to the WPForms plugin, you’ll need to connect WPForms to Google Sheets.

The first step is to choose Google Sheets as the action app. Enter Google Sheets in your search bar, and then, click on it when it shows up.

choose google sheets as action app

Then, you’ll be asked to select Google Sheets action. As we are looking to add form entries to Google Sheets from WordPress, let’s choose Create Spreadsheet Row and click Continue.

select google sheets action

Now you need to connect your Google account to Zapier. To do this, you’ll need to authorize Zapier to access your Google Sheets data. After authorizing it, click Continue.

select google sheets account

Create a Spreadsheet and Import Entries

Before you can import the form entries to your Google Sheets, you’ll have to create a new spreadsheet by logging into Google Sheets.

You’ll also have to add new rows in your spreadsheet so that form entries can be configured with the corresponding row.

create a spreadsheet with Google Sheets

Now go back to your Zapier account. You’ll be asked to specify the name of the spreadsheet and worksheet. Once you specify them, you’ll be shown the rows you just created in your specified spreadsheet. Make sure to connect each form field to the appropriate Google Sheets field. After connecting them all, click Continue.

set up google sheets row

If you want to test what data has been updated in Google Sheets, click on Test. You’ll now see the data just like the screenshot below. Click Create & Continue.

test google sheets

You’ve just tested Google Sheets app on Zapier successfully.

You may login to your Google Sheets account to verify the updated data.

test form entries in sheets

In the final step, make sure to turn on your Zap. You can also give your Zap an appropriate name. By turning on Zap, you can automatically send all future form entries to Google Sheets whenever your visitors submit the form on your site.

turn on zap

Congrats!

You’ve just connected your WordPress form with Google Sheets. All the future entries will be added to the specified spreadsheet in Google Sheets.

Do you want to encourage form submissions on your site? Check out how to create a popup feedback form in WordPress.

What are you waiting for? Get started with the most powerful WordPress forms plugin today.

If you like this article, then please follow us on Facebook and Twitter for more free WordPress tutorials.

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.