Google Developer Console

Google Developer Console allows you to build, deploy, and scale applications, websites, and services on the same infrastructure as Google. Form.io offers several direct integration options under the Google Developer Console umbrella such as:

• Google Drive Storage

• Google Oauth

• Google Sheets

To leverage these features, a Google project must first be established and then integrated with a Form.io Project. The following documentation will guide you through creating a Google project, establishing the correct APIs, and connecting it to your Form.io project.

Google Project

1. Login to your Google Developer Console

2. Click the +Create Project button (or select an existing one)

3. Give the Project a name and click Create

Google APIs

1. Within your Google project navigation bar, click the APIs and Services product and then Library

2. Select the Google Drive API and Google Sheets API

3. On the next screen, click Enable for both the Google Drive and Google Sheet APIs

4. Within your Google project navigation bar, click the Credentials tab

5. Click the +Create Credentials button

6. Select OAuth client ID

7. Select the Web Application option

8. Within the Authorized redirect URIs section, click the +ADD URI button and add the following: https://developers.google.com/oauthplayground

9. Click the Create button

10. Take note of the Client ID and Client Secret

Google Refresh Token

Generates a token that allows users access to the Google APIs.

1. Navigate to the following URL: https://developers.google.com/oauthplayground

2. Click the Gear icon found in the top right corner of the page.

3. Ensure the following settings are configured

   • OAuth flow: Server-side

   • Access type: Offline

4. Check the Use your own OAuth credentials

   • Add the Google Project Client ID and Client Secret from the previous steps

4. Within the API list, expand the Google Sheets API v4

   • Check the following API endpoints https://www.googleapis.com/auth/drive https://www.googleapis.com/auth/spreadsheetsXCCC

5. Click the Authorize APIs button

6. Authenticate into the Google Drive platform

7. Click Allow to give the Google Project access to the Google Drive of the authenticated user

8. Click the Exchange authorization code for tokens button

9. Take note of the Access Token and the Refresh Token

Form.io Integration

Integrate the Google Project into the Form.io Project.

1. Within the Form.io Project, navigate to the Google Drive configuration Settings > Integration > Data Connections > Google Drive

2. Input the Client ID and Client Secret from step 10 of the Create Google API section

3. Input the Refresh Token from step 9 of the Google Refresh Token section