Skip to end of metadata
Go to start of metadata

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.

Creating or Editing a Google Sheets Connection

From the design canvas, open the Connectivity tab of the design component palette:

Connectivity tab

To configure a new Google Sheets connection, within the Connectors filter, click the Google Sheets connector block:

Connectivity tab

To configure an existing Google Sheets connection, within the Endpoints filter, double-click the Google Sheets connection block:

Connectivity tab

This will open a configuration screen for the Google Sheets connection, covered next.

Configuring a Google Sheets Connection

Configuration of a Google Sheets connection includes these fields:

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

  • Endpoint 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 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.

On This Page

Last updated:  Dec 20, 2019

  • No labels