Today, we’re thrilled to announce a brand new addition to our growing family of addons.
Introducing the Google Sheets addon for WPForms!
The Google Sheets addon will allow you to send form entries to a spreadsheet directly.
Previously, you needed third-party tools to establish a connection between Google Sheets and WPForms. We wanted to make it easier and faster to transfer data from WPForms to a spreadsheet directly.
This addon is all about simplifying your workflow and giving you complete control.
Read on to learn more about our latest update.
Easy Google Sheets Integration
With every WPForms update, our goal is to enable you to manage your business with minimal effort and maximum efficiency.
The Google Sheets addon removes the long and complicated process of integrating WPForms with your Google spreadsheets using third-party apps.
Instead, you can now connect your Google account directly with WPForms to send entries.
There are two methods for completing the Google Sheets integration.
The default method is fast and straightforward. You can also use the more advanced method to first create a custom Google application, but this is only recommended for technical users. See our doc guide for more details.
After connecting your Google account with WPForms, you can easily control which forms should automatically transfer entries to your spreadsheet.
Send Form Entries to Spreadsheets
To ensure optimal accessibility, we’ve included the settings for the Google Sheets addon within the form builder. This way, you’re free to link any form to a spreadsheet of your choice.
For example, let’s use this simple contact form.
You can seamlessly connect this form to any spreadsheet saved in your Google Drive by going into the form builder settings.
Once inside the settings, all you need is to select the spreadsheet that you want to transfer your form data to.
There’s also a link button that takes you directly to your selected spreadsheet. This is useful if you’d like to view the spreadsheet or make any changes before initiating the automation.
Inside the same settings, you can map your form field to the spreadsheet column values so that all new entries are sent exactly to the appropriate sheet columns.
While you’re adding field mappings, you can also add custom input to a specific column by selecting Custom Value. This shows you a new field that lets you input text, use WPForms smart tags, and even apply Google Sheets formulas.
In fact, we went a step further. You can also create a new spreadsheet while you’re configuring your settings. We’ve also added the option to create a new sheet within an existing spreadsheet.
Just select Create a New Spreadsheet from the dropdown, name your new sheet, and proceed to map fields to column values as before.
And we’re not finished yet. There’s one more exciting feature we’d like to share with you.
Transfer Form Data to Sheets With Smart Logic
To ensure that you enjoy full flexibility with your WPForms and spreadsheet integration, we’ve made this addon compatible with smart conditional logic.
This means that your form data will only be sent to a Google Sheet if the form entry matches your conditions.
For example, let’s assume we have a contact form with an email optin checkbox and we’re maintaining a sheet of contacts that have opted in to our email list.
We can make sure that the form entry includes the optin. If it doesn’t, it won’t be added to your sheet.
Of course, a form entry within your WordPress will still always be saved regardless of the conditions you set. Conditional logic just gives you that extra control.
We think the Google Sheets addon will greatly boost your business efficiency and make entry management even more flexible than before.
Just activate the Google Sheets addon and let WPForms populate your spreadsheets automatically.
It’s as simple as it is powerful!
The Next Release Is Already On Its Way…
The Google Sheets addon is available for our Pro and Elite customers. But we aren’t finished yet…
As is our custom, we’re working on several updates for the next WPForms release.
Until then, try the Google Sheets addon, and be sure to send us your comments and feedback!
We hope you’ll enjoy using our new addon and that it helps you get your form entries to Google Sheets without the hassle!
– Jared Atchison
I have WP Form Pro license.
I am using google form + form ranger (add-on), integrating with google sheets. Becoz it provides certain tracking that WP Form is unable to do it.
With form ranger, it enables tracking of the number of sign-ups I received for each class and changes the google form option accordingly. It will change the options to “last few seats” when a certain number of people have sign up and then change the option to “full” when class is full.
Can the new WP form feature do this?
Unfortunately, we currently do not have a feature to display the custom message based on number of sign-ups as you have mentioned. However, I will add your vote to consider this as a future enhancement.
amazing tools !!
I wanna request, WPForms integrated Whatsapp Notification with API or Other Whatsapp Gateway
Currently, we do not have an inbuilt feature that has an integration with WhatsApp Application. I have gone ahead and added your vote to consider this as a feature request. Meanwhile, in case it helps, you can connect to a secondary application using the Webhooks addon.
Hope this helps 🙂
I am relatively new on the Web, and with WPForms on my back, I am good to go….
Thanks WP Forms Team!
Hey Timoty, thanks for letting us know!If you ever have questions, please feel free to reach out to us by submitting a support ticket here. Also, please know we have some great tutorial resources: Docs, (I recommend starting here), Blog, and YouTube.
Hi I just upgraded to Pro but there seems to be an issue with activating Google sheets under the WPForms settings>add on. Every time I activate, and go to the integration tab it is missing from my option list, then it appears to be inactive. Can you advise if there is a known issue with the google sheets integration?
Hey Michael, – We are sorry for any trouble. In order to make sure we answer your question as thoroughly as possible and avoid any confusion, please allow us to response via the email support.
I have a lot of member data stored in a spreadsheet. Emails, names, addresses, etc. I note that the Google Sheets addon takes data FROM wordpress forms and stores it on Sheets. I’m wondering if there is a way to reverse the process and import data from Google sheets. I would then manage member, send emails, etc, from within my WordPress site.
Thanks for any info. Integrating with Sheets is a great idea.
With WPForms plugin, there is currently no feature to fetch the data from the Google Sheets and import it to the WordPress site.