Google Workspace ReadRange
CertifiedRead a range from a spreadsheet
Google Workspace ReadRange
Read a range from a spreadsheet
Reads a specific A1 range with render options. Can return data or store to kestra://; metrics report row count.
type: io.kestra.plugin.googleworkspace.sheets.ReadRangeExamples
id: googleworkspace_sheets_readrange
namespace: company.team
tasks:
- id: read_range
type: io.kestra.plugin.googleworkspace.sheets.ReadRange
spreadsheetId: "1Dkd3W0OQo-wxz1rrORLP7YGSj6EBLEg74fiTdbJUIQE"
range: "Second One!A1:I"
store: true
valueRender: FORMATTED_VALUE
Properties
spreadsheetId *string
Spreadsheet ID
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
{}1150dateTimeRender string
FORMATTED_STRINGSERIAL_NUMBERFORMATTED_STRINGDate/time render option
SERIAL_NUMBER or FORMATTED_STRING (default); ignored if valueRender=FORMATTED_VALUE
fetch booleanstring
falseFetch results
If true, data is returned in output; otherwise written to storage
header booleanstring
trueTreat first row as header
When true, maps rows to objects using first row keys; default true
range string
Range
A1 notation range (e.g., Sheet1!A1: D10); required
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
store booleanstring
trueStore results
If true, writes ION file to storage; default true
valueRender string
UNFORMATTED_VALUEFORMATTED_VALUEUNFORMATTED_VALUEFORMULAValue render option
FORMATTED_VALUE, UNFORMATTED_VALUE (default), or FORMULA
Outputs
rows array
Fetched rows
Only when fetch=true
size integer
0Rows fetched
uri string
uriStored result URI
Only when store=true
Metrics
rows counter
countNumber of rows fetched across all sheets
