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 add-in.
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. |