Who the current API key belongs to, its scopes, and its rate limit.

Call this first if anything is failing — it distinguishes a bad key from a scope problem.

List sheets the API key can see. Cursor-paginated; pass the returned nextCursor to get the next page. Max limit 500.

Get a sheet with its columns and first page of rows — one call for a usable snapshot. Use this before writing, to learn the column IDs.

List a sheet's columns. Cell dictionaries are keyed by these column IDs as strings, so you need them before any write.

List a sheet's rows, cursor-paginated by row id. Max limit 500.

Each row carries a version — keep it if you intend to update the row.

Add rows to a sheet. Each item is a dict of cells keyed by column ID (as a string), e.g. {"101": "Acme Corp", "102": "2026-09-01"}.

Partial success: the response reports per-row results plus succeededCount and failedCount, so some rows can land while others fail validation. Maximum 2000 rows per call.

Update one row's cells. cells carries ONLY the changed cells.

version is the row's current version and is checked before the write (optimistic concurrency). If the row changed since you read it you get version_conflict rather than a silent overwrite — read the row again and decide whether your change still applies.

Update many rows. Each item needs 'id', 'version' and 'cells'.

NOTE: unlike update_row, bulk cells OVERWRITES the row's cells rather than merging them. Send the full cell set you want the row to end up with. Partial success per row, version-checked individually. Max 2000.

Delete a row AND ALL OF ITS CHILD ROWS. Destructive and not undoable through this API.

Requires confirm=True. Read the row and its children first so you know what the subtree contains — a parent row can carry descendants that are not obvious from the row itself.

List reports the API key can see.

Get a report's definition (its source sheets, columns and filters).

Run a report and return its rows, cursor-paginated. Max limit 500.