Load data from a local file to a Google Sheet.
type: "io.kestra.plugin.googleworkspace.sheets.load"Load data into a Google Workspace spreadsheet from an input file
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: ";"
YESThe spreadsheet unique id
YESSchema for avro objects (Optional)
If provided, the task will read avro objects using this schema.
NO{
"fieldDelimiter": ",",
"encoding": "UTF-8"
}CSV parsing options (Optional)
YESIONCSVAVROPARQUETORCJSONFormat of the input file
If not provided, the task will programmatically try to find the correct format based on the extension.
YESThe URI of the Kestra's internal storage file
NOfalseSpecifies if the first line should be the header (default: false)
YESUPDATEUPDATEOVERWRITEAPPENDHow 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.
YESSheet1The sheet name or range to select
NO120The read timeout for the request (in seconds)
YES["https://www.googleapis.com/auth/spreadsheets"]The GCP scopes to used
YESThe GCP service account key
0The number of columns loaded
The spreadsheet ID or range
0The number of rows loaded
YESUTF-8The file encoding of CSV file
YES,The separator for fields in a CSV file
YESThe quote character in a CSV file
NOThe 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.