{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":39903,"path":"platform-administration/table-administration-and-data-management/configure-app-registry-gsheets.md","title":"Create an application registry for Google Sheets on a ServiceNow instance","bundle":null,"doc_type":null,"release":"australia","body":"\n# Create an application registry for Google Sheets on a ServiceNow instance\n\nRegister the Google Drive application in your ServiceNow instance to enable OAuth authorization for exporting table records directly to Google Sheets.\n\n## Before you begin\n\nRole required: admin\n\n## About this task\n\nAn Application Registry is a record that defines how your ServiceNow instance can connect to an external application, such as Google Sheets, using OAuth.\n\nIt includes the following information:\n\n- Client ID and Client Secret: Credentials for the external application.\n- Authorization and Token URLs: Web addresses used to log in and get access.\n- Redirect URL: Where the OAuth server sends the user after authorization.\n- Scopes and Profiles: Define what areas of ServiceNow the external application is allowed to access.\n\n## Procedure\n\n1. Navigate to **All** > **System OAuth** > **Application Registry**.\n\n2. Select **New**.\n\n3. From the list of OAuth application types, select  **Connect to a third party OAuth Provider**.\n\n4. On the form, fill in the fields.\n\n\n
\n\nField\n\n\n\nDescription\n\n
\n\nName\n\n\n\nName to uniquely identify the record. For example, Sheets Integration.\n\n
\n\nClient ID\n\n\n\nClient 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://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/table-administration-and-data-management/set-up-oauth-app-gsheets-api.md).\n\n
\n\nClient Secret\n\n\n\nClient 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://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/table-administration-and-data-management/set-up-oauth-app-gsheets-api.md).\n\n
\n\nOAuth API Script\n\n\n\nScript to customize the request and response. For example, OAuthGoogleSheetExport.\n\n
\n\nDefault Grant Type\n\n\n\nGrant type that was used to establish the token.\n\n
\n\nAuthorization URL\n\n\n\nURL 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: `https://accounts.google.com/oauth2/v2.0/{API version}/authorize`.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://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/table-administration-and-data-management/set-up-oauth-app-gsheets-api.md).\n\n
\n\nToken URL\n\n\n\nURL to obtain the access token. The format that you enter for the URL is `{yourgoogleaccount}.com/oauth2/{API version}/token`.\n\n
\n\nRedirect URL\n\n\n\nRedirect URL that includes the instance URL with the format `https://.service-now.com/oauth_redirect.do`.Update the <instanceURL> value with your instance URL.\n\n
\n\nToken Revocation URL\n\n\n\nURL 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\n\n
5. Select **Submit**.\n\n6. On the Application Registries page, search and select the application registry that you created.\n\n7. In the OAuth Entity Scopes related list, enter `https://www.googleapis.com/auth/drive.file` in the **Name** and **OAuth scope** fields.\n\n \\[Omitted image \"oauth-entity-scopes.png\"\\] Alt text: OAuth Entity Scopes related list displays the Name and OAuth scope fields to define the OAuth scope for this OAuth provider.\n\n8. In the OAuth Entity Profiles related list, select **Sheets Integration default\\_profile**.\n\n9. In the OAuth Entity Profile Scopes related list, enter `https://www.googleapis.com/auth/drive.file` in the **OAuth Entity Scope** field.\n\n \\[Omitted image \"oauth-profile-scope.png\"\\] Alt text: OAuth Entity Profile Scopes related list displays the OAuth Entity scope field to define the OAuth scope that is associated with this profile.\n\n10. Select **Update**.\n\n\n**Parent Topic:**[Exporting your table records to Google Sheets](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/platform-administration/table-administration-and-data-management/setup-gsheet-export.md)\n\n"}}