What is Google Drive Integration?
Google Drive integration allows your form's results or uploaded files to be sent to your Google account's Google Drive.
The Google Drive integration feature requires a Pro 2 level or higher Formsite account to send results (because it uses the Results Docs feature) or a Pro 1 level or higher Formsite account to send uploaded files, and a Google account.
Create a New Integration
On your form's "Integrations" page, click the integration for "Google Drive". Then, click the "Get Authorization" button to authenticate and connect with your Google account. You'll be asked to log into Google, if you're not already. When you're finished, click the "Save" button.
Collecting Google Drive Results
When a form user completes your form, their results or uploaded files will be sent to your Google Drive. Google Drive allows multiple files and folders to share the same name, so if different files get sent with the same name they'll all be stored.
When using a folder, if you have multiple folders with the same name, the integration will use whichever one Google returns first, which might not be consistent. It's best to keep folder names unique to make sure files always go to the same place.
If you delete the folder you're sending files to, Google Drive will first move it to the Trash. Be sure to permanently delete the folder (empty the Trash) or it will continue to receive files in the Trash.
Note: The integration can only send new files to Google Drive, it can't retrieve or delete existing files.
Tips and Troubleshooting
If, for some reason, a result wasn't sent to Google Drive, or your form wasn't integrated yet when the result was collected, you can resubmit it to Google Drive on your form's "Results" page, by editing and saving the result. If needed, the result's status can be manually changed to "complete" by clicking its status icon.
Sending large files to Google Drive can take a long time. There's not an exact size limit, but sending more than 50 MB of files can sometimes cause the submission to "time out", which means the submission exceeds your browser's wait time and it gives up waiting for a response. To prevent this, you can limit the allowed size of uploaded files using the File Upload item's "Max file size" setting.
Google has a limit of 50 authorization tokens per Google account per app. If you integrate your Google account with more than 50 Formsite forms and exceed this limit, they may start revoking older tokens and cause the integrations for those forms to fail. If you need to integrate with more than 50 forms, you can work around this by copying the value of the "Token" setting from a working form into an older form so they share the same token and reduce the total number of tokens you're using. Google also suggests using multiple Google accounts to decrease the number of integrations in a single account.