Skip to main content

Config for googlesheets

Jobs that use the googlesheets adaptor may require authentication. A "credential" for the googlesheets adaptor will follow the schema below. When using the CLI, you can set up your own state.configuration by using the sample below.

Sample Configuration

Paste this into the configuration key of your state.json file and modify the values to run jobs locally.

{
"access_token": "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6IjlGWERwYmZNRlQyU3ZRdVhoODQ2WVR3RUlCdyIsI"
}

Full Schema

The full configuration schema describes each attribute of the credential and notes those that are required.

{
"$schema": "http://json-schema.org/draft-07/schema#",
"$comment": "OAuth2",
"properties": {
"access_token": {
"title": "Access Token",
"type": "string",
"description": "Your Google Sheets access token",
"writeOnly": true,
"minLength": 1,
"examples": [
"eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6IjlGWERwYmZNRlQyU3ZRdVhoODQ2WVR3RUlCdyIsI"
]
}
},
"type": "object",
"additionalProperties": true,
"required": [
"access_token"
]
}