Gravity Forms Google Sheet Connector

Description

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
>

Screenshots

  • Google Sheet Integration without authentication.
  • Permission page if user is already logged-in to there account.
  • Permission popup-1 after logged-in to your account.
  • Permission popup-2 after logged-in to your account.
  • After successful integration – Displays “Currently Active”.
  • Get Sheet and Tab Id from the URL.
  • Google Sheet settings page with input box Sheet Name, Sheet Id, Tab Name, Tab Id.
  • Add Gravity Forms field name to the Google Sheet headers.
  • Google Sheet headers with form submitted data.

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!

Reviews

يونيو 15, 2024
I inherited a website and we needed to make very complicated forms that then connected to Google sheets, this plugin was PERFECT, there was an issue on the existing site that caused a blip but Jina and Abdullah were just amazing and hopped on and spent a long time tracking down and then fixing the issue! myself and my client are so impressed with their service, i can’t recommend them enough! thanks guys
ماي 1, 2023
We use the Google Sheet Connector plugin with all of our clients who have Wordpress websites. Paired with another plugin that lets us see UTM parameters for people who fill out contact forms, we are able to quickly and easily track which of our marketing campaigns are working the most effectively.
يوليوز 27, 2022
Great plugin although, there were a couple of issues with the Pro version of the plugin but the developer was super quick responding and the issues were fixed in no time at all! I would highly recommend this!
يونيو 9, 2020
*Still need some feature to be perfect. But thank you for this useful plugin, 5 Star for you.
ماي 13, 2020
The first solution I tried required me to setup API keys through the Google developer portal. After spending 30 minutes setting it up– it didn’t work. Then I found this little gem with no reviews and decided to give it a try. LITERALLY 3 minutes later I had my form connected to a Google sheet and it worked perfectly. Great job developing a SIMPLE and ELEGANT solution.
Read all 5 reviews

Contributors & Developers

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

Contributors

Changelog

1.3.14

(10-08-2024)
* Added: Display a notification when authentication expires.

1.3.13

(30-07-2024)
* Fixed: Google hasn’t verified this app error.

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.