Set up the Google Sheet spoke

Set up an outbound integration between your ServiceNow instance and the Google Sheets by setting up a connection and credential record.

시작하기 전에

• Request an Integration Hub subscription.
• Activate the Google Sheets spoke plugin.
• Role required: admin.

이 태스크 정보

The Google Sheets API authenticates the requests from your ServiceNow instance through an OAuth application. You must Set up OAuth app on Google Sheets API by visiting the https://console.developers.google.com/. The connection and credentials record contains the information the Google Sheets API must authenticate the requests from your ServiceNow instance.

Set up OAuth app on Google Sheets API

Set up an OAuth application on the Google Sheets API to enable authentication of requests from your ServiceNow instance.

시작하기 전에

• Create a business account on https://console.developers.google.com/
• Create a domain and an email address associated with the domain. For example, www.mydomain.com and [e-mail].
  주:

  You can only register one email address per domain in Google Workspace.
• Role required: admin

프로시저

1. Set up a project on the Google Workspace.
   The project includes the details of the OAuth application and the Application Programming Interface (API) permissions, if applicable.
   1. Log in to https://console.developers.google.com/ with the same domain email ID and password as mentioned in the prerequisites.
   2. Select the button.

      

   3. Select NEW PROJECT.

      

   4. In the Project name* field, enter a unique name for the project.
   5. In the Location* field, select BROWSE to select an organization.
   6. Select CREATE.
      The project is created.
   7. Select the button.

      

2. Select the project that you created.

   

3. Enable the Google Sheets API.
   1. Click +ENABLE APIS AND SERVICES.

      

   2. On the Welcome to the API Library page, enter Google Sheets in the search box.
   3. Press Enter.
   4. Select the Google Sheets API button.
   5. Select ENABLE.
      The Google Sheets APIs are enabled on your project.
4. Create the OAuth app and credentials.
   1. Select CREATE CREDENTIALS.
      
   2. Fill the form.

      표 1. Google Sheets API credentials

      Field	Description
      Select an API*	Name of the API for which you're creating the credentials. 주: Ensure that you select Google Sheets API.
      What data will you be accessing? *	Type of data your ServiceNow will access through the APIs. 팁: Select User data.

   3. Click NEXT.
   4. Fill the form.

      표 2. Google Sheets API credentials

      Field	Description	Mandatory?
      App name	Name of the OAuth app.	Yes
      User support email	Email at which users can send queries to you about their consent.	Yes
      Logo file to upload	Logo representing the OAuth app.	No
      Developer contact information	Google will contact the developer of the OAuth app if there are any changes to the project.	Yes

   5. Click SAVE AND CONTINUE.
5. 옵션: Define the API scopes.
   API scopes enable you to select specific APIs. For example, /auth/spreadsheets scope enables you to create, edit, or remove spreadsheets.
   1. Click ADD OR REMOVE SCOPES.
   2. Enter Google sheets API, as shown in the image.
      
   3. Select one or more scopes.
   4. Click UPDATE.
   5. Click SAVE AND CONTINUE.
6. Generate OAuth client ID.
   1. From the Application type* list, select Web application.
   2. In the Name* field, enter a unique name of the OAuth client.
7. Under the Authorised redirect URIs heading, click + ADD URI.
8. In the URI field, enter the redirect URI in the following format: https://instance.service-now.com/oauth_redirect.do.
9. Click CREATE.
   The OAuth details are generated in a JSON file.

   팁:

   Click DOWNLOAD to download the JSON file for later reference.

   

10. Click DONE.
    You've created the OAuth application on Google Workspace.

Create Connection and Credential record for Google Sheets spoke

Create a connection and credential record that contains the details required to connect to the Google Sheets Application Programming Interfaces (API) on the Google Workspace.

시작하기 전에

• Create an OAuth application for the Google Sheets APIs in the Google Workspace. To learn how to create an OAuth application, see Set up OAuth app on Google Sheets API.
• Role required: admin

프로시저

1. Navigate to All > Process Automation > Flow Designer.
2. Click Connections.
3. In the Search all connections field, enter Google sheets.
4. On the GoogleSheets card, click View Details.
5. Click Configure, as shown in the image.
6. Fill the form.

   표 3. Configure Connection

   Field	Description
   Connection Name	Name of the connection. 주: The field is read-only.
   Connection URL	The URL used for connecting to Google Sheets APIs. This field is automatically set to https://sheets.googleapis.com/v4/spreadsheets
   Credential Name	Name of the credential. This field is automatically set to Google Sheets Spoke Credential.
   OAuth Entity Name	Name of the OAuth entity profile. This field is automatically set to Google Sheets Spoke OAuth.
   OAuth Client ID	Client ID of the Google Sheets application you registered in G Suite.
   OAuth Client Secret	Client Secret generated when you registered the application in Google API Console.
   OAuth Redirect URL	The redirect URL. The format of the URL is https://<your-instance>.service-now.com/oauth_redirect.do

7. Click Create and Get OAuth Token.