Create OAuth2 developer application in Google
The Google Cloud administrator registers an OAuth Client ID in Google.
They will need the Posit Connect redirect URL which is defined as https://connect.example.org/__oauth__/integrations/callback
Replace connect.example.org
with the address of the Connect server.
The Connect Administrator must obtain the client ID and client secret from the Google Cloud administrator.
Google requires Confidential OAuth clients. Public clients are not allowed.
Create OAuth integration in Posit Connect
The Posit Connect administrator creates an OAuth integration through the Integrations tab on the Connect dashboard. Once the OAuth integration has been created in Connect, it is available for use by all publishers.
APIs and Services that are enabled for your Google Cloud project can be set within your Connect OAuth integration using scopes. By default the read and write BigQuery API v2 scopes are included with the Google OAuth integration, but these can be modified to leverage all of Google’s APIs and services. For example, full access to Google Drive and Google Sheets requires the following scopes:
https://www.googleapis.com/auth/spreadsheets
https://www.googleapis.com/auth/drive
Read-only access to Google Drive and Google Sheets requires the following scopes:
https://www.googleapis.com/auth/spreadsheets.readonly
https://www.googleapis.com/auth/drive.readonly
For more information, please see the full list of OAuth2 scopes for Google’s APIs and services.