Load

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

Examples

yaml
   id: googleworkspace_sheets_load
namespace: company.team

inputs:
  - id: file
    type: FILE
  - id: serviceAccount
    type: STRING

tasks:
  - id: load_data
    type: io.kestra.plugin.googleworkspace.sheets.Load
    from: "{{ inputs.file }}"
    spreadsheetId: xxxxxxxxxxxxxxxxx
    range: Sheet2
    serviceAccount: "{{ inputs.serviceAccount }}"
    csvOptions:
      fieldDelimiter: ";"

Properties

spreadsheetId *string

avroSchema string

csvOptions

Default

{
  "fieldDelimiter": ",",
  "encoding": "UTF-8"
}

Definitions

io.kestra.plugin.googleworkspace.sheets.AbstractLoad-CsvOptions

encodingstring

DefaultUTF-8

fieldDelimiterstring

Default,

quotestring

skipLeadingRowsintegerstring

format string

Possible Values

IONCSVAVROPARQUETORCJSON

from string

header booleanstring

Defaultfalse

insertType string

DefaultUPDATE

Possible Values

UPDATEOVERWRITEAPPEND

range string

DefaultSheet1

readTimeout integerstring

Default120

scopes array

SubTypestring

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

serviceAccount string

Outputs

columns integer

Default0

range string

rows integer

Default0

Core Plugins and tasks

Tasks that provide Kestra's built-in orchestration, I/O, and observability capabilities.

CoreStorageScript

Zulip

Tasks that send messages to Zulip streams or users.

Alerting

Zenduty

Tasks that create incidents in Zenduty.

Alerting

Load

More Plugins in this Category

Core Plugins and tasks

Zulip

Zenduty

2.0.1