Skip to end of metadata
Go to start of metadata

Google Sheets Connector

Overview

The Jitterbit Harmony Google Sheets Connector is accessed from the Connectivity tab of the design component palette:

Connectivity tab

This connector is used to first configure a Google Sheets connection, establishing access to an account on the Google Sheets server, and then used to configure one or more Google Sheets activities associated with that connection as either a source or target within an operation:

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

The Google Sheets connector uses the Google Sheets API v4. Refer to the API documentation for information on the schema fields and practices for manipulating Google Sheets.

The Google Sheets connector requires the use of an agent version 10.1 or higher.

Together, a specific Google Sheets connection and its activities are referred to as a Google Sheets endpoint. Once a connection is configured, activities associated with the endpoint are available from the Endpoints filter:

Connectivity tab

Google Sheets Registration

As the connection will be an application that interfaces with Google Sheets, you will need a Project ID, Client Email, and Private Key to access the Google Sheets API. To obtain these, you need to create a service account from a Google account. See Google Registration for details.

NOTE: The Google Drive folder with the Google Sheets you wish to access must be shared with the Google service account email that is used to create the connection. All spreadsheets accessed by the connection will be in that particular folder. Sharing at least one folder is required. Google Sheets outside the shared folder cannot be accessed.

  • No labels