Skip to main content
GET
Preview a Google Sheet's columns

Authorizations

Authorization
string
header
required

An API key from Settings → API keys, sent as Authorization: Bearer kb_live_…. A workspace key starts kb_; a personal key starts kbp_ and acts as its owner.

Headers

Kallabot-Version
enum<string>

The API version to answer as, a date (YYYY-MM-DD). Leave it out for the current version (2026-11-07). An unknown version is refused with 400 unsupported_api_version.

Available options:
2026-11-07
Example:

"2026-11-07"

Query Parameters

url
string
default:""
Maximum string length: 2000
sheet
string | null
Maximum string length: 200

Response

Successful Response

spreadsheet_id
string
required
sheet
string | null
required
title
string | null
required
columns
SheetColumn · object[]
required
rows
integer
required