Skip to Content

Google Sheets connection guide for Jitterbit App Builder

Overview

This guide describes the system requirements and instructions for connecting App Builder to a Google Sheets database server.

This connection type supports bidirectional access to data, including App Builder CRUD business rules.

System requirements

Database server

Google Sheets Database Server

Client web browser

  • Chrome: 84+

  • Firefox: 73+

  • Safari: 13.0.1+

  • Edge: 84+

Connection instructions

Configure Google Sheets from Google Console

  1. Navigate to Google Console: https://console.cloud.google.com/apis/dashboard

  2. Enable Google Sheets API by clicking on "Enable APIs and Services" and searching Google Sheets

  3. From the dashboard, setup OAuth under "Credentials"

    attachment

  4. Click "Create Credentials" at the top of the screen and choose "OAuth client ID"

  5. Choose Application type "Web Application" and give your application a name

  6. Add an Authorized redirect URI back to the security provider created next

  7. Click "Create" and make note of the Client ID and Client Secret

    Graphical user interface, text, application, email Description automatically generated

    Note

    The redirect URI in this example uses the Security Provider named GoogleOAuth.

Configure Google Sheets in App Builder

  1. Setup Security Provider in App Builder by navigating to the IDE > Security Providers

  2. Add a "Data Source Authentication" Security Provider

  3. Provide the following details:

    • Name: Matching string after "signin-" for redirect URI

    • Type: OAuth

    • Authentication Type: OAuth

    • OAuth Client Authentication: Basic

    • OAuth Resource Authentication: Bearer

    • Token Owner: Client

    • Redirect on Challenge: True

    • Endpoints:

      • Authorization Endpoint: https://accounts.google.com/o/oauth2/auth

      • Token Endpoint: https://oauth2.googleapis.com/token

    • Credentials:

      • Type: Client

      • User Name: Client ID from Google Console

      • Password: Client Secret from Google Console

    • Properties:

    • Scopes: https://www.googleapis.com/auth/spreadsheets

      • Visit Google's documentation for further guidance on Scopes. Multiple scopes can be added, separate by a space.

    attachment

  4. Create Google Sheets Data Server from IDE > Data Servers > + Server

    • Server Name: Provide a name

    • Type: Google Sheets

    • Filename: UUID from Google Sheet URL

      • Example: https://docs.google.com/spreadsheets/d/Spreadsheet_UUID_Here

    • Security Provider: Choose Security Provider created in previous step

  5. Click Save

Test the connection

Click the Test Connection button from Testing.