Skip to main content
Feedback

Google Sheets connector

With the Google Sheets connector, you can create, delete, get, query, and update objects in Google Sheets.

Google Sheets is a web-based application that enables you to create, update, and modify spreadsheets and share data live online. Independent from the Google G Suite connector, this connector uses OAuth 2.0 for authentication and retrieves information in JSON format.

note

This is an open source connector and you can access the code in the Google Sheets connector repository.

Connector configuration

To configure a connector to communicate with Google Sheets, set up these components:

  • Google Sheets connection

  • Google Sheets operation

Supported objects

The Google Sheets operations supports the following objects:

  • Spreadsheets

  • Sheets

  • RecordData

Prerequisites

The Google Sheets connector requires the following:

  • A Google Client ID
  • The Client Secret for the account

This table lists additional prerequisite data that you might need to configure connector operations for the supported objects:

KeySpreadsheetsSheetsRecordDataWhere to find
Spreadsheet ID✅✅✅The value in the spreadsheet URL between /d/ and /edit.
Spreadsheet Title✅--The name of the sheet or spreadsheet.
Sheet Title-✅✅The label of the active sheet.
Index-✅-The sheet index, indicating the first and last columns (A:ZZZ), is the number Google assigns to the URL following gid=. For example, in the https://docs.google.com/spreadsheets/d/1z5jyhZtowx189HXqCDX1x2ApQT3-OTqIZ/edit#gid=1472184083, index is 1472184083.
Dynamically-generated field values--✅-

Tracked properties

This connector has no predefined tracked properties. See the topic Adding tracked fields to a connector operation to learn how to add a custom tracked field.

On this Page