ReadRange
ReadRange
yaml
type: "io.kestra.plugin.googleworkspace.sheets.ReadRange"Examples
yaml
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 *Requiredstring
dateTimeRender string
Default
FORMATTED_STRINGPossible Values
SERIAL_NUMBERFORMATTED_STRINGfetch booleanstring
Default
falseheader booleanstring
Default
truerange string
readTimeout integerstring
Default
120scopes array
SubTypestring
Default
["https://www.googleapis.com/auth/spreadsheets"]serviceAccount string
store booleanstring
Default
truevalueRender string
Default
UNFORMATTED_VALUEPossible Values
FORMATTED_VALUEUNFORMATTED_VALUEFORMULAOutputs
rows array
size integer
Default
0uri string
Format
uriMetrics
rows counter
Unit
count