Read all sheets from a google Sheets
yaml
type: "io.kestra.plugin.googleworkspace.sheets.Read"yaml
id: googleworkspace_sheets_read
namespace: company.team
tasks:
- id: read
type: io.kestra.plugin.googleworkspace.sheets.Read
spreadsheetId: "1Dkd3W0OQo-wxz1rrORLP7YGSj6EBLEg74fiTdbJUIQE"
store: true
valueRender: FORMATTED_VALUE
Dynamic
YESThe spreadsheet unique id
Dynamic
YES Default
UNFORMATTED_VALUE Possible Values
FORMATTED_VALUEUNFORMATTED_VALUEFORMULADetermines how values should be rendered in the output.
More details here
Dynamic
YES Default
FORMATTED_STRING Possible Values
SERIAL_NUMBERFORMATTED_STRINGHow dates, times, and durations should be represented in the output.
his is ignored if valueRender is FORMATTED_VALUE.
More details here
Dynamic
YES Default
false Dynamic
YES Default
true Dynamic
YES Default
120 SubType string
Dynamic
YES Default
["https://www.googleapis.com/auth/spreadsheets"]The GCP scopes to used
SubType string
Dynamic
YESThe sheet title to be included
If not provided all the sheets will be included.
Dynamic
YESThe GCP service account key
Dynamic
YES Default
true SubType array
List containing the fetched data
Only populated if 'fetch' parameter is set to true. The key is the name of the sheet
Default
0The size of the rows fetch
SubType string
The uri of store result
The keyOnly populated if 'store' is set to true. The key is the name of the sheet