JDBC Driver for Google Sheets

Build 24.0.9060

OAuth Scopes and Endpoints

Required Scopes and Endpoint Domains for Google Sheets

When integrating with Google Sheets, your application needs specific permissions to interact with the API.

These permissions are defined by access scopes, which determine what data your application can access and what actions it can perform.

This topic provides information about the required access scopes and endpoint domains for the Google Sheets driver.

Understanding Scopes

Scopes are a way to limit an application's access to a user's data. They define the specific actions that an application can perform on behalf of the user.

For example, a read-only scope might allow an application to view data, while a full access scope might allow it to modify data.

Required Scopes for Google Sheets

Scope Description
drive.readonly Allows you to list all spreadsheets. Required for read access.
drive Allows you to list all spreadsheets. Required for write access.
spreadsheets.readonly Allows you to pull data from specific spreadsheets. Required for read access.
spreadsheets Allows you to pull data from specific spreadsheets. Required for write access.

Understanding Endpoint Domains

Endpoint domains are the specific URLs that the application needs to communicate with in order to authenticate, retrieve records, and perform other essential operations.

Allowlisting these domains ensures that the network traffic between your application and the API is not blocked by firewalls or security settings.

Note: Most users do not need to make any special configurations. Allowlisting is typically only necessary for environments with strict security measures, such as restricted outbound network traffic.

Required Endpoint Domains for Google Sheets

Domain Always Required Description
accounts.google.com True The domain used for performing OAuth authorization for Google Sheets.
sheets.googleapis.com True The base URL of the service used to retrieve sheets.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060