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 that 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:
- Integrate WPForms With Google Sheets
- Connect WordPress Forms to Google Sheets
- Create a Spreadsheet and Import Entries
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
Here’s a video showing the process from start to finish:
If you’d prefer to read along, follow these steps to connect your contact form to a Google spreadsheet.
Step 1: Integrate WPForms With Google Sheets
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. Let’s rename the form as Google Sheets for the sake of this example.
In order to import entries into Google Sheets from your form, you’ll need to install and activate Zapier addon on your site. The Zapier addon lets you connect your WordPress forms to over 2,000+ web apps, including things like Salesforce, Jira, and the Google Sheets app.
For more help with this step, you can check out our tutorial on how to install and use the Zapier addon.
Now let’s take a look at how to connect WordPress forms to Google Sheets.
Log into your Zapier account and click the Make a Zap button in the top navigation.
Then, follow Zapier’s step by step guide to create a Zap. To see screenshots of every step, you can refer to our tutorial on using Zapier with WPForms.
Make sure to choose the Google Sheets form you just created, when you’re asked to setup Edit Options. You must have at least one test entry on your form before fetching existing entries.
You should then see a successful confirmation message.
Step 2: Connect WordPress Forms to Google Sheets
After connecting Zapier to the WPForms plugin, you’ll need to connect WPForms to Google Sheets.
The first step is to choose Google Sheets as the action app. Enter Google Sheets in your search bar, and then, click on it when it shows up.
Then, you’ll be asked to select Google Sheets action. As we are looking to add form entries to Google Sheets from WordPress, let’s choose Create Spreadsheet Row and click Continue.
Now you need to connect your Google account to Zapier. To do this, you’ll need to authorize Zapier to access your Google Sheets data. After authorizing it, click Continue.
Step 3: Create a Spreadsheet and Import Entries
Before you can import the form entries to your Google Sheets, you’ll have to create a new spreadsheet by logging into Google Sheets.
You’ll also have to add new rows in your spreadsheet so that form entries can be configured with the corresponding row.
Now go back to your Zapier account. You’ll be asked to specify the name of the spreadsheet and worksheet. Once you specify them, you’ll be shown the rows you just created in your specified spreadsheet. Make sure to connect each form field to the appropriate Google Sheets field. After connecting them all, click Continue.
If you want to test what data has been updated in Google Sheets, click on Test. You’ll now see the data just like the screenshot below. Click Create & Continue.
You’ve just tested Google Sheets app on Zapier successfully.
You may login to your Google Sheets account to verify the updated data.
In the final step, make sure to turn on your Zap. You can also give your Zap an appropriate name. By turning on Zap, you can automatically send all future form entries to Google Sheets whenever your visitors submit the form on your site.
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.
This is good, but Zapier is expensive. Any plans on natively integrating with Google Sheets?
Hi there!
This is on the list of features, however, I don’t have any ETA on when this can be developed.
Have a good one 🙂
Is this feature ready?
Hey there – I am afraid this feature is not available yet, I will go ahead and add your vote to the feature request though.
Sorry for the inconvenience.
Hey there !
Such a great work !
Do you know if there is any possiblity to add {page_url} field in zapier ?
Best regards
Hey Randy – Glad to hear that you liked this tutorial. As Zapier addon will send any of your fields to Google sheet, for sending page URL to Google sheet, you can add a hidden field in your form and give its default value as {page_url} and then you can pass this field to Zapier.
For further help on this, I would suggest contacting our support team.
Have a good one 🙂
Any other option instead of Zapier? Zapier expensive
Hey Minh, thanks for reaching out!
I totally understand that Zapier might be an expensive option for some projects. Please note that we already have a feature request for direct integration with Google Sheets. I have gone ahead and added your vote to the feature request.
In the meantime, the closest workaround would be to export entries to CSV. We have a step-by-step tutorial here.
If you have any more questions please feel free to contact our support team.
Thanks! 🙂
please have a native feature!!! Zapier is so expensive !!!
Hey Meid- I am sorry for the inconvenience you are facing here!
Currently, integration with Google Sheets is still being considered. I have made a note of your interest in this and added your vote to our feature list to consider in the future as we continue to plan out our roadmap.
Thanks! 🙂
You guys have been considering this since January 2020… either you want to do it or you dont…
Hey Jaco -Sorry about the frustration here! We do have our native webhooks addon that has the ability to send form-submitted information to the secondary application. Please see the guide here
Hope this helps! 🙂