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

Configure Consent Screen

The Google Developer Console Consent Screen is part of the OAuth 2.0 authorization process used by applications requesting access to Google user data. When an application wants to access a user's data (e.g., their Google Drive files, calendar, or email), the consent screen is presented to the user. It allows them to review and grant permissions to the application before any data is accessed. Before the Google APIs can be integrated with Form.io, the consent screen must first be configured.

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

2. Select a Google User Type

1. Fill out the required application fields

1. Click Save and Continue through the application setup. Add any Scopes or Test Users if needed for your application.

1. By default, the application status will be set to Testing. In this Status, the application Refresh Token will continually expire.

Enabling Google APIs

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

1. Select the Google Drive API and Google Sheets API

1. Click Enable for both the Google Drive and Google Sheet APIs

Application Credentials

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

2. Click the +Create Credentials button

3. Select OAuth client ID

1. Select the Web Application option

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

3. Click the Create button

1. Take note of the Client ID and Client Secret. This information will be used in the next section.

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

   • Click the Close button

1. 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

2. Click the Authorize APIs button

1. Authenticate into the Google Drive platform

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

3. Click the Exchange authorization code for tokens button

4. 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 the Application Credentials section

3. Input the Refresh Token from the Google Refresh Token section