Google Workspace CreateSpreadsheet

Google Workspace CreateSpreadsheet

Certified

Create a Google Spreadsheet

Creates a new spreadsheet using a service account; returns its ID and URL

yaml
type: io.kestra.plugin.googleworkspace.sheets.CreateSpreadsheet

Create a spreadsheet in Google Workspace

yaml
         id: googleworkspace_sheets_create
         namespace: company.team

         inputs:
           - id: serviceAccount
             type: STRING

         tasks:
           - id: create_spreadsheet
             type: io.kestra.plugin.googleworkspace.sheets.CreateSpreadsheet
             serviceAccount: "{{ inputs.serviceAccount }}"
Properties

Spreadsheet title

Title to assign to the new spreadsheet

Assets this task consumes as inputs or produces as outputs, for lineage tracking and the asset graph (Enterprise Edition). A flow declaring this property on a task is rejected in the open-source edition.

Definitions
assetFailureBehaviorstring
Possible Values
IGNOREFAILWARN

Asset failure behavior

Behavior applied to the task state when a declared asset fails to render, emit, or be persisted (e.g. a lock conflict): FAIL escalates it to FAILED, WARN (default) warns it if it would otherwise succeed, IGNORE leaves the state untouched.

enableAutobooleanstring

Whether to auto-register assets referenced dynamically at runtime that are not statically declared in inputs or outputs.

inputsarray

The assets consumed as inputs.

id*string
Min length1
typestring
outputs

The assets produced as outputs.

id*string
Min length1
Max length150
type*object
descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150
id*string
Min length1
Max length150
type*object
descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150
id*string
Min length1
Max length150
type*object
descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150
id*string
Min length1
Max length150
type*object
descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150
id*string
Min length1
Max length150
type*object
descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150
id*string
Min length1
Max length150
type*string
Min length1

Custom asset type

descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150
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

Spreadsheet ID

Spreadsheet URL