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:
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.
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:
Next, you need to create a spreadsheet in Google Sheets.
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 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.
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.
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:
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.
You’ll then be prompted to choose a recipe type. There are 2 options:
- Logged-in – Choose this if only logged-in users will fill out your WordPress forms.
- 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.
Now you’ll see 2 options to choose from:
- A form is submitted – Add all WPForms’ submissions to a specific spreadsheet in Google Sheets.
- A form is submitted with a specific value in a specific field – Only add submissions if they meet the criteria (conditional logic).
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.
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.
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:
Then, click on the Add action button below.
Choose Google Sheets from the integration list:
Now select Create a row in Google Sheet:
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.
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.
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:
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:
That’s it!
Now you can test your form.
As soon as you submit your test form, you should see the form entry added to Google Sheets instantly.
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.