Google Spread Sheet In Gravity Forms Is Now Fully Compatible With Gravity Forms 2.5 Version.
Gravity Forms with Google Sheets connector is a WordPress add-on that helps you export your Gravity Forms data on a Google Spreadsheet after the user has submitted the form on your site.
Connect and manage each Gravity Form’s data with its own Google Spreadsheet. This will allow you to filter data as required making data management simple and easy.
Note: Column name/labels on the Google Spreadsheet are NOT allowed to have spaces or special characters.
Step 1: Select the “Google Sheets” option under the “Forms” tab on the main menu. Here, you will find the main settings page where you can place the Google Access Code.
Step 2: Once the user is set up, click on the “Get Code” button, which will automatically redirect you to a “Google Sheet Connection” page.
NOTE: The user must be logged-in via Gmail in order to get the access code.
Place the access code in the field and click “Save.”
Step 3: Now that the forms have been created, click on the “settings” option under the selected form to integrate it with the Google Spreadsheet.
You can enable/disable the Google Sheet with any Gravity Form you want.
NOTE: You are allowed to integrate no more than just ONE Google Sheet with ONE Gravity Form.
Step 4: Form Settings: After you create a form, the first thing that you need to do is set up and connect the form with a Google Spreadsheet. For that, you need to enable the form’s connectivity by clicking on the checkbox labeled “Enable for this form”.
After that, simply type-in a Google Sheet name. Your Google Sheet will have multiple tabs under it, so provide the name of your primary tab (the one where you want to receive your initial data.)
Step 5: Connect the Gravity Form’s fields with the column names on your Google Sheet. After setting up your Google Sheet, you will move forward to a section labeled “Assign Google Sheet Column names for Field name.”
Here, you will see multiple fields that are aligned according to the one you created in your Gravity Form. Now, you will be able to export the Gravity Form fields to your Google Sheet column.
NOTE: You can either export all Gravity Form fields to the Google Sheet or just a few, the choice is yours.
Note: Column names/labels on the Google Spreadsheet are NOT allowed to have spaces or special characters.
Step 6: Error Log: Congratulations! We’re done with the settings configuration. If you find that your plugin is not working, please click on the “View” button under the “Debug Log” option to review errors (if there are any.)
Version: 1.3 Date : 07/04/2022 - Code improvement - Tested with WordPress 5.9+
Version: 1.2 Date : 12/10/2021 * Added - Compatibility with google spreadsheet v4 api * Added - Expiry token check before hitting api request * Added - Metafields section in admin side * Added - CURL converted into wp_remote. * Fixed - Datepicker export issue * Fixed - Some bug fixes * Fixed - Sync all entries issue * Fixed - Sheet tab 2 issue * Fixed - Entryid, Entrydate and pagination of entries
Version: 1.0.9 Date : 13/08/2020 Fixed - Options for single field label displaying even if we select 'Use form field labels' option
Version: 1.0.8 Date : 03/07/2020 Added - option to send Entry metadata to google sheets Fixed - 'Sync All Entries' Limited to 20 entries, increased limit to 1000 entries
Version: 1.0.7 Date : 02/25/2020 Added - Settings for Google API Client ID and Client Secret
Version: 1.0.6 Date : 12/27/2018 Fixed - Authentication issue. Fixed - settings saving issue.
Version: 1.0.5 Date : 11/26/2018 Added - Select any spreadsheet from drop-down Added - Assign custom column names or use form field names for columns of spreadsheet. Added - Enable/disable spreadsheet respective row should be updated on edit/update of gravityforms entries. Added - Export spreadsheet to csv on one click Added - Conditional logic for form data to be submitted to spreadsheet.
Version : 1.0 Date : 10/07/2017 initial release.
After click you will redirected to the partner website
CommentAsk on GitHub