Create an application registry for Google Sheets on a ServiceNow instance
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.
Procedure
Navigate to All > System OAuth > Application Registry.
Select New.
From the list of OAuth application types, select Connect to a third party OAuth Provider.
On the form, fill in the fields.
| 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. | ||
| 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. | ||
| 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: `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. | ||
| Token URL | URL to obtain the access token. The format that you enter for the URL is `{yourgoogleaccount}.com/oauth2/{API version}/token`. | ||
| Redirect URL | Redirect URL that includes the instance URL with the format `https://| 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 |
Image omitted: oauth-entity-scopes.png OAuth Entity Scopes related list displays the Name and OAuth scope fields to define the OAuth scope for this OAuth provider.
Image omitted: oauth-profile-scope.png OAuth Entity Profile Scopes related list displays the OAuth Entity scope field to define the OAuth scope that is associated with this profile.
Parent Topic:Exporting your table records to Google Sheets |