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 *Requiredstring
Spreadsheet ID
dateTimeRender 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
pluginDefaultsRef Non-dynamicstring
Reference (ref) of the pluginDefaults to apply to this task.
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
