Gravity Forms with Google Sheets connector is a wordpress Add-on which helps you to send Gravity Forms data on Google Spreadsheet, once user submit the form. connect each gravity form with it’s own Google Spreadsheet to manage data. You can link all Gravity forms to Google Spreadsheet
- 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.
Add Google API key settings
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.
Step 6: Error Log: After following the settings if you find out plugin is not working properly then view log for error.
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.