Managing form submissions can be a tedious process. If you’re looking for an efficient way to handle your form data, linking your WordPress forms to Google Sheets is an ideal solution.
Google Sheets provides a user-friendly spreadsheet interface along with robust collaboration features, enhancing your workflow. This simplifies the organization and analysis of your form submissions.
In this guide, we will demonstrate how to effortlessly connect any WordPress forms to Google Sheets, allowing you to automatically transfer form data to your spreadsheet.
Benefits of Connecting WordPress Forms to Google Sheets
Google Sheets is a widely-used free spreadsheet application by Google. Linking your WordPress forms to Google Sheets streamlines the management and sorting of your form data.
Whether you’re creating a questionnaire, collecting testimonials, designing a survey form, or any other type of form, you can easily connect your WordPress forms to Google Sheets with just a few clicks.
Integrating your form submissions with Google Sheets can significantly enhance your WordPress website’s functionality.
- Facilitates easy access to form data for your team without the need for additional WordPress logins.
- Simplifies the interpretation and analysis of your form and survey data.
- Automate data collection and minimize errors caused by manual data entry.
- Create customized reports based on the information submitted by your website visitors.
Now, let’s explore how to easily connect any WordPress forms to Google Sheets.
Step 1: Create a WordPress Form Using WPForms.
First, ensure you have an active contact form on your WordPress site, which will serve as your data collection tool.
For this tutorial, we will utilize the WPForms plugin, the leading contact form solution for WordPress, trusted by over 6 million websites.
With their user-friendly form builder, you can create almost any type of WordPress form. Choose from over 1,800 form templates or use the drag-and-drop builder to add and customize form fields to suit your needs.
For detailed instructions, refer to our comprehensive guide on creating a contact form in WordPress.
If you haven’t set up a Google Sheets spreadsheet yet, please do so now.
Visit the Google Sheets website and click on ‘Blank’ to create a new spreadsheet.
When adding columns to your spreadsheet, ensure they correspond with the fields in your WordPress form.
In this example, we will create three columns labeled ‘Name’, ‘Email’, and ‘Message’.
Step 2: Install and Activate the Uncanny Automator Plugin for WordPress.
To link your WordPress forms with Google Sheets, we will utilize an automation plugin.
Uncanny Automator is the top automation plugin for WordPress. It serves as a bridge between WordPress plugins and various third-party applications, enabling seamless communication between them. This allows you to establish any automated workflow within WordPress.
This is the most effective method to automate your WordPress blog operations without needing to write any code.
One of the greatest advantages of Uncanny Automator is that it does not impose a fee for each data transfer, unlike other SaaS providers such as Zapier.
Uncanny Automator is compatible with all major form solutions, including WPForms, Formidable Forms, Gravity Forms, Ninja Forms, WooCommerce, and more.
However, this tutorial will specifically focus on integrating with WPForms.
Note:There is a free version of the plugin available, but for this tutorial, we will use the Pro version as it includes the necessary Google Sheets integration.
For additional information, please refer to our guide on creating automated workflows in WordPress using Uncanny Automator.
Step 3: Link Your Google Account with Uncanny Automator
Once you have activated and configured Uncanny Automator, the next step is to link the plugin to your Google account.
To proceed, go to Automator » Settings and select the ‘Google’ option from the menu.
Next, click the ‘Connect an account’ button.
This will direct you to a page where you can authorize your Google account.
Simply choose the Google account you wish to connect and click the ‘Allow’ button.
You will need to click ‘Allow’ again to finalize your selections.
Once your account is successfully linked, you will return to the plugin settings page in your WordPress admin dashboard.
Step 4: Link Your WordPress Form to Google Sheets Using Uncanny Automator
Now, it’s time to connect your WordPress form to the Google Sheet you created earlier.
Uncanny Automator utilizes ‘recipes’ to integrate various apps and plugins.
To create a new recipe, navigate to Automator » Add new, select the ‘Everyone’ option, and click ‘Confirm’.
Choosing ‘Everyone’ is ideal since most new visitors will be filling out the forms on your website.
Finally, you can assign a name to your recipe.
Next, choose ‘WPForms’ from the ‘Trigger’ options.
You will see two options to select from.
Choose the ‘A form is submitted’ option to ensure all form submissions are sent to Google Sheets.
Select your desired form from the dropdown menu.
Then, click the ‘Save’ button to proceed.
Before proceeding, create a new ‘Subscriber’ user in WordPress. This Subscriber role will be used to transmit the form data, and you will need the user ID for the next step.
For further instructions, refer to our guide on adding new users and authors to your WordPress site.
Now, add an action by clicking the ‘Add action’ button in the Actions section.
You will then see a list of integration options.
Select ‘Automator’ as your integration choice.
Next, choose the ‘Call a custom function/method’ option from the dropdown.
The ‘Call a custom function/method’ action can invoke any global or static function available on your WordPress site.
Upon selecting this option, a popup will appear, indicating that user data is required.
Simply click the ‘Set user data’ button to continue.
Next, it will ask you whether you want the actions to apply to an existing user or a new user.
Please select the ‘Existing user’ option.
Now, you need to configure the user data.
To do this, simply choose ‘ID’ from the dropdown menu under the Unique field and enter the ID number of the new user you created.
You can find the user ID by navigating toUsers » All Usersin your WordPress dashboard.
Then, open the new user profile and locate the ID in the URL of the page.
Once you’ve done that, select the ‘Do nothing’ option for the action if the user does not exist.
Make sure to click ‘Save’ to preserve the recipe so far.
After that, click the ‘Add action’ button again.
Next, you will see a list of integrations to connect your forms.
Select ‘Google Sheets’ from the list of available integrations.
Then, choose the ‘Create a row in a Google Sheet’ option under the ‘Select an action’ section.
This will ensure that new rows are created with each of your form submissions.
This will display a menu where you can select the spreadsheet you created earlier.
You can search for your spreadsheet’s name, and it will show a list of matching options.
After selecting your spreadsheet, you will need to choose a specific worksheet.
Once that is complete, click the ‘Get columns’ button in the ‘Row’ section to display a list of columns from your spreadsheet.
You should map the form fields to the corresponding columns in your spreadsheet.
Next to each form column, find the corresponding spreadsheet field. The ‘Column’ name should match the ‘Value’ name.
Once all fields are matched, it will resemble the settings shown above.
Be sure to click ‘Save’ after you finish creating the recipe.
Next, you need to publish your new recipe to ensure that form entries are automatically sent to your Google Sheets.
To publish the recipe, simply toggle the recipe switch to ‘Live.’
Now, whenever a visitor submits your form, the information will automatically appear in Google Sheets.
This plugin also allows for various other no-code integrations and automations, such as connecting Slack with WordPress and setting up SMS notifications in WooCommerce.
We trust this guide has made it simple for you to link your WordPress forms to Google Sheets. Additionally, check out our expert recommendations for the best no-code drag-and-drop WordPress page builders and our essential list of WordPress plugins for businesses.
If you enjoyed this article, consider subscribing to our YouTube Channel for insightful WordPress video tutorials. You can also connect with us on Twitter and Facebook.
