# Get Rows

> Perform Get Rows through Google Sheets.

Source: [https://genhealth.ai/docs/workflows/integrations/google-sheets/google_sheets_get_rows](https://genhealth.ai/docs/workflows/integrations/google-sheets/google_sheets_get_rows)

Integration: [Google Sheets](https://genhealth.ai/docs/workflows/integrations/google-sheets.md)

- Handler: `google_sheets_get_rows`

- Connection type: `google_sheets`

## Inputs

- `google_sheets_account_id` — Google Sheets Account Id (select, dynamic options)
  Optional selected identifier or value. Retrieve allowed values from the dynamic options endpoint.
- `spreadsheet_id` — Spreadsheet Id (expression, required)
  Required literal value or workflow expression.
- `sheet_title` — Sheet Title (select, required, dynamic options)
  Required selected identifier or value. Retrieve allowed values from the dynamic options endpoint.
- `header_row` — Header Row (number)
  Optional numeric value.
  Default: `1`
- `max_rows` — Max Rows (number)
  Optional numeric value.
  Default: `1000`
- `filter_column` — Filter Column (expression)
  Optional literal value or workflow expression.
- `filter_value` — Filter Value (expression)
  Optional literal value or workflow expression.
- `skip_empty_rows` — Skip Empty Rows (boolean)
  Optional true-or-false value.
  Default: `true`

## Outputs

- `success` — Success
- `spreadsheet_id` — Spreadsheet Id
- `sheet_title` — Sheet Title
- `headers` — Headers
- `rows` — Rows
- `row_count` — Row Count
- `truncated` — Truncated
- `error` — Error
- `error_message` — Error 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

```json
{
  "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

```json
{
  "type": "object",
  "properties": {
    "rows": {},
    "error": {},
    "headers": {},
    "success": {},
    "row_count": {},
    "truncated": {},
    "sheet_title": {},
    "error_message": {},
    "spreadsheet_id": {}
  },
  "additionalProperties": true
}
```