Trusted WordPress tutorials, when you need them most.
Beginner’s Guide to WordPress
WPB Cup
25 Million+
Websites using our plugins
16+
Years of WordPress experience
3000+
WordPress tutorials
by experts

How to Connect Any WordPress Forms to Google Sheets (Easy Way)

Editorial Note: We earn a commission from partner links on WPBeginner. Commissions do not affect our editors' opinions or evaluations. Learn more about Editorial Process.

Do you want to connect your WordPress forms to Google Sheets?

Google Sheets makes it easy for you to manage your form data inside a spreadsheet, and they have built-in collaboration tools to improve workflows.

In this article, we’ll show you how to easily connect any WordPress forms to Google Sheets, so you can automatically send WordPress form data to Google sheets.

How to connect any WordPress forms to Google Sheets (the easy way)

Why Connect WordPress Forms to Google Sheets?

Google Sheets is a popular free spreadsheet software from Google. Connecting your WordPress forms to Google Sheets makes it easier to manage and sort your form data.

No matter if you’re creating a questionnaire, gathering testimonials, building a survey form, or something else, you can connect your WordPress forms to Google Sheets with just a few clicks.

Integrating your form entries with Google Sheets can help your WordPress website in a lot of ways.

  • Makes it easy to give your team access to form data without creating a new WordPress login
  • Makes it easier to interpret and analyze your form / survey data
  • Set up automatic data collection and reduce errors from manual data entry
  • Generate personalized reports based on the data submitted by visitors

With that said, let’s take a look at how you can connect any WordPress forms to Google Sheets, the easy way.

Step 1. Create a WordPress Form Using WPForms

The first thing you need is to have an active contact form on your WordPress website which will act as the data collection source.

For the sake of this tutorial, we’ll be using the WPForms plugin. It’s the best contact form plugin for WordPress used by over 6 million websites.

The WPForms website

Their beginner-friendly form builder can be used to create nearly any kind of WordPress form. You can start with one of their 1300+ form templates or simply use the drag and drop builder to add form fields and customize them to your liking.

For more details, see our step by step guide on how to create a contact form in WordPress.

If you haven’t created a Google Sheets spreadsheet, then you’ll need to do that now.

Head over to the Google Sheets website and click ‘Blank’ to add a new spreadsheet.

New Google spreadsheet

Then, when you’re adding spreadsheet columns, you want these to match your WordPress form fields.

In this case, we’ll have three columns for the ‘Name’, ‘Email’, and ‘Message’.

Google Sheets spreadsheet

Step 2. Install and Activate the Uncanny Automator WordPress Plugin

To connect your WordPress forms to Google Sheets, we’re going to be using an automation plugin.

The best WordPress automation plugin is Uncanny Automator. It acts as a connecter between WordPress plugins and other third-party apps, so they can easily talk to each other. That means you can create any automated workflow in WordPress.

It’s the most powerful way to automate your WordPress blog processes without any code.

The best part about Uncanny Automator is that it doesn’t charge you a tax on each data transfer like other SaaS providers such as Zapier.

Uncanny Automator also works with all major form solutions including, WPForms, Formidable Forms, Gravity Forms, Ninja Forms, WooCommerce, and more.

However, the focus of this tutorial will be on the integration with WPForms.

Note: There is a free version of the plugin available, but we’ll use the Pro version for this tutorial since it has the Google Sheets integration we need.

Uncanny Automator

For more details, see our guide on how to create automated workflows in WordPress with Uncanny Automator.

Step 3. Connect Your Google Account to Uncanny Automator

After Uncanny Automator is activated and set up, you need to connect the plugin to your Google account.

To do this, navigate to Automator » Settings and then click the ‘Google’ menu item.

Connect Google account

After that, click the ‘Connect an account’ button.

This will bring you to a screen where you need to authorize your Google account.

Simply select the Google account you want to use and then click the ‘Allow’ button.

Grant Google account permission

Then, you’ll need to click ‘Allow’ one more time to confirm your choices.

Once your account is successfully connected, you’ll be taken back to the plugin settings screen in your WordPress admin dashboard.

Google account integration success

Step 4. Connect Your WordPress Form to Google Sheets with Uncanny Automator

Now, it’s time to connect your WordPress form to the Google Sheet you created earlier.

Uncanny Automator uses what are called “recipes” to connect different apps and plugins.

To create one, go to Automator » Add new, click the ‘Everyone’ option and then click ‘Confirm’.

You want to choose Everyone because most of the time, new visitors will fill out the forms on your website.

Select Everyone as the recipe type

Next, you can give your recipe a name.

