Google Spread Sheet In Gravity Forms

Description

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 Add-on Features Export and manage your Gravity Forms Data using Google Spreadsheet after the user submits a form on your site Simultaneously manage unlimited forms without any problem Each Gravity form will have its own separate Google Spreadsheet Data from a new form will be added on a pre-selected sheet as a new row under each field Have the ability to filter the data according to your requirements Choose the visibility preference for each field on the Spreadsheet Show the data you think is relevant All data will be listed horizontally on a sheet Note Column name labels on the Google Spreadsheet are NOT allowed to have spaces or special characters HOW-TO-GUIDE How to add the Google API KEY 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 LINKS TO SOME MORE GRAVITY FORMS INTEGRATIONS WorldPay with Gravity Forms Gravity Forms Smart Uploads Gravity Forms with Google Cloud Printers Gravity Forms Address Google Autocomplete Gravity Forms Payment Gateway for Sumup Payeezy with Gravity Forms Pay with Square in Gravity Forms Gravity Forms Import Entries Add on Gravity Forms Restrict Dates Add on Gravity Forms Preview Add on Changelogs Version 1 3 1 Date 08 08 2022 – Code improvement Vulnerability fixes 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