ReadRange
Read a range from a Google Sheet.
type: "io.kestra.plugin.googleworkspace.sheets.ReadRange"
Examples
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
The spreadsheet unique id
dateTimeRender string
FORMATTED_STRING
SERIAL_NUMBER
FORMATTED_STRING
How dates, times, and durations should be represented in the output.
his is ignored if valueRender is FORMATTED_VALUE
.
More details here
fetch booleanstring
false
Whether to Fetch the data from the query result to the task output
header booleanstring
true
Specifies if the first line should be the header (default: false)
range string
The range to select
readTimeout integerstring
120
The 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
true
Whether to store the data from the query result into an ion serialized data file
valueRender string
UNFORMATTED_VALUE
FORMATTED_VALUE
UNFORMATTED_VALUE
FORMULA
Determines how values should be rendered in the output.
More details here
Outputs
rows array
List containing the fetched data
Only populated if 'fetch' parameter is set to true.
size integer
0
The size of the rows fetch
uri string
uri
The uri of store result
Only populated if 'store' is set to true.