---
sourceDocument: Yokohama ServiceNow AI Platform Administration
sourceDocumentLink: https://www.servicenow.com/docs/r/yokohama/platform-administration

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Create an application registry for Google Sheets on a ServiceNow instance

# Create an application registry for Google Sheets on a ServiceNow instance {#ariaid-title1}

* Release version: Yokohama
* 
* Updated May 9, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read

Register the Google Drive application in your ServiceNow instance to enable OAuth authorization for exporting table records directly to Google Sheets.

## Before you begin

Role required: admin

## About this task

An Application Registry is a record that defines how your ServiceNow instance can connect to an external application, such as Google Sheets, using OAuth.  
It includes the following information:

* Client ID and Client Secret: Credentials for the external application.
* Authorization and Token URLs: Web addresses used to log in and get access.
* Redirect URL: Where the OAuth server sends the user after authorization.
* Scopes and Profiles: Define what areas of ServiceNow the external application is allowed to access.
{#configure-app-registry-gsheets__ul_tyj_1n4_nfc}

## Procedure

1. Navigate to AllSystem OAuthApplication Registry.
2. Select New.
3. From the list of OAuth application types, select  Connect to a third party OAuth Provider.
4. On the form, fill in the fields.  
   {#configure-app-registry-gsheets__table_anc_b1w_gfc__entry__2}

   | Field | Description |
   |:-|:-|
   | Name | Name to uniquely identify the record. For example, Sheets Integration. |
   | Client ID | Client ID of the Google Drive application that you registered in Google Workspace. You can find the Google Client ID in the downloaded OAuth credentials JSON file. For more information, see [Set up the OAuth application on the Google Sheets API](https://www.servicenow.com/docs/LYTid9XxlnsOXQkEuXv9Ig "Set up the OAuth application on the Google Sheets API so that you can authenticate requests from your ServiceNow instance to access Google Sheets."). |
   | Client Secret | Client secret that was generated when you registered the app in Google API Console. You can find the Google client secret in the downloaded OAuth credentials JSON file. For more information, see [Set up the OAuth application on the Google Sheets API](https://www.servicenow.com/docs/LYTid9XxlnsOXQkEuXv9Ig "Set up the OAuth application on the Google Sheets API so that you can authenticate requests from your ServiceNow instance to access Google Sheets."). |
   | OAuth API Script | Script to customize the request and response. For example, OAuthGoogleSheetExport. |
   | Default Grant Type | Grant type that was used to establish the token. |
   | Authorization URL | URL that the OAuth application at Google provides to seek authorization to access the Google resource server. The URL format that you enter includes the tenant ID of your app: <kbd class="ph userinput">https://accounts.google.com/oauth2/v2.0/{API version}/authorize</kbd>. You can find the Authorization URL in the downloaded OAuth credentials JSON file. For more information, see [Set up the OAuth application on the Google Sheets API](https://www.servicenow.com/docs/LYTid9XxlnsOXQkEuXv9Ig "Set up the OAuth application on the Google Sheets API so that you can authenticate requests from your ServiceNow instance to access Google Sheets."). |
   | Token URL | URL to obtain the access token. The format that you enter for the URL is <kbd class="ph userinput">{yourgoogleaccount}.com/oauth2/{API version}/token</kbd>. |
   | Redirect URL | Redirect URL that includes the instance URL with the format <kbd class="ph userinput">https://&lt;your-instance&gt;.service-now.com/oauth_redirect.do</kbd>. Update the \<instanceURL\> value with your instance URL. |
   | Token Revocation URL | URL that is provided by the OAuth authorization server that enables a client application to request the revocation or cancellation of access tokens and refresh tokens that were previously issued. The format is https://{yourgoogleaccount}.com/{API version}/oauth2/revoke |
   [Table 1. Application Registries form]

   {#configure-app-registry-gsheets__table_anc_b1w_gfc}
5. Select Submit.
6. On the Application Registries page, search and select the application registry that you created.
7. In the OAuth Entity Scopes related list, enter <kbd class="ph userinput">https://www.googleapis.com/auth/drive.file </kbd> in the Name and OAuth scope fields.  
8. In the OAuth Entity Profiles related list, select Sheets Integration default_profile.
9. In the OAuth Entity Profile Scopes related list, enter <kbd class="ph userinput">https://www.googleapis.com/auth/drive.file</kbd> in the OAuth Entity Scope field.  
10. Select Update.

*[\>]: and then