After that, select ‘WPForms’ in the ‘Trigger’ meta box.

Select WPForms as the Trigger integration

Then, you’ll have two different options to choose from.

We’ll select the ‘A form is submitted’ option since this will send all form submissions to Google Sheets.

Choose a form is submitted option

Then, select your form from the dropdown list.

After that, click the ‘Save’ button.

Choose WPForms form

Before moving ahead, you’ll need to create a new ‘Subscriber’ user in WordPress. This new Subscriber role will be used to send the form data through and you’ll need the user ID in the next step.

For more details, see our guide on how to add new users and authors to your WordPress blog.

Now, you’ll need to add an action by clicking the ‘Add action’ button under the Actions meta box.

Add an action

Next you’ll be given a list of integration options.

Go ahead and select the ‘Automator’ as the integration.

Choose Automator

Next, you’ll have to select the ‘Call a custom function/method’ option from the dropdown menu.

The ‘Call a custom function/method action can call any global or static function within your WordPress site.

Select Call a custom function

When you select the option, a popup will appear, reminding you that it will require user data.

Simply select the ‘Set user data’ button to continue.

Allow set user data

Next it’ll ask your whether you want to the actions to run on an existing or new user.

Go ahead and choose the ‘Existing user’ option.

Select existing user option

Now, you’ll need to set user data.

To do that, simply select ‘ID’ from the dropdown menu under the Unique field and enter the ID number from the new user you created.

Enter user ID

You can find the user ID by going to Users » All Users in your WordPress dashboard.

Then, open up the new user and locate the ID in the URL for the page.

Find user ID

Once you’ve done that, select the ‘Do nothing’ option for What to do if the user doesn’t exist.

Make sure to click ‘Save’ to save the recipe so far.

Select do nothing and save

After that, click the ‘Add action’ button again.

Click the add action button again

Next, you’ll be provided a list of integrations to connect your forms to.

Select ‘Google Sheets’ from the list of integrations.

Select Google Sheets

Then, choose the ‘Create a row in a Google Sheet’ option under the ‘Select an action’ section.

That way, new rows will be created with your form submissions.

Create a row in Google Sheet

This will bring up a menu to select the spreadsheet that you created earlier.

You can search for the name of your spreadsheet, and it will bring up a list of options.

Choose your spreadsheet

After you’ve selected the spreadsheet, you’ll also need to choose a Worksheet.

Once that’s done, simply click the ‘Get columns’ button in the ‘Row’ section. This will bring up a list of columns from the spreadsheet.

Select get columns

You’ll want to map the form fields to your spreadsheet columns.

Next to each form column, find the matching spreadsheet field. The ‘Column’ name should be the same as the ‘Value’ name.

Match column and value

Once you’ve matched up all the fields, it will look similar to the settings above.

Make sure you click ‘Save’ once you’re done creating the recipe.

After that, you need to publish your new recipe. This will make sure that form entries will automatically be sent to your Google Sheets spreadsheet.

To publish the recipe, all you have to do is switch the recipe toggle to ‘Live.’

Publish your recipe

Now, whenever a visitor fills out your form, the information will instantly appear in Google Sheets.

There are many other no-code integrations and automations that you can create with this plugin like integrating Slack with WordPress, and even setting up SMS notifications in WooCommerce.

We hope this article helped you connect any WordPress forms to Google Sheets the easy way. You may also want to see our expert picks of the best no-code drag and drop WordPress page builders, and our list of the must have WordPress plugins for businesses.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

Disclosure: Our content is reader-supported. This means if you click on some of our links, then we may earn a commission. See how WPBeginner is funded, why it matters, and how you can support us. Here's our editorial process.

Editorial Staff

Editorial Staff at WPBeginner is a team of WordPress experts led by Syed Balkhi with over 16 years of experience in WordPress, Web Hosting, eCommerce, SEO, and Marketing. Started in 2009, WPBeginner is now the largest free WordPress resource site in the industry and is often referred to as the Wikipedia for WordPress.

The Ultimate WordPress Toolkit

Get FREE access to our toolkit - a collection of WordPress related products and resources that every professional should have!

Reader Interactions

1 CommentLeave a Reply

  1. Syed Balkhi says

    Hey WPBeginner readers,
    Did you know you can win exciting prizes by commenting on WPBeginner?
    Every month, our top blog commenters will win HUGE rewards, including premium WordPress plugin licenses and cash prizes.
    You can get more details about the contest from here.
    Start sharing your thoughts below to stand a chance to win!

Leave A Reply

Thanks for choosing to leave a comment. Please keep in mind that all comments are moderated according to our comment policy, and your email address will NOT be published. Please Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.