Google Sheets Connector

Google Sheets Connector

Google Sheets connection properties

Google Sheets connection properties

When you create a Google Sheets connection, you must configure the connection properties.
The following table describes the Google Sheets connection properties:
Property
Description
Runtime Environment
Name of the runtime environment where you want to run the tasks.
ClientId
Required. The Client ID from Google Developer Console.
ClientSecret
Required. The Client Secret from Google Developer Console.
RefreshTokenForSheet
Required. The Refresh Token received after exchanging authorization code for Google Sheets.
RefreshTokenForDrive
Optional. The Refresh Token received after exchanging authorization code for Google Drive. This option is required when you enter the spreadsheet name in the
SpreadSheetName
field.
SpreadSheetName
Name of the spreadsheet in Google Sheets.
SpreadSheetId
ID of the spreadsheet in Google Sheets.
InitialColumnRange
Specifies the first column name from a data range in a Google Sheets spreadsheet from where you want to start reading the data.
For example, specify the InitialColumnRange value as Sheet1!C5.
FinalColumnRange
Specifies the last column name from a data range in a Google Sheets spreadsheet from where you want to stop reading the data.
For example, specify the FinalColumnRange value as Sheet1!G20.
HeaderPresent
Select this option to indicate 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.
CreateNewSpreadsheet
Select this option to create a new spreadsheet in Google Sheets.
The Google Sheets Connector creates an empty spreadsheet with the name that you specified in the
SpreadSheetName
field.
Once you test the connection, disable this option. Otherwise, the Google Sheets Connector will create a new spreadsheet with the same name everytime

0 COMMENTS

We’d like to hear from you!