Load

Load data from a local file to a Google Sheet.

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

Load data into a Google Workspace spreadsheet from an input file

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: ";"

The spreadsheet unique id.

Schema for avro objects (Optional).

If provided, the task will read avro objects using this schema.

Default

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

Csv parsing options (Optional).

Possible Values

IONCSVAVROPARQUETORCJSON

Format of the input file.

If not provided, the task will programmatically try to find the correct format based on the extension.

The URI of the Kestra's internal storage file.

Default false

Specifies if the first line should be the header (default: false).

Default Sheet1

The sheet name or range to select.

Default 120

The read timeout for the request (in seconds)

SubType string

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

The GCP scopes to used

The GCP service account key

Default 0

The number of columns loaded

The spreadsheet ID or range

Default 0

The number of rows loaded

Default UTF-8

The file encoding of CSV file.

Default ,

The separator for fields in a CSV file.

The quote character in a CSV file.

The number of rows at the top of a CSV file that will be skipped when reading the data.

The default value is 0. This property is useful if you have header rows in the file that should be skipped.

​Load

Load