Google Workspace Load
CertifiedLoad data from file into Google Sheets
Google Workspace Load
Load data from file into Google Sheets
Reads data from Kestra storage (CSV/JSON/ION/AVRO/PARQUET/ORC) and writes it to a sheet range. Supports append, overwrite, or update modes; header parsing optional.
type: io.kestra.plugin.googleworkspace.sheets.LoadExamples
Load data into a Google Workspace spreadsheet from an input file
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 *string
Spreadsheet ID
Target spreadsheet to load data into
assets
Assets this task consumes as inputs or produces as outputs, for lineage tracking and the asset graph (Enterprise Edition). A flow declaring this property on a task is rejected in the open-source edition.
io.kestra.core.models.assets.AssetsDeclaration
IGNOREFAILWARNAsset failure behavior
Behavior applied to the task state when a declared asset fails to render, emit, or be persisted (e.g. a lock conflict): FAIL escalates it to FAILED, WARN (default) warns it if it would otherwise succeed, IGNORE leaves the state untouched.
Whether to auto-register assets referenced dynamically at runtime that are not statically declared in inputs or outputs.
The assets consumed as inputs.
io.kestra.core.models.assets.AssetIdentifier
1The assets produced as outputs.
io.kestra.plugin.ee.assets.Dataset
1150{}1150io.kestra.plugin.ee.assets.File
1150{}1150io.kestra.plugin.ee.assets.Table
1150{}1150io.kestra.plugin.ee.assets.VM
1150{}1150io.kestra.core.models.assets.External
1150{}1150io.kestra.core.models.assets.Custom
11501Custom asset type
{}1150avroSchema string
Avro schema
Optional schema string to read Avro payloads
csvOptions
{
"fieldDelimiter": ",",
"encoding": "UTF-8"
}CSV parsing options
io.kestra.plugin.googleworkspace.sheets.AbstractLoad-CsvOptions
UTF-8CSV file encoding
Character set used; default UTF-8
,CSV field delimiter
Single-character separator; default comma
CSV quote character
Skip leading rows
Number of initial rows to skip; default 0
format string
IONCSVAVROPARQUETORCJSONInput file format
Optional override; otherwise inferred from file extension
from string
Source file URI
kestra:// URI of the file to load
header booleanstring
falseTreat first row as header
When true, first row becomes column names; default false
insertType string
UPDATEUPDATEOVERWRITEAPPENDHow to write the data into the sheet
UPDATE (default): write values to the given range; does not clear extra old data outside the written area. OVERWRITE: clear the target range first, then write values. APPEND: append values as new rows after the last non-empty row in the given sheet/range.
range string
Sheet1Target sheet or range
Sheet name or A1 range to write into; default Sheet1
readTimeout integerstring
120The read timeout for the request (in seconds)
scopes array
["https://www.googleapis.com/auth/spreadsheets"]The GCP scopes to used
serviceAccount string
The GCP service account key
Outputs
columns integer
0Columns written
range string
Spreadsheet range written
rows integer
0Rows written
