---
sourceDocument: Brazil Workflow Data Fabric
sourceDocumentLink: https://www.servicenow.com/docs/r/integrate-applications

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil Workflow Data Fabric

ft:clusterId :

    - crint

bundleId :

    - crint

workflow :

    - Creator


---

# Set up the Google Sheet spoke

# Set up the Google Sheet spoke {#ariaid-title1}

Release version: Brazil  
Updated March 12, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read  
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.
{#setup-gsheets__ul_agy_qxd_rlb}

## 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](https://www.servicenow.com/docs/UyfSSzeL~s~RniIB_MuXDg#set-up-oauth-app-on-google-workspace "Set up an OAuth application on the Google Sheets API to enable authentication of requests from your ServiceNow instance.") 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 {#ariaid-title2}

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
{#set-up-oauth-app-on-google-workspace__ul_agy_qxd_rlb}

### 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.  
   {#set-up-oauth-app-on-google-workspace__substeps_ebc_4bw_5wb}
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 <kbd class="ph userinput">Google Sheets</kbd> 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.
   {#set-up-oauth-app-on-google-workspace__substeps_nrt_hdw_5wb}
4. Create the OAuth app and credentials.
   1. Select CREATE CREDENTIALS.  
   2. Fill the form.  
      {#set-up-oauth-app-on-google-workspace__table_rxt_zgw_5wb__entry__2}

      | Field | Description |
      |-|-|
      | Select an API\* | Name of the API for which you're creating the credentials. Note: Ensure that you select Google Sheets API. |
      | What data will you be accessing? \* | Type of data your ServiceNow will access through the APIs. Tip: Select User data. |
      [Table 1. Google Sheets API credentials]

      {#set-up-oauth-app-on-google-workspace__table_rxt_zgw_5wb}
   3. Click NEXT.
   4. Fill the form.  
      {#set-up-oauth-app-on-google-workspace__table_t1g_qhw_5wb__entry__3}

      | 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 |
      [Table 2. Google Sheets API credentials]

      {#set-up-oauth-app-on-google-workspace__table_t1g_qhw_5wb}
   5. Click SAVE AND CONTINUE.
   {#set-up-oauth-app-on-google-workspace__substeps_u5n_3gw_5wb}
5. **Optional:** 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 <kbd class="ph userinput">Google sheets API</kbd>, as shown in the image.  
   3. Select one or more scopes.
   4. Click UPDATE.
   5. Click SAVE AND CONTINUE.
   {#set-up-oauth-app-on-google-workspace__substeps_vqm_v3w_5wb}
6. Generate OAuth client ID.
   1. From the Application type\* list, select <kbd class="ph userinput">Web application</kbd>.
   2. In the Name\* field, enter a unique name of the OAuth client.
   {#set-up-oauth-app-on-google-workspace__substeps_sln_mlw_5wb}
7. Under the Authorised redirect URIs heading, click + ADD URI.
8. In the URI field, enter the redirect URI in the following format: <kbd class="ph userinput">https://instance.service-now.com/oauth_redirect.do</kbd>.
9. Click CREATE.  
   The OAuth details are generated in a JSON file.  
   Tip:  
   Click DOWNLOAD to download the JSON file for later reference.

10. Click DONE.  
    You've created the OAuth application on Google Workspace.
{#set-up-oauth-app-on-google-workspace__steps_qm3_gbw_5wb}

## Create Connection and Credential record for Google Sheets spoke {#ariaid-title3}

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](https://www.servicenow.com/docs/UyfSSzeL~s~RniIB_MuXDg#set-up-oauth-app-on-google-workspace "Set up an OAuth application on the Google Sheets API to enable authentication of requests from your ServiceNow instance.").
* Role required: admin
{#create-conn-cred-gsheets__ul_ckp_334_3mb}

### Procedure

1. Navigate to AllProcess AutomationFlow Designer.
2. Click Connections.
3. In the Search all connections field, enter <kbd class="ph userinput">Google sheets</kbd>.
4. On the GoogleSheets card, click View Details.
5. Click Configure, as shown in the image.
6. Fill the form.  
   {#create-conn-cred-gsheets__table_vyw_bk4_3mb__entry__2}

   | Field | Description |
   |-|-|
   | Connection Name | Name of the connection. Note: The field is read-only. |
   | Connection URL | The URL used for connecting to Google Sheets APIs. This field is automatically set to <kbd class="ph userinput">https://sheets.googleapis.com/v4/spreadsheets</kbd> |
   | Credential Name | Name of the credential. This field is automatically set to <kbd class="ph userinput">Google Sheets Spoke Credential</kbd>. |
   | OAuth Entity Name | Name of the OAuth entity profile. This field is automatically set to <kbd class="ph userinput">Google Sheets Spoke OAuth</kbd>. |
   | 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 <kbd class="ph userinput">https://&lt;your-instance&gt;.service-now.com/oauth_redirect.do</kbd> |
   [Table 3. Configure Connection]

   {#create-conn-cred-gsheets__table_vyw_bk4_3mb}
7. Click Create and Get OAuth Token.

*[\>]: and then