---
title: "Read Google Sheet values"
method: GET
path: "/v1/social/google-sheets/{accountId}/values"
tags: ["social"]
---

# Read Google Sheet values

`GET /v1/social/google-sheets/{accountId}/values`

## Request

- Base URL: `https://api.brixsignage.com`
- URL: `https://api.brixsignage.com/v1/social/google-sheets/{accountId}/values`
- Auth: none required

Read cell values from a range in a connected Google spreadsheet. Pass the spreadsheetId and range query parameters to select the data. Access requires a dt token, issued by the preview-token endpoint or provided automatically to a screen. If the stored access is no longer valid, it is refreshed automatically, and the last known result is served if the spreadsheet cannot be reached.

**Notes.**
- Feed envelope: `stale` (and `staleSince`) beside `data`. Answers are cached at the edge for a few minutes.

## Path parameters

- `accountId` string, required

## Query parameters

- `dt` string, required
- `spreadsheetId` string, required
- `range` string, required

## Response `200`

Success.

- object
  - `data` object, required
    - `values` array[], required: Rows of cell values, as Google returns them.
      - unknown[]
        - unknown
  - `stale` boolean, required: True when the provider failed and this is the last good answer.
  - `staleSince` string: When the stale copy was fetched (only when `stale`).

## Other responses

- `400`: `bad_spreadsheet` or `bad_range`.
- `401`: Missing, expired or revoked bearer token.
- `404`: No such account, or the `dt` token is missing, expired or for another workspace.
- `502`: The provider failed and there is no recent copy to serve.
- `5XX`: Server error. The body carries a `requestId` to quote to support.

---

[API](https://skmtc.dev/brixsignage/apis/brix-api.md) · [All operations](https://skmtc.dev/brixsignage/apis/brix-api/llms.txt) · [OpenAPI document](https://skmtc.dev/brixsignage/apis/brix-api/revisions/02fd3665dc7d?raw)