Google Workspace Load

Google Workspace Load

Certified

Load data from file into Google Sheets

Reads data from Kestra storage (CSV/JSON/ION/AVRO/PARQUET/ORC) and writes it to a sheet range. Supports append, overwrite, or update modes; header parsing optional.

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

Spreadsheet ID

Target spreadsheet to load data into

Avro schema

Optional schema string to read Avro payloads

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

CSV parsing options

Definitions
encodingstring
DefaultUTF-8

CSV file encoding

Character set used; default UTF-8

fieldDelimiterstring
Default,

CSV field delimiter

Single-character separator; default comma

quotestring

CSV quote character

skipLeadingRowsintegerstring

Skip leading rows

Number of initial rows to skip; default 0

Possible Values
IONCSVAVROPARQUETORCJSON

Input file format

Optional override; otherwise inferred from file extension

Source file URI

kestra:// URI of the file to load

Defaultfalse

Treat first row as header

When true, first row becomes column names; default false

DefaultUPDATE
Possible Values
UPDATEOVERWRITEAPPEND

How to write the data into the sheet

UPDATE (default): write values to the given range; does not clear extra old data outside the written area. OVERWRITE: clear the target range first, then write values. APPEND: append values as new rows after the last non-empty row in the given sheet/range.

Reference (ref) of the pluginDefaults to apply to this task.

DefaultSheet1

Target sheet or range

Sheet name or A1 range to write into; default Sheet1

Default120

The read timeout for the request (in seconds)

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

The GCP scopes to used

The GCP service account key

Default0

Columns written

Spreadsheet range written

Default0

Rows written

More Plugins in this Category

Clickhouse
Clickhouse

Tasks that connect to ClickHouse via JDBC to run queries and loads.

Data

5 tasks

2 blueprints

YouTube
YouTube

Tasks that interact with the YouTube Data API.

Business

4 tasks