GsheetConnector WPForms

Description

Homepage | Documentation | Support | Demo | Premium Version

This plugin is a bridge between your WordPress WPForms and Google Sheets.

When a visitor submits his/her data on your website via a WPForms, upon form submission, such data are also sent to Google Sheets.

Get rid of making mistakes while adding the sheet settings or adding the headers ( Mail Tags ) to the sheet column. We have Launched the WPForms Google Sheet Connector Pro with more automated features.

Still haven’t purchased ? Get it Now

Check Live Demo

Demo URL: https://wpformsdemo.gsheetconnector.com/

Google Sheet URL to Check submitted Data
https://docs.google.com/spreadsheets/d/1ooBdX0cgtk155ww9MmdMTw8kDavIy5J1m76VwSrcTSs/edit#gid=1289172471

How to Use this Plugin

In Google Sheets
* Log into your Google Account and visit Google Sheets.
* Create a new Sheet and name it.
* Rename or keep default name of the tab on which you want to capture the data.

In WordPress Admin
* Move to WPForms > Google Sheet Tab > GoogleSheet Form Settings.
* Selected respective WPForm from the dropdown with which you want to connect with Google Sheet.
* Now copy and paste the Google Sheets sheet name and tab name into respective input fields, and submit.

*In Google Sheets Column with Name**
In the Google sheets tab, provide column names in row 1. Like the first column is “Name”. For each further column, copy paste the form label from the WPForms form (e.g. “Name”, “Email”, “Comment-or-Message”, etc).
* The fields name should be with specific format like if the WPForms field lable is “Comment or Message” your google sheet column name should be “Comment-or-Message” same with all the labels (e.g Firstname Lastname = “Firstname-Lastname” , zip code = “zip-code”, etc).
* Lastly Test your WPForms and verify that the data shows up in your Google Sheet.

Important Notes

  • You must pay very careful attention to your naming. This plugin will have unpredictable results if names and spellings do not match between your Google Sheets and WPForms settings.
  • Also while inputing the WPForm field label to Google Sheet follow the rules if there is any empty space between the label name it will not sent the WPForm data to Google Sheet.

Screenshots

  • Installation step 3 - Google Sheets Connect Page.
  • Google Sheet Settings for WPForms.
  • Google Sheet with mail tags

Installation

  1. Upload gsheetconnector-wpforms to the /wp-content/plugins/ directory, OR Site Admin > Plugins > New > Search > GsheetConnector Wpforms > Install.
  2. Activate the plugin through the ‘Plugins’ screen in WordPress.
  3. Use the Admin Panel > WPForms > Google Sheet > Integration screen to connect to Google Sheets by entering the Access Code. You can get the Access Code by clicking the “Get Code” button.
    Enjoy!

Contributors & Developers

“GsheetConnector WPForms” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

1.1

  • UI changes
  • Moved tab from WPForms settings to “Google Sheet” tab.

1.0

  • First public release
  • Integrated WPForms with Google sheets.