In Uncategorized

1.INTRODUCTION #

Gravity Forms with Google Sheets connector is a WordPress Add-on that helps you to send Gravity Forms data on Google Spreadsheet, once user submits the form. connect each gravity form with its own Google Spreadsheet to manage data. You can link all Gravity forms to Google Spreadsheet

2.ADDON FEATURES #

  • Send your Gravity Forms Data to Google Spreadsheet after submission of forms on your site by user.
  • Each Gravity form has its own separate Google Spreadsheet
  • Once user submit forms, all data will be added in selected Sheet as a new row for each field. Also select fields in backend which you want to show on Spreadsheet.
  • All data will be listed horizontally on a sheet.

3.HOW TO GET CLIENT ID AND CLIENT SECRET ID FROM GOOGLE DEVELOPERS CONSOLE #

  • Click on the option “Select a project”, after which a window will pop-up. Then, click on the “New Project” option.

  1. Add your project name.
  2. Browse your location OR choose the option, “No Organization”.
  3.  Click on the “Create” button.

  • Navigate to the left and click on “Oauth Consent Screen.”

  1. Select the “External” radio button.
  2. Click on the “Create” button.

  1. Add an “Application Name” in the field.
  2. Click on the “Save” button.

  1. Navigate through the menu on the left and click on “Credentials”.
  2. Click on the “Create Credentials” button.
  3. Select “Oauth Client Id” from the dropdown menu.

  • Select Application type to “Desktop App“.
  • Add the text you desire in the field under “Name”.
  • Click on the “Create” button.

  1. Copy “Your Client ID”.
  2. Copy “Your Client Secret”.

  • Navigate to the “Forms” tab in the Dashboard menu and click on “Settings”.
  • On the left, go to “Google Sheets

  1. Paste “Client ID” and “Client Secret ID” in their respective fields.
  2. Click on the “Save” button.
    *the Google Access Code field will remain disabled until you paste the Client ID & Client Secret ID*.

  • Click on the “Get Code” button.

  1. You will be redirected to the Gmail sign in
  2. Choose your Gmail account to connect with Gravity Form with Google Sheet Connector.

  • Click on the “Allow” button.

  • Click on the icon to copy the “code” (as shown in the image).

  • Paste the Copied code in the Google Access Code” Field.
  • Click on the “Save” button.

GRAVITY FORM WITH GOOGLE SPREADSHEET CONNECTOR IS CONNECTED TO YOUR GOOGLE ACCOUNT.

4.HOW TO USE PLUGIN #

Note: Google Sheet column name must NOT have space or Special characters.

Catch up with Easy Configuration in a few Steps:

Step 1: Once you create forms it shows settings against each form you can integrate only one google sheet for one gravity form you can enable disable using google sheets for any form any time.

Step 2: Form Settings: when you create a form then you need to set up any form to be connected to your google sheet. First of all, you need to enable form to be connected to google sheet by clicking on checkbox “Enable for this form” after that you need to provide Google sheet name, you created with same email address which was used to get google access code and sheet tab name might be your sheet has multiple tabs so provide one tab name in which you want to receive data

Step 3Form Fields to Google Sheet Columns Names Connection
At this stage you will see below this section many fields, all are dynamic according to your form as you created in Gravity forms. All fields will be shown with labels against the text field to place the name of the google sheet column, export any form field to that google sheet column. It’s up to you whether you want to export whole form fields to google sheet or only a few fields.

 

Note: Google sheet column names must NOT have any space in between and also not contain a special characters.

 

Step 4Error Log: After following the settings if you find out plugin is not working properly then view the log for error.

Help Guide Powered by Documentor
Suggest Edit

Leave a Comment

This Website uses cookies to make the website work, for traffic measurement and optimization of page content. By using our Website, you agree to the use of cookies for these purposes. You can read more about cookies in our privacy and cookie policy.

OK