Skip to main content
GET
Read a bounded rectangle of Google Sheets cells

Authorizations

Authorization
string
header
required

Session token passed as Authorization: Bearer <session-token> for user-authenticated Den routes.

Path Parameters

spreadsheetId
string
required
Required string length: 1 - 512
Pattern: ^[A-Za-z0-9_-]+$

Query Parameters

range
string
required
Required string length: 1 - 256
valueRenderOption
enum<string>
default:FORMATTED_VALUE
Available options:
FORMATTED_VALUE,
UNFORMATTED_VALUE,
FORMULA

Response

Google-confirmed result.

ok
boolean
required
spreadsheetId
string
required
range
string
required
majorDimension
string
required
Allowed value: "ROWS"
values
((string | number | boolean)[])[]
required
Maximum string length: 50000
valueRenderOption
enum<string>
default:FORMATTED_VALUE
Available options:
FORMATTED_VALUE,
UNFORMATTED_VALUE,
FORMULA