How to Save Contacts From WordPress Forms to Google Sheets

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.

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

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 1500+ web apps, including things like Salesforce, Jira, and 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


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.

Using WordPress and want to get WPForms for free?

Enter the URL to your WordPress website to install.


  1. Thanks for reading this article – I hope you found it helpful.

    I wanted to let you know about our new WordPress survey plugin that allows you to build interactive polls and surveys within minutes. You also get best-in-class reporting, so you can make data-driven decisions.

    You can get it 100% free when you purchase WPForms Pro plan.

    Get Started with WPForms Today and see why over 2 million websites choose WPForms as their preferred online form builder.

    Syed Balkhi
    CEO of WPForms

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.