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.
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.
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
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 site which will act as the data collection source.
Their beginner-friendly form builder can be used to create nearly any kind of WordPress form. You can start with one of their 150+ 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.
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’.
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.
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.
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.
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.
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.
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 dashboard.
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.
Next, you can give your recipe a name.
After that, select ‘WPForms’ in the ‘Trigger’ meta box.
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.
Then, select your form from the dropdown list.
After that, click the ‘Save’ button.
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.
After that, go ahead and select the ‘Automator’ as the integration.
Next, you’ll have to select the ‘Call a custom function/method’ option from the dropdown menu.
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.
Then, go ahead and choose the ‘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.
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.
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.
After that, click the ‘Add action’ button again.
Next, you need to select ‘Google Sheets’ from the list of integrations.
Then, choose the ‘Create a row in a Google Sheet’ option under the ‘Select an action’ section.
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.
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.
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.
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.’
Now, whenever a visitor fills out your form, the information will instantly appear in Google Sheets.
We hoped 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.