Connection

Description

Configuration

NAME	TYPE	DESCRIPTION	REQUIRED	READONLY
user_email	string		false	true
oauth_refresh_token	string		false	false
service_account	string		false	false
spreadsheet_id	object		true	false
connect_mode	string	Either browser (default) or code; if code is specified, the response will include an auth_code for the user to enter when completing authorization.	false	false
client_id	string		false	false
client_secret	string		false	false

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

NAME	TYPE	DESCRIPTION	REQUIRED	READONLY
selected_sheet	object		false	false

Example

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

Target

N/A

Bulk Sync

Source

N/A

Destination

N/A

Getting started

Configuring your connections

Code examples

Google Sheets

Connection

Description

Configuration

Example

Model Sync

Source

Configuration

Example

Target

Bulk Sync

Source

Destination

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	}