Spreadsheet
Create spreadsheets with cell data, formulas, and formatting.
Send "type": "spreadsheet".
Create spreadsheets with cell data, formulas, and formatting.
Also available as the MCP tool render_spreadsheet. The same payload works through either surface.
Fields
cellDatastringrequiredJSON string of all cell values keyed by A1, B1, etc. Include formulas in cells that need them.
formulasstringJSON string listing cells that contain formulas (e.g., {"D2":"=B2*C2"})
rowsintegerrequiredTotal number of rows
colsintegerrequiredTotal number of columns
formattingstringJSON string for cell formatting. Use {"A1":{"fontWeight":"bold"}} for headers.
cellFormatsstringJSON string mapping cells to a display format: "number", "currency", "percentage", or "date". e.g. {"B2":"number","C2":"currency"}. Use for numeric/money/percent/date columns.
cellFormatOptionsstringJSON string of per-cell format options: {"B2":{"decimals":2},"C2":{"currency":"USD","decimals":2}}. Pairs with cellFormats.
Example
{
"type": "spreadsheet",
"data": {
"cellData": "string",
"formulas": "string",
"rows": 0,
"cols": 0,
"formatting": "string",
"cellFormats": "string",
"cellFormatOptions": "string"
}
}
Add one record
POST /boards/{boardId}/items/{itemId}/records adds one of these to an item already on a board and leaves the rest of it as it is. Send the same key again to update that record instead of adding another.
Record fields
Astring | number | booleanrequiredBstring | number | booleanCstring | number | booleanDstring | number | booleanEstring | number | booleanFstring | number | booleanGstring | number | booleanHstring | number | booleanIstring | number | booleanJstring | number | booleankeystringYour own id for this record, like an issue key. Sending the same key again updates and moves that record instead of adding another.
{
"record": {
"A": "string",
"B": "string",
"C": "string",
"D": "string",
"E": "string",
"F": "string",
"G": "string"
}
}