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.

Before you begin

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

About this task

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.

Before you begin

• 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 jane-admin@mydomain.com.

  Note: You can only register one email address per domain in Google Workspace.

• Role required: admin

Procedure

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.

1. Select the project that you created.

1. 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.

1. Create the OAuth app and credentials.

   1. Select CREATE CREDENTIALS.

2.  Fill the form.

3.  Click **NEXT**.

4.  Fill the form.

    |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**.

1. 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**.

1. 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.

2. Under the Authorised redirect URIs heading, click + ADD URI.

3. In the URI field, enter the redirect URI in the following format: https://instance.service-now.com/oauth_redirect.do.

4. Click CREATE.

   The OAuth details are generated in a JSON file.

   Tip: Click DOWNLOAD to download the JSON file for later reference.

1. 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.

Before you begin

• 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

Procedure

1. Navigate to All > Process Automation > Flow Designer.

2. Click Connections.

3. In the Search all connections field, enter Google sheets.

1. On the GoogleSheets card, click View Details.

2. Click Configure, as shown in the image.

1. Fill the form.