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: ";"
The spreadsheet unique id
Schema for avro objects (Optional)
If provided, the task will read avro objects using this schema.
{
"fieldDelimiter": ",",
"encoding": "UTF-8"
}CSV parsing options (Optional)
IONCSVAVROPARQUETORCJSONFormat 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
falseSpecifies if the first line should be the header (default: false)
UPDATEUPDATEOVERWRITEAPPENDHow 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.
Sheet1The sheet name or range to select
120The read timeout for the request (in seconds)
["https://www.googleapis.com/auth/spreadsheets"]The GCP scopes to used
The GCP service account key
0The number of columns loaded
The spreadsheet ID or range
0The number of rows loaded
UTF-8The file encoding of CSV file
,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.