Google Developer Console
Last updated
Last updated
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:
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.
Login to your Google Developer Console
Click the +Create Project button (or select an existing one)
Give the Project a name and click Create
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.
Within your Google project navigation bar, click the APIs and Services product and then OAuth consent screen
Select a Google User Type
Fill out the required application fields
Click Save and Continue through the application setup. Add any Scopes or Test Users if needed for your application.
By default, the application status will be set to . In this Status, the application Refresh Token will continually expire. A manual refresh of the token is required or a setting can be configured that will refresh the token automatically after the expiration window.
You can also Publish your application
By default, the application status will be set to . In this Status, the application Refresh Token will continually expire.
Within your Google project navigation bar, click the APIs and Services product and then Library
Select the Google Drive API and Google Sheets API
Click Enable for both the Google Drive and Google Sheet APIs
Within your Google project navigation bar, click the APIs and Services product and then Credentials
Click the +Create Credentials button
Select OAuth client ID
Select the Web Application option
Within the Authorized redirect URIs section, click the +ADD URI button and add the following:
https://developers.google.com/oauthplayground
Click the Create button
Take note of the Client ID and Client Secret. This information will be used in the next section.
Generates a token that allows users access to the Google APIs.
Navigate to the following URL: https://developers.google.com/oauthplayground
Click the Gear icon found in the top right corner of the page.
Ensure the following settings are configured
OAuth flow: Server-side
Access type: Offline
Check the Use your own OAuth credentials
Add the Google Project Client ID and Client Secret from the previous steps
Click the Close button
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
Click the Authorize APIs button
Authenticate into the Google Drive platform
Click Allow to give the Google Project access to the Google Drive of the authenticated user
Click the Exchange authorization code for tokens button
Take note of the Access Token and the Refresh Token
Enable the 'Auto-refresh token before expiration' setting to automatically generate a new token when the current one expires. If this setting is not enabled, users will need to manually refresh the token or update the expiration time
Integrate the Google Project into the Form.io Project.
Within the Form.io Project, navigate to the Google Drive configuration Settings > Integration > Data Connections > Google Drive
Input the Client ID and Client Secret from the Application Credentials section
Input the Refresh Token from the Google Refresh Token section
