Gravity Forms Google Sheet Connector

April 19, 2024

Gravity Forms Google Sheet Connector Plugin

Send your Gravity Forms Data Instantly to your Connected Google Sheets In real-time.Easily manage your Gravity Forms data without worrying about any l …

Gravity Forms Google Sheets Connector Plugin is a Bridge between your Gravity Forms and Google Sheets. Helps to send every form entry (form submissions) from Gravity Forms to Google Sheets in real-time, when anyone submits a form on your website.
Easily manage your Gravity Forms data without worrying about any loss of information.

Documentation | Support | Live Preview – Demo | Premium Version

Get rid of making mistakes, while adding the sheet settings or adding the headers to the sheet column.
Upgrade to PRO & EXTEND THE FUNCTIONALITY Helps you to Automate the Sheet Columns while selecting the sheet from the dropdown.

Check Live Demo

Demo of Gravity Sheets

Google Sheet URL to Check submitted Data

Note: Gravity Forms Google Sheet Connector is a FREE and you can connect as much as form you want. Additional features such as automate sheets while selecting sheet, Dynamically send selected Headers into the sheet with a simple click, sync entries, etc are available in PRO version

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 the tab on which you want to capture the data.
    If you already have a sheet created in a google account use that.

  • Step: 2 – In WordPress Admin
    ➜ Now Create or Edit the Gravity Form from which you want to capture the data. Set up the form as usual in the Form.
    ➜ Thereafter, go to the new tab ” Google Sheet ” link in the Forms panel.
    ➜ Then Go to the Google Sheet Menu and do authentication with your Google Account and authorize the plugin to connect to your Google Sheets.
    ➜ Then after go to edit form->settings->GoogleSheet. Then add the Google Sheets-Sheet Name, SheetID, Tab Name, and TabID into respective positions and hit “Save”.
    ➜ Add the Gravity Forms input field label name as a Google Sheet header.

  • Step: 3 – Connect with Google Sheet
    ➜ Test your form submit and verify that the data shows up in your Google Sheet.

🔥 Videos to help you get started with Gravity Forms Google Sheets Connector

🚀Gravity Forms Google Sheet Connector Introduction Video

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 form settings.

➜ Custom Google API Integration Settings
➜ Fetch Sheets Automatically from the connected Google Account
➜ Automate Connecting with Sheets from the dropdown
➜ Allowing to Create a New Sheet from Plugin Settings
➜ Custom Ordering (using drag & drop) Feature,
➜ Manage Fields to Display in Sheet using Enable-Disable,
➜ Edit the Fields/ Headers Name to display in Google Sheet.
➜ Synchronize Existing Entries
➜ 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 Gravity Forms Google Sheet PRO Plugin

Google Sheet Connector Contact Form Addons
CF7 Google Sheet Connector
WPForms Google Sheet Connector
Gravity Forms Google Sheet Connector
Ninja Forms Google Sheet Connector
Avada Forms Google Sheet Connector
DIVI Forms Google Sheet Connector
Elementor Forms Google Sheet Connector

eCommerce Google Sheet Connector Addons
WooCommerce Google Sheet Connector
Easy Digital Downloads Google Sheet Connector
>

Installation

  1. Upload GSheetConnector Gravityfroms to the /wp-content/plugins/ directory and Install it.
  2. Activate the plugin through the ‘Plugins’ screen in WordPress.
  3. Use the Admin Panel > Forms > Google Sheet screen to connect to Google Sheets by entering the Access Code. You can get the Access Code by clicking the “Get Code” button.
    Enjoy!

Screenshots

  1. Google Sheet Integration without authentication.

    Google Sheet Integration without authentication.

  2. Permission page if user is already logged-in to there account.

    Permission page if user is already logged-in to there account.

  3. Permission popup-1 after logged-in to your account.

    Permission popup-1 after logged-in to your account.

  4. Permission popup-2 after logged-in to your account.

    Permission popup-2 after logged-in to your account.

  5. After successful integration - Displays "Currently Active".

    After successful integration - Displays "Currently Active".

  6. Get Sheet and Tab Id from the URL.

    Get Sheet and Tab Id from the URL.

  7. Google Sheet settings page with input box Sheet Name, Sheet Id, Tab Name, Tab Id.

    Google Sheet settings page with input box Sheet Name, Sheet Id, Tab Name, Tab Id.

  8. Add Gravity Forms field name to the Google Sheet headers.

    Add Gravity Forms field name to the Google Sheet headers.

  9. Google Sheet headers with form submitted data.

    Google Sheet headers with form submitted data.

Changelog

1.3.12

(19-04-2024)
* Added : UI Changes.

1.3.11

(11-03-2024)
* Added : Added links for support,docs,upgrade to pro.

= 1.3.10
* Fixed : Solved the problem with the consent form field not showing in sheet.

= 1.3.9
* Fixed : Resolved the problem with the Admin dashboard widget.
* Fixed : Resolved debugging view open and close problem.

= 1.3.8
* Google Api Client Library Updated With Version 2.12.6 With Guzzle Http Version 7.4.3 .
* System Status Integration by providing essential information, including version details and authentication status.
* Developed a streamlined mechanism to verify and communicate account connection status.
* Ensured secure access by hiding the button when users are not authenticated.
* Added Google Sheet Connector dashboard widget for quick access to the contact form connected with Google Sheet.
* Fixed : Debug log mechanism issues.

= 1.3.7
* Fixed : Solved Tab Id while adding tab id 0 by default.
* Fixed : Sheet URL and other links.

1.3.6

(08-08-2023)
* Fixed : Vulnerabilities issues.

1.3.5

(29-05-2023)
* Fixed : Vulnerabilities issues.
* Integraton : Conditions.(22-6-23)
* Fixed : Css Styles of integration.(22-6-23)
* Pro : Shows Pro Features.(22-6-23)
* System_Status_Added: (5-7-23)
* Logs_Func:(6-7-23)

1.3.4

(01-05-2023)
* Added : Remove access permission from google account while deactivating authentication.
* Fixed : Vulnerabilities issues.

1.3.3

(02-08-2022)
* Fixed “undefined function is_plugin_active()” issue.

1.3.2

(01-08-2022)
* New Google Integration method implemented using web app.

1.3.1

  • Added Validation for “Google Sheet Settings” Form.
  • Added “Open Sheet” Link and “Preview Sheet” Link under GSheetConnector feed settings page.
  • Allow use to fetch “Entry Date” in Google Sheet.
  • Displayed SpreadSheet Preview in under GSheetConnector feed settings page.
  • Displayed message While added wrong Auth tokens.

1.3

  • Compatible with Gravity Forms Version 2.5.8.2
  • Solved Date issues – Passing in Google Sheet
  • Solved Checkbox, Dropdown and other fields entries to Google Sheet

1.2

  • Fixed fatal error.

1.1

  • Fixed not saving of field type like checkbox, radio buttons, etc.
  • Updated API Library.

1.0

  • First public release
  • Integrated Gravityforms with Google sheets.

Details

  • Version: 1.3.12
  • Active installations: 1,000
  • WordPress Version: 5.6
  • Tested up to: 6.5.5
  • PHP Version: 7.2

Ratings


5 Stars
4 Stars
3 Stars
2 Stars
1 Stars