---
title: "Read spreadsheet data"
method: GET
path: "/api/v1/sheets/{spreadsheet_id}"
---

# Read spreadsheet data

`GET /api/v1/sheets/{spreadsheet_id}`

## Request

- Base URL: `https://localhost:3000`
- URL: `https://localhost:3000/api/v1/sheets/{spreadsheet_id}`
- Auth: OAuth 2 (authorization code, authorization URL `/oauth/authorize`, token URL `/oauth/token`)

Read data from a Google Sheets spreadsheet using A1 notation.

## Path parameters

- `spreadsheet_id` string, required

## Query parameters

- `range` string, required

## Response `200`

Spreadsheet data

- SheetDataResponse
  - `user` string
  - `spreadsheet_id` string
  - `range` string
  - `data` array[]: 2D array of cell values
    - string[]
  - `rows` integer: Number of rows returned

## Other responses

- `401`: Authentication required
- `404`: Spreadsheet not found
- `500`: Internal server error

---

[API](https://skmtc.dev/corpusiq/apis/multi-source-mcp-api.md) · [All operations](https://skmtc.dev/corpusiq/apis/multi-source-mcp-api/llms.txt) · [OpenAPI document](https://skmtc.dev/corpusiq/apis/multi-source-mcp-api/revisions/e25648ba6027?raw)