Google Sheets

Supports:

✅ Models
✅ Model sync destination
✅ Bulk sync source

Connection

Configuration

Name	Type	Description	Required
`client_id`	`string`		`false`
`client_secret`	`string`		`false`
`connect_mode`	`string`	Default: browser Accepted values: `browser`, `jwt`	`false`
`has_headers`	`boolean`	Columns have headers	`false`
`oauth_refresh_token`	`string`		`false`
`service_account`	`string`	Service account key (required if `connect_mode` is “jwt”)	`false`
`spreadsheet_id`	`object`	Spreadsheet	`true`

Example

{
  "name": "Google Sheets connection",
  "type": "gsheets",
  "configuration": {
    "client_id": "eb669428-1854-4cb1-a560-403e05b8acbf",
    "client_secret": "ay8d5hdepz62px8lqeoakuea2ccl4rxm13i6tbyorxhu1i20kc8ruvksmzxq",
    "connect_mode": "",
    "has_headers": false,
    "oauth_refresh_token": "dasfdasz62px8lqeoakuea2ccl4rxm13i6tbyorxhu1i20kc8ruvksmzxq",
    "service_account": "",
    "spreadsheet_id": {
        "label": "",
        "value": ""
    }
  }
}

Read-only properties

Name	Type	Description	Required
`user_email`	`string`	Connected user’s email	`false`

Model Sync

Source

Configuration

Name	Type	Description	Required
`selected_sheet`	`object`	Sheet	`true`

Example

{
  ...
  "configuration": {
    "selected_sheet": {}
  }
}

Target

Google Sheets connections may be used as the destination in a model sync.

Bulk Sync

Source

Google Sheets connections may be used as a bulk sync source. No additional configuration options are required.