Load data from a local file to a Google Workspace spreadsheet

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

Dynamic YES

The spreadsheet unique id.

Dynamic YES

Schema for avro objects (Optional).

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

Dynamic NO

Default

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

Csv parsing options (Optional).

Dynamic YES

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.

Dynamic YES

The URI of the Kestra's internal storage file.

Dynamic YES

Default false

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

Dynamic YES

Default Sheet1

The sheet name or range to select.

Dynamic YES

Default 120

The read timeout for the request (in seconds)

SubType string

Dynamic YES

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

The GCP scopes to used

Dynamic YES

The GCP service account key

Default 0

The number of columns loaded

The spreadsheet ID or range

Default 0

The number of rows loaded

Dynamic YES

Default UTF-8

The file encoding of CSV file.

Dynamic YES

Default ,

The separator for fields in a CSV file.

Dynamic YES

The quote character in a CSV file.

Dynamic YES

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