Read

yaml
type: "io.kestra.plugin.googleworkspace.sheets.read"

Examples

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

Properties

spreadsheetId *string

dateTimeRender string

Default FORMATTED_STRING

Possible Values

SERIAL_NUMBERFORMATTED_STRING

fetch booleanstring

Default false

header booleanstring

Default true

readTimeout integerstring

Default 120

scopes array

SubType string

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

selectedSheetsTitle array

SubType string

serviceAccount string

store booleanstring

Default true

valueRender string

Default UNFORMATTED_VALUE

Possible Values

FORMATTED_VALUEUNFORMATTED_VALUEFORMULA

Outputs

rows object

SubType array

size integer

Default 0

uris object

SubType string

​Read

Read