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

Authorizations

x-api-key
string
header
required

Organization API key passed as the x-api-key header. The raw key is the header value; do not prefix it with Bearer.

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