yaml
type: "io.kestra.plugin.googleworkspace.sheets.load"
Examples
yaml
id: googleworkspace_sheets_load
namespace: company.team
inputs:
- id: file
type: FILE
- id: serviceAccount
type: STRING
tasks:
- id: load_data
type: io.kestra.plugin.googleworkspace.sheets.Load
from: "{{ inputs.file }}"
spreadsheetId: xxxxxxxxxxxxxxxxx
range: Sheet2
serviceAccount: "{{ inputs.serviceAccount }}"
csvOptions:
fieldDelimiter: ";"
Properties
spreadsheetId *Requiredstring
avroSchema string
csvOptions Non-dynamicAbstractLoad-CsvOptions
Default
{
"fieldDelimiter": ",",
"encoding": "UTF-8"
}
format string
Possible Values
ION
CSV
AVRO
PARQUET
ORC
JSON
from string
header booleanstring
Default
false
insertType string
Default
UPDATE
Possible Values
UPDATE
OVERWRITE
APPEND
range string
Default
Sheet1
readTimeout integerstring
Default
120
scopes array
SubType string
Default
["https://www.googleapis.com/auth/spreadsheets"]
serviceAccount string
Outputs
columns integer
Default
0
range string
rows integer
Default
0
Definitions
io.kestra.plugin.googleworkspace.sheets.AbstractLoad-CsvOptions
encoding string
Default
UTF-8
fieldDelimiter string
Default
,