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:
To configure a new Google Sheets connection, within the Connectors filter, click the Google Sheets connector block:
To configure an existing Google Sheets connection, within the Endpoints filter, double-click the Google Sheets connection block:
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:
TIP: Fields with a 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.
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.
Last updated: Dec 20, 2019
- No labels