files_set_checkbox
Adds checkboxes to a range (a boolean data-validation rendered as a checkbox in each cell; the cell value is TRUE/FALSE). Pass 'id' (from files_validations) to replace that rule; omit to create. Requires edit permission; does not change existing values. Signature: files_set_checkbox(file_uuid, range, sheet?, id?).
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"file_uuid": "<file_uuid>",
"range": "<range>"
},
"name": "files_set_checkbox"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| id | No | Existing validation id to replace; omit to create a new one. | |
| range | Yes | A1 range to add checkboxes to, e.g. 'C2:C100'. | |
| sheet | No | Sheet name (defaults to the first sheet). | |
| file_uuid | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | ||
| file_uuid | Yes | ||
| sequence_number | Yes |