# Get Values

> Perform Get Values through Google Sheets.

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

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

- Handler: `google_sheets_get_values`

## Inputs

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

## Outputs

- `success` — Success
- `spreadsheet_id` — Spreadsheet Id
- `range` — Range
- `values` — Values
- `row_count` — Row Count
- `column_count` — Column Count
- `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",
    "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

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