Connections > Google Sheets V2 connection properties
  

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.