Skip to content
MockFlow DevelopersGet an API key

Create spreadsheets with cell data, formulas, and formatting.

Updated 9 Nov 20261 min read

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

data
cellDatastringrequired

JSON string of all cell values keyed by A1, B1, etc. Include formulas in cells that need them.

formulasstring

JSON string listing cells that contain formulas (e.g., {"D2":"=B2*C2"})

rowsintegerrequired

Total number of rows

colsintegerrequired

Total number of columns

formattingstring

JSON string for cell formatting. Use {"A1":{"fontWeight":"bold"}} for headers.

cellFormatsstring

JSON 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.

cellFormatOptionsstring

JSON 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

record
Astring | number | booleanrequired
Bstring | number | boolean
Cstring | number | boolean
Dstring | number | boolean
Estring | number | boolean
Fstring | number | boolean
Gstring | number | boolean
Hstring | number | boolean
Istring | number | boolean
Jstring | number | boolean
keystring

Your 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"
  }
}
Was this page helpful?

Sign in to MockFlow

The same account you use in the app and on the API.

Forgot your password?
or
Continue with GoogleContinue with MicrosoftContinue with Apple