DocuPhase Forms latest - This documentation is for DocuPhase Forms v11.3. Not for you? Earlier documentation is available too.
Google Connector (Legacy)
- Megan Ellis
The Google Connector (Legacy) has been replaced by a new connector that uses signed JWT (JWS) to replace OAuth token-based authentication. The documentation below is only relevant for customers using the legacy connector (configured prior to DocuPhase Forms v11.3.x). We strongly recommend switching to the new connector at your earliest convenience.
The Google Connector (Legacy) is deprecated, meaning it will not receive bug fixes or enhancements, and will eventually be retired and removed from DocuPhase Forms in a future release.
Does your organization use Google Apps? Combining Google Sheets/Drive and frevvo 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. frevvo provides a Google Connector that supports direct connectivity between frevvo and Google Sheets/Drive. Here are just a few useful solutions that you can try.
- Save your submissions to a Google Sheet
- Create a Dynamic Pick List from a Google Sheet (Legacy)
- Populate Fields with Data from a Google Sheet
- Update a Google Sheet with values from a form.
- Save documents generated by your frevvo form to Google Drive
- Single Sign On to frevvo using your Google credentials.
Cloud Customers
Cloud customers using the Google Connector for the first time will need to:
- Sign up for a Google Account
- Obtain Google Account Access Token(s).
- Click one of the links above to see how to connect your forms/workflows to Google Sheets & Drive.
In-house Customers
In-house customers will need to:
- Check the Google Connector Release Notes for more information and the compatibility matrix.
Install and Configure the Google Connector.
frevvo only supports/certifies the Google Connector running in the Apache Tomcat container.
- Sign up for a Google Account.
- Obtain Google Account Access Token(s).
- Click one of the links above to see how to connect your forms/workflows to Google Sheets & Drive.
frevvo 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/workflows. This is recommended for the following reasons:
- It will eliminate confusion when searching for the correct sheet that integrates with your forms/workflows.
- When you use Google Wizards it will show all sheets that are available for integration in the dropdown.
- Reduces the chance of another user changing a column or worksheet tab name which could break integration with your forms/workflows.