Here is an alternative method to using Zapier or other external services for sending your Gravity Form submissions to a Google Sheet. This is helpful if you want to track orders, process applications or simply manage the submitted data in a google sheet, and share it with others.
You will need the following:
- A Gravity Forms license, if you don’t, one can be purchased here: Get your Gravity Forms License.
- A 3rd party API plugin or coding skills to write the connection yourself. Here are 2 great free plugins that can do this: GravityPlus Post to 3rd Part API or Forms: 3rd Party Integration
- A Google Script attached to a Google Sheet that is deployed as a Web App (explained below).
Here are the step by step directions for sending your form entries to Google Sheets:
- Create a Google spreadsheet and add a header row to the spreadsheet. Keep in mind that changing the name of and column after this is set up will break the connection for the field that is sent to that column.
- On the top of your Google Spreadsheet, Go to Tools > Script editor to add a new Google Script that will be attached to this Sheet.
- Delete any data that is in on the Script and copy and paste the script below:
- Save your script by clicking File > Save , you will need to give your script a name.
- Run the script by pressing the Play button icon in the menu. A permission box should pop up, click continue and then allow.
- Deploy the script as a Web App by clicking on Publish > Deploy as web app
- Project Version: Leave default or enter 1.0.0
- Execute the app as: Myself
- Who has access to the app: Anyone, even anonymous
- Click Deploy and then Copy the current web app URL from the confirmation screen. This is now your API URL to use in the Post to 3rd Party API for Gravity forms.
- If you are using the Gravity Forms Post to 3rd Party API plugin: Create a new Send to Third Party feed for your form by going to Forms > Your Form > Settings > Send to Third Party > Add New
- Name: Any Name you choose
- Method: POST
- API URL: Paste the URL that you copied from the Google Script Web App
- Authorization: None
- Headers: Leave Blank
- Format: Default
- Map API Parameters to Form Fields: In the first column, enter the column titles from your google sheet, they must match exactly. Select which form field you want mapped to that column in your google sheet via the dropdown.
- Conditional Logic: Optional – you can add conditional login to this connection in order to limit which form entries get sent to your google sheet.
- Save the feed and submit a test form to see it work.