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 *string

dateTimeRender string

Default FORMATTED_STRING

Possible Values

SERIAL_NUMBERFORMATTED_STRING

fetch booleanstring

Default false

header booleanstring

Default true

range string

readTimeout integerstring

Default 120

scopes array

SubType string

Default ["https://www.googleapis.com/auth/spreadsheets"]

serviceAccount string

store booleanstring

Default true

valueRender string

Default UNFORMATTED_VALUE

Possible Values

FORMATTED_VALUEUNFORMATTED_VALUEFORMULA

Outputs

rows array

size integer

Default 0

uri string

Format uri

​Read​Range

ReadRange