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.

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

July 26, 2021
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!
June 9, 2020
*Still need some feature to be perfect. But thank you for this useful plugin, 5 Star for you.
May 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 3 reviews

Contributors & Developers

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

Contributors

Changelog

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.