Configuring your connectionsConnection configurations

Google Sheets

Connection

Description

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
user_emailstringfalsetrue
oauth_refresh_tokenstringfalsefalse
service_accountstringfalsefalse
spreadsheet_idobjecttruefalse
connect_modestringEither browser (default) or code; if code is specified, the response will include an auth_code for the user to enter when completing authorization.falsefalse
client_idstringfalsefalse
client_secretstringfalsefalse

Example

1{
2 "name": "gsheets connection",
3 "type": "gsheets",
4 "configuration": {
5 "client_id": "eb669428-1854-4cb1-a560-403e05b8acbf",
6 "client_secret": "ay8d5hdepz62px8lqeoakuea2ccl4rxm13i6tbyorxhu1i20kc8ruvksmzxq",
7 "connect_mode": "clientcredentials",
8 "oauth_refresh_token": "dasfdasz62px8lqeoakuea2ccl4rxm13i6tbyorxhu1i20kc8ruvksmzxq",
9 "service_account": "",
10 "spreadsheet_id": {
11 "label": "",
12 "value": ""
13 }
14 }
15}

Model Sync

Source

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
selected_sheetobjectSheetfalsefalse

Example

1{
2 ...
3 "configuration": {
4 "selected_sheet": {}
5 }
6}

Target

N/A

Bulk Sync

Source

N/A

Destination

N/A