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 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. Create a Form and a Spreadsheet
    2. Integrate WPForms With Google Sheets
    3. Connect WordPress Forms to Google Sheets

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

Follow these steps to connect your WordPress forms to a Google spreadsheet.

Step 1: Create a Form and a Spreadsheet

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.

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

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.

Here’s an example:

create a contact form

Next, you need to create a spreadsheet in Google Sheets.

google spreadsheet example

Set up your spreadsheet to match the fields in your WordPress form. As you can see in the example above, our form has 3 fields: Name, Email, and Message/Comment. So, our spreadsheet is set up the same way.

Now that you have a form and a spreadsheet, it’s time to connect them.

Step 2: Integrate WPForms With Google Sheets

In order to import entries into Google Sheets from your form, you’ll need to install and activate Uncanny Automator on your site.

uncanny automator

Uncanny Automator lets you put your entire website on autopilot. It works by connecting your existing plugins together and creating “recipes” to automate routine tasks.

With Uncanny Automator, you can connect your WordPress forms with tons of other tools and plugins like the Google Sheets app, Slack, Zoom, MemberPress, WooCommerce, Mailchimp, and much more.

After installing and activating Uncanny Automator, you need to connect it to your Google Account.

To do that, go to Automator » Settings » Google from your WordPress dashboard. Then, click on the Connect an account button.

connect google account

Then, simply follow the standard Google authorization process.

First, choose the Google account you want to use. Next, click Allow to grant Uncanny Automator the permission it needs.

click allow to connect google and uncanny automator

Lastly, confirm your choices by clicking the Allow button again.

When you’re done, you’ll be taken back to the WordPress dashboard and see a success message that looks like this:

success message after connecting google

Step 3: Connect WordPress Forms to Google Sheets

Now you need to connect WPForms to Google Sheets using Uncanny Automator. To do that, you first need to create a new recipe.

1. Create a Recipe

To create a new recipe, go to Automator » Add new.

select recipe type uncanny automator

You’ll then be prompted to choose a recipe type. There are 2 options:

  1. Logged-in – Choose this if only logged-in users will fill out your WordPress forms.
  2. Anonymous – Choose this if anonymous visitors will be filling out your forms.

In most cases, you should choose Anonymous because anonymous website visitors will be the ones filling out your contact forms, registration forms, newsletter forms, etc.

So, select Anonymous and then click the Confirm button.

On this page, you can also name your recipe to help you remember it easier.

2. Choose Your Trigger

Next, you need to choose the trigger for your recipe. Select WPForms from the list of integrations.

select the wpforms integration in uncanny automator

Now you’ll see 2 options to choose from:

  1. A form is submitted – Add all WPForms’ submissions to a specific spreadsheet in Google Sheets.
  2. A form is submitted with a specific value in a specific field – Only add submissions if they meet the criteria (conditional logic).

select trigger

For this tutorial, we’ll select A form is submitted to add all form submissions to a Google Sheet spreadsheet.

The next step is to select the specific form on your website that you want to use from the dropdown menu.

select the wordpress form you want to use

When you have selected the form you want to use, click Save.

3. Configure Your Action

After selecting the trigger, you need to choose the action, which is adding a row to Google Sheets.

Because we chose to create an anonymous recipe, we need to create a Subscriber user in WordPress. This acts as a placeholder to route the data through.

For help with this step, here’s how to add a new user in WordPress.

When you create a new user, make note of the user ID. When you edit a user, you can find the user ID in the URL in the address bar, like this: /wp-admin/user-edit.php?user_id=241.

Now, choose Existing User underneath the Actions will be run on…section.

select existing user

Next, an area will pop up where you can set the user data. Select the ID field and make the value the placeholder user ID you created earlier. Then, choose Do nothing.

It should look something like this:

add action

Then, click on the Add action button below.

Choose Google Sheets from the integration list:

select the google sheets integration

Now select Create a row in Google Sheet:

select google sheet action

Next, choose the spreadsheet you created for your form entries from the dropdown menu. Or, type the name of your spreadsheet in the search bar to find it.

Once you’ve selected your spreadsheet and worksheet, click the Get Columns button.

click get columns button

Now the columns from your actual spreadsheet will appear. To map the fields from your form to the columns in the spreadsheet, you can insert dynamic tokens.

Next to your columns, insert the corresponding WPForms fields from the dropdown menu.

add wpforms tokens

You can also add Common tokens like the current date and time, recipe name, and more.

After you’re done, it should look something like this:

example of columns and wpforms values

Click Save.

4. Publish Your Recipe

Now it’s time to publish your recipe so you can start automating your form entries!

To make your automation live, simply click the toggle in the sidebar:

toggle recipe to live

That’s it!

Now you can test your form.

test your wordpress form automation

As soon as you submit your test form, you should see the form entry added to Google Sheets instantly.

automated form submissions added to google sheets

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.

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.