Set up the Google Sheet spoke

  • Versão de lançamento: Australia
  • Atualizado 12 de mar. de 2026
  • 3 min. de leitura

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

    Antes de Iniciar

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

    Por Que e Quando Desempenhar Esta Tarefa

    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.

    Antes de Iniciar

    • 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.
      Nota:
      You can only register one email address per domain in Google Workspace.
    • Role required: admin

    Procedimento

    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.

        Project creation button on Google Workspace.

      3. Select NEW PROJECT.

        Click New Project button on Google Workspace.

      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.

        Select the project.

    2. Select the project that you created.

      Project selection on Google Sheets API.

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

        Google Sheets API Enable APIs and Services button.

      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.
        Click Credentials button for Google Sheets API.
      2. Fill the form.
        Tabela 1. Google Sheets API credentials
        Field Description
        Select an API* Name of the API for which you're creating the credentials.
        Nota:
        Ensure that you select Google Sheets API.
        What data will you be accessing? * Type of data your ServiceNow will access through the APIs.
        Dica:
        Select User data.
      3. Click NEXT.
      4. Fill the form.
        Tabela 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. Opcional: 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.
        Search Google Sheets in the scopes.
      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.
      Dica:
      Click DOWNLOAD to download the JSON file for later reference.

      Download button to download OAuth credentials file.

    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.

    Antes de Iniciar

    • 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

    Procedimento

    1. Navigate to All > Process Automation > Flow Designer.
    2. Click Connections.
    3. In the Search all connections field, enter Google sheets.Search Google Sheets alias on Flow Designer alias.
    4. On the GoogleSheets card, click View Details.
    5. Click Configure, as shown in the image.Configure button on Google Sheets alias.
    6. Fill the form.
      Tabela 3. Configure Connection
      Field Description
      Connection Name Name of the connection.
      Nota:
      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.