Live Forms v7.4 is no longer supported. Please visit Live Forms Latest for our current Cloud Release. Earlier documentation is available too.

Google Connector

Owned by Former user (Deleted)
Last updated: Dec 06, 2019 by Megan Ellis

*Urgent* On Premise Customers Action Required: On-premise customers using the Google Connector must upgrade to LiveForms v9 and Google Connector v3.0 by February 1, 2020.

Does your organization use Google Apps? Combining Google Sheets/Drive and provides interesting and useful ways to solve real business problems. From electronic signatures to dynamic pick lists to using Google Drive as a content repository to approval workflows, the combination just makes completing routine, day-to-day business tasks easier.   provides a Google Connector that supports direct connectivity between and Google Sheets/Drive. Here are just a few useful solutions that you can try.

  1. Save your submissions to a Google Sheet
  2. Create a Dynamic Pick List from a Google Sheet
  3. Populate Fields with Data from a Google Sheet
  4. Update a Google Sheet with values from a form.
  5. Save documents generated by your frevvo form to Google Drive
  6. Single Sign On to Live Forms using your Google credentials.

Cloud Customers

Cloud customers using the Google Connector for the first time will need to:

In-house Customers

In-house customers will need to:

customers building applications that are high volume and address critical business processes should not use Google Sheets in place of a production quality database.

Google Sheet Best Practice

Create a new user in your Google domain and make that user the owner of all the Google sheets that integrate with your forms/flows. This is recommended for the following reasons:

  1. It will eliminate confusion when searching for the correct sheet that integrates with your forms/flows.
  2. When you use the Google Wizards it will show all sheets that are available for integration in the dropdown.
  3. Reduces the chance of another user changing a column or worksheet tab name which could break integration with your forms/flows.