Google Sheets integration

Get Rows

Perform Get Rows through Google Sheets.

View as Markdown

google_sheets_get_rows

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.
spreadsheet_id
expressionrequired
Spreadsheet Id
Required literal value or workflow expression.
sheet_title
selectrequireddynamic options
Sheet Title
Required selected identifier or value. Retrieve allowed values from the dynamic options endpoint.
header_row
number
Header Row
Optional numeric value.
Default: 1
max_rows
number
Max Rows
Optional numeric value.
Default: 1000
filter_column
expression
Filter Column
Optional literal value or workflow expression.
filter_value
expression
Filter Value
Optional literal value or workflow expression.
skip_empty_rows
boolean
Skip Empty Rows
Optional true-or-false value.
Default: true

Outputs

successSuccess
spreadsheet_idSpreadsheet Id
sheet_titleSheet Title
headersHeaders
rowsRows
row_countRow Count
truncatedTruncated
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",
    "sheet_title"
  ],
  "properties": {
    "max_rows": {
      "type": "number",
      "default": 1000,
      "description": "Optional numeric value.",
      "x-workflow-field-type": "number"
    },
    "header_row": {
      "type": "number",
      "default": 1,
      "description": "Optional numeric value.",
      "x-workflow-field-type": "number"
    },
    "sheet_title": {
      "type": "string",
      "description": "Required selected identifier or value. Retrieve allowed values from the dynamic options endpoint.",
      "x-dynamic-options": true,
      "x-workflow-field-type": "select"
    },
    "filter_value": {
      "description": "Optional literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "filter_column": {
      "description": "Optional literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "spreadsheet_id": {
      "description": "Required literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "skip_empty_rows": {
      "type": "boolean",
      "default": true,
      "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": {
    "rows": {},
    "error": {},
    "headers": {},
    "success": {},
    "row_count": {},
    "truncated": {},
    "sheet_title": {},
    "error_message": {},
    "spreadsheet_id": {}
  },
  "additionalProperties": true
}

View all Google Sheets actions