You can use Google Drive as an affordable system for managing documents. When a Permission Form is signed, a Leave Approval workflow completes, or a Purchase Order is received, you want to save the documents somewhere. Many companies still save them in email folders as attachments or manually drop them into a shared network drive. With frevvo you can automatically upload them to Google Drive.

We’ve created a sample form and a shared Google Drive folder for demo purposes. Ironically, it’s a paper permission form that a parent must sign so students can use less paper and do things electronically

Click on the link above or on the image, fill in a student name, sign the form and enter an email address (don’t worry, it’s only used for this demo to email you the signed PDF. We won’t save it, it won’t appear on the PDF and it won’t be saved to Google Drive). When you submit, the form gets uploaded to Google Drive and saved in a folder with the student’s name so you can easily find it later. You’ll also get an email.

Step 1: Obtain the Google Account Access Token

If you do not have an access token for your Google Account, perform this one-time step.

Follow these steps to obtain your Google Account token.

1. Login to your Google Account

2. Go to:

   1. Cloud customers: https://app.frevvo.com/google/consent

   2. In-house customers: http://<your frevvo server domain name>/google/consent

3. Click Allow if you see a screen like the one below (Google often updates their UI so this may differ from what you see).
   
   

4. Copy the access token. Save it to a safe location, you will use it when configuring your forms/workflows.

Step 2: Connect your own form or workflow to Google Drive.

The Send to Google Drive wizard steps you through the process of saving your documents to Google Drive.

1. In Google Drive, create a parent folder that will hold all the submissions for this form/workflow.
2. Log into your frevvo tenant as a designer user.
3. Edit your form/workflow and go to the Settings editing mode.
   
4. Click the Document Actions tab. Select Send to Google Drive on the Send Documents tab.
5. In the wizard that appears, enter your credentials (see above for how to get an access token). Note that the email field is optional and intended only to describe which account is associated with the access token. This email does not validate against the token provided.
   
6. Select the parent folder you created earlier in Step 1.

7. For the Submission folder, you may enter a fixed value (not recommended) or use a template. In this case, we have chosen the StudentsName control. For example, if you enter John Adams in the Student Name control, the submission documents will be stored in a subfolder called JohnAdams.

8. Select which documents to send.
   1. Snapshot (PDF, PNG, or JPG)
   2. Data (the submission.xml)
   3. Attachments uploaded by the user
   4. Generated PDF forms - send all, none, or select mapped PDFs.

If you want to save a pdf of your form/workflow to the Google folder, make sure you have Save PDF checked. An optional field that is used to name the pdfs displays. You can use templates in this field. For example, if you have a control called EmployeeName in your form, you can type {EmployeeName} into the PDF Name field and the pdf's in the Google folder will be named {EmployeeName}.pdf 

Troubleshooting

"An unknown error has occurred" message

You may see the error message "An unknown error has occurred" when selecting your Google sheet from the dropdown after you log into the wizard with your Google account and access code. To prevent this, set the Share permission for your Google Sheet to private then run the Save to Google Spreadsheet wizard. Change the share permission to public once the wizard is completed. Click here for other reasons this error may occur.