Preface
Introduction to Google Sheets Connector
- Google Sheets Connector assets
- Administration of Google Sheets Connector
  - Generating OAuth 2.0 access tokens
Google Sheets connections
- Google Sheets connection properties
Synchronization tasks with Google Sheets Connector
- Google Sheets targets in the synchronization tasks
- Rules and guidelines for synchronization tasks
Mappings and mapping tasks with Google Sheets Connector
Appendix A: Data type reference
- Google Sheets and transformation data types

Google Sheets Connector

Back Next

Google Sheets connection properties

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

The following table describes the Google Sheets 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
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 For Sheet	Required. The Refresh Token received after exchanging authorization code for Google Sheets.
Refresh Token For Drive	Optional. The Refresh Token received after exchanging authorization code for Google Drive. This option is required when you enter the spreadsheet name in the Spreadsheet Name field.
Spreadsheet Name	Name of the spreadsheet in Google Sheets.
Spreadsheet Id	ID of the spreadsheet in Google Sheets.
Initial Column Range	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 Initial Column Range value as Sheet1!C5.
Final Column Range	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 Final Column Range value as Sheet1!G20.
Header Present	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.
Create New Spreadsheet	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 Spreadsheet Name field. Once you test the connection, disable this option. Otherwise, the Google Sheets Connector will create a new spreadsheet with the same name every time.

Rename Saved Search

Table of Contents

Google Sheets Connector

Google Sheets Connector

Google Sheets connection properties

Google Sheets connection properties