# Gravity Forms with Google Sheets Connector

- created: 07/10/2018
- by: wpexpertsio
- email: support@wpexperts.io

### 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.

## Try Live Demo URL:

#### Google Sheet:
https://docs.google.com/spreadsheets/d/1b78SHkAxUxp93pkZJPo1TtU4BU5ZCp7Fg_de6uaZ5iU/edit#gid=707548738

#### Gravity Form:
https://demo.gravitymore.com

## Plugin Requirement:

- Google sheet must be created with same email address which you used in receiving Google Access Code.
- Google sheet column names be placed against any form fields in google sheet gravity form settings. Not necessary for all fields it's up to you which fields you want to send.
- Google sheet columns names must not have spaces or any special characters in between.
- One gravity form can be integrated to only one google sheet.
- Connect any form to any google sheet.

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

### Configuration:

### Catch up with Easy Configuration in a few Steps:

Step 1: This is main settings page where you place Google Access Code.

Step 2: We have already set up oauth user or just need to click on button “Get Code” then you will be automatically redirect to get google access code, user must be logged in via gmail in order to get access code. That access code must be placed here and saved.

Step 3: 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 4: Form Settings: when you create a form then you need to setup 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 5: Form 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 text field to place name of 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 few fields.

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

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