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, using WPForms.
Click here if you use Microsoft Excel and need to see how WPForms lets you export your form entries to Excel.
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 users – Choose this if only logged-in users will fill out your WordPress forms.
- Everyone – Choose this if logged-out visitors and logged-in WordPress users will be filling out your forms.
In most cases, you should choose Everyone because anonymous website visitors will be the ones filling out your contact forms, registration forms, newsletter forms, etc.
So, select Everyone 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, scroll down the page a bit and click the Add action button.
Next, Uncanny Automator will show you a list of available integrations.
Choose Google Sheets:
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.