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.