Skip to main content
POST
Add Rows
Append one or more rows (up to 100 at a time) to a sheet. Text column values can be set immediately via the values array. Non-text column cells are created with stale status — trigger a recalculation to compute them. Adding rows creates a new sheet version. The response returns version, the current sheet version count after the rows are appended.

Authorizations

X-API-KEY
string
header
required

Path Parameters

table_id
string<uuid>
required
sheet_id
string<uuid>
required

Body

application/json
count
integer
default:1

Number of rows to append (1–100).

Required range: 1 <= x <= 100
values
object[] | null

Per-row initial values for text columns. Each element is a map of column_id → value.

Response

Rows added

success
boolean
rows_created
integer
start_row_index
integer
row_indices
integer[]
rows
object[]
cell_count
integer
row_count
integer
version
integer

Current sheet version_count for this response. It matches the sheet's version_count after any committed changes.