Google Sheets integration

Get Values

Perform Get Values through Google Sheets.

View as Markdown

google_sheets_get_values

write

Inputs

spreadsheet_id
expressionrequired
Spreadsheet Id
Required literal value or workflow expression.
range_name
expressionrequired
Range Name
Required literal value or workflow expression.
major_dimension
select
Major Dimension
Optional selected identifier or value.
Default: "ROWS"
Options: Rows ("ROWS"), Columns ("COLUMNS")

Outputs

successSuccess
spreadsheet_idSpreadsheet Id
rangeRange
valuesValues
row_countRow Count
column_countColumn Count
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": [
    "spreadsheet_id",
    "range_name"
  ],
  "properties": {
    "range_name": {
      "description": "Required literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "spreadsheet_id": {
      "description": "Required literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "major_dimension": {
      "enum": [
        "ROWS",
        "COLUMNS"
      ],
      "type": "string",
      "default": "ROWS",
      "description": "Optional selected identifier or value.",
      "x-workflow-field-type": "select"
    }
  },
  "additionalProperties": false
}

Output schema

{
  "type": "object",
  "properties": {
    "error": {},
    "range": {},
    "values": {},
    "success": {},
    "row_count": {},
    "column_count": {},
    "error_message": {},
    "spreadsheet_id": {}
  },
  "additionalProperties": true
}

View all Google Sheets actions