Connections > Google Sheets V2 connection properties
  

Google Sheets V2 connection properties

When you create a Google Sheets V2 connection, configure the connection properties.
The following table describes the Google Sheets V2 connection properties:
Property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Description
Description of the connection. Maximum length is 4000 characters.
Type
Google Sheets V2
Runtime Environment
Name of the runtime environment where you want to run 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.