How to Save Contacts From WordPress Forms to Google Sheets

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

Here’s a table of contents if you’d like to skip ahead:

  1. Integrate WPForms With Google Sheets
  2. Connect WordPress Forms to Google Sheets
  3. Create a Spreadsheet and Import Entries

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.

Let’s go ahead and get started with exactly how to do this.

How to Save Contacts From WordPress Forms to Google Sheets

Here’s a video showing the process from start to finish:

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

If you’d prefer to read along, follow these steps to connect your contact form to a Google spreadsheet.

Step 1: 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 2,000+ 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.

Step 2: 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

Step 3: 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

In Conclusion

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.

Using WordPress and want to get WPForms for free?

Enter the URL to your WordPress website to install.

Comments

    1. Hi there!
      This is on the list of features, however, I don’t have any ETA on when this can be developed.
      Have a good one 🙂

      1. Hey there – I am afraid this feature is not available yet, I will go ahead and add your vote to the feature request though.

        Sorry for the inconvenience.

  1. Hey there !
    Such a great work !

    Do you know if there is any possiblity to add {page_url} field in zapier ?

    Best regards

    1. Hey Randy – Glad to hear that you liked this tutorial. As Zapier addon will send any of your fields to Google sheet, for sending page URL to Google sheet, you can add a hidden field in your form and give its default value as {page_url} and then you can pass this field to Zapier.

      For further help on this, I would suggest contacting our support team.

      Have a good one 🙂

    1. Hey Minh, thanks for reaching out!

      I totally understand that Zapier might be an expensive option for some projects. Please note that we already have a feature request for direct integration with Google Sheets. I have gone ahead and added your vote to the feature request.

      In the meantime, the closest workaround would be to export entries to CSV. We have a step-by-step tutorial here.

      If you have any more questions please feel free to contact our support team.

      Thanks! 🙂

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.