sheetcanvas.com
sheetcanvas.com
live
Unverified (seed import)
Productivity & Business
21 tools
imperative implementation
Connect Claude, Codex, or another MCP-capable agent to SheetCanvas so messy business data becomes durable tables, charts, pivots, notes, and dashboards.
First seen 2026-09-14 · Last seen 2026-09-14 · Source: webmcp.com
Answer 10 · Act 10 · Transact 1 · Score: Not yet scored
Tool inspector
applyFormat
act
imperative
Applies presentation formatting (units, decimals, dates, in-cell visuals) to an A1 range without changing values; works on normal and derived sheets. Pass exactly one of format or preset, not both. preset is a shortcut (integer, decimal, compactNumber, currency, compactCurrency, percent, date, datetime, duration, text, customD3); customD3 needs d3Format. Use visual:"bar" for a primary metric; use heatmapColor:"diverging" for values around zero, heatmapFlip:true when lower is better.
Page: /
Input schema
| Property | Type | Required | Description |
|---|---|---|---|
sheetId |
string | yes | — |
range |
string | yes | — |
format |
— | no | — |
preset |
object | no | — |
reason |
string | no | — |
Raw JSON schema
{
"type": "object",
"properties": {
"sheetId": {
"type": "string"
},
"range": {
"type": "string",
"pattern": "^[A-Z]+\\d+(:[A-Z]+\\d+)?$"
},
"format": {
"oneOf": [
{
"type": "object",
"properties": {
"type": {
"type": "string",
"const": "number"
},
"decimals": {
"type": "integer",
"minimum": 0,
"maximum": 10
},
"d3Format": {
"type": "string",
"minLength": 1,
"maxLength": 40
},
"visual": {
"type": "string",
"enum": [
"bar",
"bar-row",
"heatmap",
"heatmap-row",
"sparkline"
]
},
"heatmapColor": {
"type": "string",
"enum": [
"red",
"green",
"yellow",
"diverging"
]
},
"heatmapFlip": {
"type": "boolean"
}
},
"required": [
"type"
],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"type": {
"type": "string",
"const": "currency"
},
"symbol": {
"type": "string",
"maxLength": 4
},
"decimals": {
"type": "integer",
"minimum": 0,
"maximum": 10
},
"d3Format": {
"type": "string",
"minLength": 1,
"maxLength": 40
},
"visual": {
"type": "string",
"enum": [
"bar",
"bar-row",
"heatmap",
"heatmap-row",
"sparkline"
]
},
"heatmapColor": {
"type": "string",
"enum": [
"red",
"green",
"yellow",
"diverging"
]
},
"heatmapFlip": {
"type": "boolean"
}
},
"required": [
"type"
],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"type": {
"type": "string",
"const": "percent"
},
"decimals": {
"type": "integer",
"minimum": 0,
"maximum": 10
},
"d3Format": {
"type": "string",
"minLength": 1,
"maxLength": 40
},
"visual": {
"type": "string",
"enum": [
"bar",
"bar-row",
"heatmap",
"heatmap-row",
"sparkline"
]
},
"heatmapColor": {
"type": "string",
"enum": [
"red",
"green",
"yellow",
"diverging"
]
},
"heatmapFlip": {
"type": "boolean"
}
},
"required": [
"type"
],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"type": {
"type": "string",
"const": "date"
},
"dateFormat": {
"type": "string",
"maxLength": 40
},
"visual": {
"type": "string",
"enum": [
"bar",
"bar-row",
"heatmap",
"heatmap-row",
"sparkline"
]
},
"heatmapColor": {
"type": "string",
"enum": [
"red",
"green",
"yellow",
"diverging"
]
},
"heatmapFlip": {
"type": "boolean"
}
},
"required": [
"type"
],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"type": {
"type": "string",
"const": "text"
},
"visual": {
"type": "string",
"enum": [
"bar",
"bar-row",
"heatmap",
"heatmap-row",
"sparkline"
]
},
"heatmapColor": {
"type": "string",
"enum": [
"red",
"green",
"yellow",
"diverging"
]
},
"heatmapFlip": {
"type": "boolean"
}
},
"required": [
"type"
],
"additionalProperties": false
}
]
},
"preset": {
"type": "object",
"properties": {
"preset": {
"type": "string",
"enum": [
"integer",
"decimal",
"compactNumber",
"currency",
"compactCurrency",
"percent",
"date",
"datetime",
"duration",
"text",
"customD3"
]
},
"decimals": {
"type": "integer",
"minimum": 0,
"maximum": 10
},
"symbol": {
"type": "string",
"maxLength": 4
},
"d3Format": {
"type": "string",
"minLength": 1,
"maxLength": 40
},
"dateFormat": {
"type": "string",
"maxLength": 40
},
"visual": {
"type": "string",
"enum": [
"bar",
"bar-row",
"heatmap",
"heatmap-row",
"sparkline"
]
},
"heatmapColor": {
"type": "string",
"enum": [
"red",
"green",
"yellow",
"diverging"
]
},
"heatmapFlip": {
"type": "boolean"
}
},
"required": [
"preset"
],
"additionalProperties": false
},
"reason": {
"type": "string",
"minLength": 1,
"maxLength": 160
}
},
"required": [
"sheetId",
"range"
],
"additionalProperties": false
}
Similar websites
eworker.ca
eworker.ca
E-Worker is business infrastructure powered by AI, with focused apps and connected business work.
live
Unverified
Productivity & Business
eworker_site_status
eworker_list_apps
eworker_resolve_app
eworker_open_app
ewdoc_status
Inspect tools
urban-planning-copilot.heisenbug.in
urban-planning-copilot.heisenbug.in
Urban Planning Copilot
demo
Unverified
Productivity & Business
get_workspace
get_analysis_plan
list_candidates
inspect_candidate
list_shortlist
Inspect tools
vide.zerdalu.com
vide.zerdalu.com
Vide
live
Unverified
Productivity & Business
Transact tools
list_project_files
read_project_file
write_project_file
delete_project_file
get_active_script
Inspect tools
labspace-agent-twin.onrender.com
labspace-agent-twin.onrender.com
LabSpace Atlas — design laboratories, index exact locations, and let a browser agent plan, audit, and navigate the spatial twin.
demo
Unverified
Productivity & Business
labspace_add_inventory
labspace_assess_workflow
labspace_resolve_materials
labspace_start_collection
labspace_collection_step
Inspect tools