WPForms Google Sheet Connector

Description

This is an Addon Plugin of WPForms, A bridge between your WordPress based WPForms and Google Sheets. It helps to record the entries in real-time.

When a visitor submits the form on your website from the frontend using WPForms, upon the form submission, such responses/filled entries are also sent to Google Sheets.
Compatible with WPForms Lite and PRO Versions

Homepage | Documentation | Support | Demo | Premium Version

🤝 PRO FEATURES 🙌

Get a rid of making mistakes while adding the sheet settings or adding the headers manually to the sheet column. We have Launched the WPForms Google Sheet Connector Pro version with more automated features.
➜ Custom Google API Integration Settings
➜ Allowing to Create a New Sheet from Plugin Settings
➜ Custom Ordering Feature / Manage Fields to Display in Sheet using Enable-Disable / Edit the Fields/ Headers Name to display in Google Sheet.
➜ Using all the Smart Tags Fields in Headers
➜ Syncronize Existing Entries for WPForms PRO users
➜ Freeze Header Settings
➜ Header Color and Row Odd/Even Colors.
Refer to the features and benefits page for more detailed information on the features of the WPForms Google Sheet PRO Addon Plugin

⚡️ Check Live Demo

Demo URL: WPForms Demo

Google Sheet URL to Check submitted Data

✨ How to Use this Plugin

  • Step: 1 – 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.
    ➜ Copy Sheet Name, Sheet ID, Tab Name and Tab ID (Refer Screenshots)

  • Step: 2 – In WordPress Admin
    ➜ Navigate to WPForms > Google Sheet > Integration Tab.
    ➜ Authenticate with Google using new “Google Access Code” while clicking on “Get Code”
    Make Sure to ALLOW Google Permissions for Google Drive and Google Sheets and then copy the code and paste in Google Access Code field, and Hit Save & Authenticate.
    ➜ Then, Navigate to GoogleSheet Form Settings Tab 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.

  • Step: 3 – Arranging Columns in Sheet
    ➜ In the selected Google sheet, enter column names in first row (as a header) as per the Label, Copy and Paste the form field label from the WPForms to Google Sheet (e.g. “Name”, “Email”, “Comment or Message”, “date” 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.

👉 Get WPForms PRO today

Screenshots

  • Installation step 3 - Google Sheets Connect Page.
  • Google Sheet Settings for WPForms.
  • Google Sheet with mail tags.
  • On the Admin Panel > WPForms > Google Sheet > Integration page, click the "Get Code" button.
  • In a popup Google will ask you to authorize the plugin to connect to your Google Sheets. Authorize it - you may have to log in to your Google account if you aren't already logged in.
  • On the next screen, you should receive the Access Code. Copy the code.
  • Now you can paste this code back on the Admin Panel > WPForms > Google Sheet > Integration page.

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!

FAQ

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.

Reviews

25 May 2022
This works perfectly for me! Thanks
29 October 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.
2 November 2020
Awesome plugin to send all data entries from Wpforms into Google sheet. Thank you !
Read all 9 reviews

Contributors and Developers

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

Contributors

Change Log

3.4.5

(30-07-2022)
* New Google Integration method implemented using web app.

3.4.4

  • Fixed: Undefined function issue.

3.4.3

  • Fixed: Wrong Class issue resolved.
  • Fixed: Undefined function issue.

3.4.2

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

3.4.1

  • Fixed: Undefined index issue.

3.4

  • 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.

3.3

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

3.2

  • Fixed fontend errors on form submission.

3.1

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

3.0

  • 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.

2.0

  • Upgrade Google APIs Client Library to V4.

1.3

  • 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.

1.2.1

  • Fixed error at dashboard widget.

1.2

  • 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.

1.1

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

1.0

  • First public release
  • Integrated WPForms with Google sheets.