Google Sheets integration

Create Sheet From Upload

Perform Create Sheet From Upload through Google Sheets.

View as Markdown

google_sheets_create_from_upload

writegoogle_sheets

Inputs

google_sheets_account_id
selectdynamic options
Google Sheets Account Id
Optional selected identifier or value. Retrieve allowed values from the dynamic options endpoint.
document_id
expressionrequired
Document Id
Required literal value or workflow expression.
title
expression
Title
Optional literal value or workflow expression.
sheet_title
expression
Sheet Title
Optional literal value or workflow expression.
Default: "Sheet1"
source_format
select
Source Format
Optional selected identifier or value.
Default: "auto"
Options: Auto Detect ("auto"), CSV ("csv"), Excel (.xlsx) ("xlsx")
write_enabled
boolean
Write Enabled
Optional true-or-false value.
Default: false

Outputs

successSuccess
submittedSubmitted
write_skippedWrite Skipped
skip_reasonSkip Reason
spreadsheet_idSpreadsheet Id
spreadsheet_urlSpreadsheet Url
sheet_titleSheet Title
row_countRow Count
column_countColumn Count
drive_folder_idDrive Folder Id
errorError
error_messageError Message

Output schema completeness: best_effort_declared

Safety

External effect: write
Confirmation recommended: No
Retry safe: No
Dry run supported: No

Schemas

These schemas are first-pass authoring guidance. Runtime validation remains authoritative.

Input schema

{
  "type": "object",
  "required": [
    "document_id"
  ],
  "properties": {
    "title": {
      "description": "Optional literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "document_id": {
      "description": "Required literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "sheet_title": {
      "default": "Sheet1",
      "description": "Optional literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "source_format": {
      "enum": [
        "auto",
        "csv",
        "xlsx"
      ],
      "type": "string",
      "default": "auto",
      "description": "Optional selected identifier or value.",
      "x-workflow-field-type": "select"
    },
    "write_enabled": {
      "type": "boolean",
      "default": false,
      "description": "Optional true-or-false value.",
      "x-workflow-field-type": "boolean"
    },
    "google_sheets_account_id": {
      "type": "string",
      "description": "Optional selected identifier or value. Retrieve allowed values from the dynamic options endpoint.",
      "x-dynamic-options": true,
      "x-workflow-field-type": "select"
    }
  },
  "additionalProperties": false
}

Output schema

{
  "type": "object",
  "properties": {
    "error": {},
    "success": {},
    "row_count": {},
    "submitted": {},
    "sheet_title": {},
    "skip_reason": {},
    "column_count": {},
    "error_message": {},
    "write_skipped": {},
    "spreadsheet_id": {},
    "drive_folder_id": {},
    "spreadsheet_url": {}
  },
  "additionalProperties": true
}

View all Google Sheets actions