Skip to Content

Jitterbit Harmony Google Sheets Connection

Introduction

A Google Sheets connection is configured via the Google Sheets connector to establish access to an account on the Google Sheets server. Once a connection is established, you can configure one or more Google Sheets activities associated with that connection to use as a source or target within an operation.

Create or Edit a Google Sheets Connection

A new Google Sheets connection is created using the Google Sheets connector from one of these locations:

An existing Google Sheets connection can be edited from these locations:

Configure a Google Sheets Connection

Configuration of a Google Sheets connection includes these fields:

Connections tab

Tip

Fields with a variable icon Variable icon support using global variables, project variables, and Jitterbit variables. Begin typing an open square bracket [ into the field or click the variable icon to display existing variables to choose from.

  • Connection Name: Enter a name to use to identify the Google Sheets connection. The name must be unique for each Google Sheets connection and must not contain forward slashes (/) or colons (:).

  • Project ID: Enter the Google Sheets Service Account Project ID. See Google Sheets Registration.

  • Client Email: Enter the Google Sheets Service Account Client Email. See Google Sheets Registration.

  • Private Key String: Enter the Google Sheets Service Account Private Key String. See Google Sheets Registration.

  • Key Algorithm: The encryption algorithm of the private key string. Currently, only RSA is supported.

  • Test: Click this button to verify the connection. The server will check only that the specified user can make a connection.

  • Save Changes: Click this button to save and close the connection configuration.

  • Discard Changes: After making changes to a new or existing configuration, click Discard Changes to close the configuration without saving. A message will ask you to confirm that you want to discard changes.

  • Delete: After opening an existing connection configuration, click Delete to permanently delete the connection from the project and close the configuration (see Component Dependencies, Deletion, and Removal). A message will ask you to confirm that you want to delete the connection.

Next Steps

After a Google Sheets connection has been created, menu actions for that connection are accessible from the project pane's Components tab. See Connection Actions Menu for details.

After configuring a Google Sheets connection, you can configure one or more Google Sheets activities associated with that connection to use as a source or target within an operation. For more information, see these pages:

  • Get Sheets: Retrieves a spreadsheet from a Google Sheets connection and is used as a source in an operation.

  • Create Sheets: Creates a spreadsheet in a Google Sheets connection and is used as a target in an operation.

  • Update Sheets: Updates a spreadsheet in a Google Sheets connection and is used as a target in an operation.