WPForms Google Sheet Connector


This plugin is a bridge between your WordPress WPForms and Google Sheets.
When a visitor submits a form with his/her data on your website via a WPForms, upon form submission, such data are also sent to selected Google Sheet.

Homepage | Documentation | Support | Demo | Premium Version

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

Version Update 2.0

GSheetConnector WPForms version 2.0 would required you to re-authenticate with your Google Account again due to update of Google API V3 to V4.

To avoid any loss of data redo the Google Sheet settings of each Contact Forms again with required sheet and tab details.

Also set header names again with the same name as specified for each WPForms field label.

Example: “Comment or Message” label must be added similarly for Google Sheet header.

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).
* Lastly Test your WPForms and verify that the data shows up in your Google Sheet.

Videos to help you get started with GSheetConnector WPForms

How to Install, Authenticate and Integrate WPForms with 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.


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


  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.


How to get smart tag like query_vars, user_meta key values to the Sheet?

  • First, use hook “wpforms_smart_tags” to add the smart tags with the key for which you want the value to the Google Sheet as below example.

    add_filter( “wpforms_smart_tags”, “edit_smart_tags” );

    public function edit_smart_tags( $tags ) {
    $tags[‘query_var key=”wpformstest”‘] = esc_html__( ‘Query String Variable’, ‘wpforms-lite’ );
    return $tags;

  • Add same key ( query_var key=”wpformstest” ) to the Google Sheet header to get the values.

entry_id and entry_date smart tag not getting saved to the Google Sheet.

  • WPForms lite version don’t save form submitted entries to the database. For a reason entry_id is zero(0) and entry_date is null. Hence not being saved to the Google Sheet.


Oktubre 29, 2021
This plugin does what it says is does. Support was great helping me connect. Make sure you give permissions to the plugin when you sign into google sheets by selecting the two checkboxes.
Nobyembre 2, 2020
Awesome plugin to send all data entries from Wpforms into Google sheet. Thank you !
Read all 8 reviews

Contributors & Developers

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




  • Fixed: Displaying error and not allowing data to get saved yo Google Sheet.


  • Fixed: Undefined index issue.


  • Fixed: redeclared class error.
  • Fixed: smart_tags data not getting saved and throwing errors.
  • Displayed connected Google account at the Integration Page.
  • Added Upgrade to PRO link and list out feature of PRO version.
  • Added Logo on dashboard page.


  • Fixed smart tag not getting saved to Google Sheet.
  • Update API Libraries.


  • Fixed fontend errors on form submission.


  • Fixed Smart tag errors and issues with new update of WPForms Lite Version


  • Get smart tags value to the sheet. Add tags to header without curly braces.
  • Fixed displaying of single quote sign in front of numeric and date values.
  • Fixed – conflicts error.
  • Fixed – Get Date and Time as per local time instead of universal time.


  • Upgrade Google APIs Client Library to V4.


  • Removed admin notifications for limit.
  • Fixed not allowing form data to be saved at Google Sheet.
  • Fixed WPForms listing showing only five forms at Google Sheet settings tab.


  • Fixed error at dashboard widget.


  • Allow user to deactivate authentication
  • Added FAQ and System Status Tab
  • Fixed displaying of debug statements after form submission.
  • Allow user to add default “date” and “time” column to Google Sheet.


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


  • First public release
  • Integrated WPForms with Google sheets.