Want to link 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 show you how to easily link WordPress forms to Google Sheets so you can automatically submit 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.
Whether you’re creating a questionnaire, collecting testimonials, building a survey form or anything else, you can connect your WordPress forms to Google Sheets with just a few clicks.
Integrating your form records with Google Sheets can help your WordPress site in many ways.
Make it easy to give your team access to form data without creating a new WordPress login Make 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 look at how you can easily link all WordPress forms to Google Sheets.
Step 1. Create a WordPress form using WPForms
The first thing you need is to have an active contact form on your WordPress site that acts as a source of data collection.
For the sake of this guide, we use the WPForms plugin. It is the best contact form plugin for WordPress used by over 4 million websites.
Their beginner-friendly form builder can be used to create just about any WordPress form. You can start with one of their 150+ form templates or simply use 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 WordPress contact form.
If you did not create a Google Sheets spreadsheet, do so now.
Go to the Google Sheets website and click ‘Blank’ to add a new spreadsheet.
Then, when you add spreadsheet columns, you need them to match your WordPress form fields.
In this case, we have three columns for ‘Name’, ‘Email’ and ‘Message’.
Step 2. Install and activate Uncanny Automator WordPress Plugin
To connect your WordPress forms to Google Sheets, we use an automation plugin.
The best WordPress automation plugin is Uncanny Automator. It acts as a link 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 code.
The best thing about Uncanny Automator is that it does not charge a tax for every data transfer like other SaaS providers like 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 guide will be on integration with WPForms.
Note: there is a free version of the plugin available, but we use the Pro version for this guide as 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
Once Uncanny Automator is enabled and configured, connect the plugin to your Google Account.
To do this, navigate to Automator »Settings and then click on the ‘Google’ menu item.
Then click the ‘Connect to an Account’ button.
This will take you to a screen where you will need to authenticate your Google Account.
Select the Google Account you want to use, then click the ‘Allow’ button.
Then click ‘Allow’ again to confirm your selections.
Once your account is properly connected, you will 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 link your WordPress form to the Google Sheet you created earlier.
Uncanny Automator uses so-called “recipes” to connect various apps and plugins.
To create one, go to Automator »Add new, click on ‘Anonymous’ and then click on ‘Confirm’.
You will choose Anonymous because it will mostly be new anonymous visitors who fill out the forms on your site.
Next, you can give your recipe a name.
Then select ‘WPForms’ in the ‘Anonymous trigger’ meta field.
Then you have two different options to choose from.
We select the ‘Submit a form’ option, as this will send all form submissions to Google Sheets.
Then select your form from the drop-down list.
Then click on the ‘Save’ button.
Since you chose an anonymous recipe above, you need to create a new ‘subscriber’ user in WordPress. This new subscriber role will be used to send form data through.
For more details, see our guide on how to add new users and authors to your WordPress blog.
Then select the ‘Existing user’ option in the ‘Actions’ meta-field.
This will open a popup where you can select the new user account.
Select the ‘ID’ field and enter the ID number of the new user you created.
To find this, go to Users »All Users in your WordPress dashboard.
Then open the new user and find the ID in the URL of the page.
Once you have done that, select ‘Do nothing’.
Be sure to click ‘Save’ to save the recipe for now.
Then click the ‘Add Action’ button.
Next, select ‘Google Sheets’ from the list of integrations.
Then select the ‘Create a row in a Google Sheet’ option under the ‘Select an action’ section.
This opens a menu to select the spreadsheet you created earlier.
You can search for the name of your spreadsheet and it displays a list of options.
Once you have selected the spreadsheet, click on the ‘Get Columns’ button in the ‘Row’ section.
This displays a list of columns from the spreadsheet.
You will want to map the form fields to your spreadsheet columns.
Find the matching spreadsheet field next to each shape column. The name ‘Column’ must be the same as the name ‘Value’.
Once you have matched all the fields, it will look like the settings above.
Be sure to click ‘Save’ when you have finished creating the recipe.
Then you need to publish your new recipe. This will ensure that form records are automatically sent to your Google Sheets spreadsheet.
To publish the recipe, just change the recipe to ‘Live’.
Now, every time a visitor fills out your form, the information will immediately appear in Google Sheets.
There are many other non-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 WordPress forms to Google Sheets the easy way. It can also be a good idea to see our expert selection 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, subscribe to our YouTube channel for WordPress video tutorials. You can also find us at Twitter and Facebook.