Connections

Back Next

Google Sheets V2 connection properties

When you create a Google Sheets V2 connection, you must configure the connection properties.

The following table describes the Google Sheets V2 connection properties:

Property	Description
Runtime Environment	Name of the runtime environment where you want to run the tasks.
Client ID	Required. The client ID from Google Developer Console.
Client Secret	Required. The client secret from Google Developer Console.
Refresh Token	Required. The refresh token received after you exchange authorization code for Google Sheets.
Spreadsheet ID	ID of the spreadsheet in Google Sheets.
Header Present	Indicates that the sheet contains a header. If you select this option and the sheet does not contain a header, the first row is treated as the header.