Apply custom formatting to Google Sheets cells: set background colors, text styles, alignment, padding, and number formats. Specify a range and format object to update cell appearance.
Format cells in a Google Sheet (colors, fonts, alignment, number formats)
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | ||
| format | Yes | ||
| spreadsheetId | Yes |
Changes observed during successful MCP inspections.
v1.10.2Input schema / properties / format / defRemoved value: -{
- "shape": {
- "backgroundColor": {
- "def": {
- "innerType": {
- "def": {
- "shape": {
- "alpha": {
- "def": {
- "innerType": {
- "def": {
- "checks": [
- {},
- {}
- ],
- "type": "number"
- },
- "format": null,
- "isFinite": true,
- "isInt": false,
- "maxValue": 1,
- "minValue": 0,
- "type": "number"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "blue": {
- "def": {
- "innerType": {
- "def": {
- "checks": [
- {},
- {}
- ],
- "type": "number"
- },
- "format": null,
- "isFinite": true,
- "isInt": false,
- "maxValue": 1,
- "minValue": 0,
- "type": "number"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "green": {
- "def": {
- "innerType": {
- "def": {
- "checks": [
- {},
- {}
- ],
- "type": "number"
- },
- "format": null,
- "isFinite": true,
- "isInt": false,
- "maxValue": 1,
- "minValue": 0,
- "type": "number"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "red": {
- "def": {
- "innerType": {
- "def": {
- "checks": [
- {},
- {}
- ],
- "type": "number"
- },
- "format": null,
- "isFinite": true,
- "isInt": false,
- "maxValue": 1,
- "minValue": 0,
- "type": "number"
- },
- "type": "optional"
- },
- "type": "optional"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "horizontalAlignment": {
- "def": {
- "innerType": {
- "def": {
- "entries": {
- "CENTER": "CENTER",
- "LEFT": "LEFT",
- "RIGHT": "RIGHT"
- },
- "type": "enum"
- },
- "enum": {
- "CENTER": "CENTER",
- "LEFT": "LEFT",
- "RIGHT": "RIGHT"
- },
- "options": [
- "LEFT",
- "CENTER",
- "RIGHT"
- ],
- "type": "enum"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "numberFormat": {
- "def": {
- "innerType": {
- "def": {
- "shape": {
- "pattern": {
- "def": {
- "innerType": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "type": {
- "def": {
- "entries": {
- "CURRENCY": "CURRENCY",
- "DATE": "DATE",
- "DATE_TIME": "DATE_TIME",
- "NUMBER": "NUMBER",
- "PERCENT": "PERCENT",
- "SCIENTIFIC": "SCIENTIFIC",
- "TEXT": "TEXT",
- "TIME": "TIME"
- },
- "type": "enum"
- },
- "enum": {
- "CURRENCY": "CURRENCY",
- "DATE": "DATE",
- "DATE_TIME": "DATE_TIME",
- "NUMBER": "NUMBER",
- "PERCENT": "PERCENT",
- "SCIENTIFIC": "SCIENTIFIC",
- "TEXT": "TEXT",
- "TIME": "TIME"
- },
- "options": [
- "TEXT",
- "NUMBER",
- "PERCENT",
- "CURRENCY",
- "DATE",
- "TIME",
- "DATE_TIME",
- "SCIENTIFIC"
- ],
- "type": "enum"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "padding": {
- "def": {
- "innerType": {
- "def": {
- "shape": {
- "bottom": {
- "def": {
- "innerType": {
- "def": {
- "checks": [],
- "type": "number"
- },
- "format": null,
- "isFinite": true,
- "isInt": false,
- "maxValue": null,
- "minValue": null,
- "type": "number"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "left": {
- "def": {
- "innerType": {
- "def": {
- "checks": [],
- "type": "number"
- },
- "format": null,
- "isFinite": true,
- "isInt": false,
- "maxValue": null,
- "minValue": null,
- "type": "number"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "right": {
- "def": {
- "innerType": {
- "def": {
- "checks": [],
- "type": "number"
- },
- "format": null,
- "isFinite": true,
- "isInt": false,
- "maxValue": null,
- "minValue": null,
- "type": "number"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "top": {
- "def": {
- "innerType": {
- "def": {
- "checks": [],
- "type": "number"
- },
- "format": null,
- "isFinite": true,
- "isInt": false,
- "maxValue": null,
- "minValue": null,
- "type": "number"
- },
- "type": "optional"
- },
- "type": "optional"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "textFormat": {
- "def": {
- "innerType": {
- "def": {
- "shape": {
- "bold": {
- "def": {
- "innerType": {
- "def": {
- "type": "boolean"
- },
- "type": "boolean"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "fontFamily": {
- "def": {
- "innerType": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "fontSize": {
- "def": {
- "innerType": {
- "def": {
- "checks": [
- {}
- ],
- "type": "number"
- },
- "format": null,
- "isFinite": true,
- "isInt": false,
- "maxValue": null,
- "minValue": 0,
- "type": "number"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "foregroundColor": {
- "def": {
- "innerType": {
- "def": {
- "shape": {
- "alpha": {
- "def": {
- "innerType": {
- "def": {
- "checks": [
- {},
- {}
- ],
- "type": "number"
- },
- "format": null,
- "isFinite": true,
- "isInt": false,
- "maxValue": 1,
- "minValue": 0,
- "type": "number"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "blue": {
- "def": {
- "innerType": {
- "def": {
- "checks": [
- {},
- {}
- ],
- "type": "number"
- },
- "format": null,
- "isFinite": true,
- "isInt": false,
- "maxValue": 1,
- "minValue": 0,
- "type": "number"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "green": {
- "def": {
- "innerType": {
- "def": {
- "checks": [
- {},
- {}
- ],
- "type": "number"
- },
- "format": null,
- "isFinite": true,
- "isInt": false,
- "maxValue": 1,
- "minValue": 0,
- "type": "number"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "red": {
- "def": {
- "innerType": {
- "def": {
- "checks": [
- {},
- {}
- ],
- "type": "number"
- },
- "format": null,
- "isFinite": true,
- "isInt": false,
- "maxValue": 1,
- "minValue": 0,
- "type": "number"
- },
- "type": "optional"
- },
- "type": "optional"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "italic": {
- "def": {
- "innerType": {
- "def": {
- "type": "boolean"
- },
- "type": "boolean"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "strikethrough": {
- "def": {
- "innerType": {
- "def": {
- "type": "boolean"
- },
- "type": "boolean"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "underline": {
- "def": {
- "innerType": {
- "def": {
- "type": "boolean"
- },
- "type": "boolean"
- },
- "type": "optional"
- },
- "type": "optional"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "verticalAlignment": {
- "def": {
- "innerType": {
- "def": {
- "entries": {
- "BOTTOM": "BOTTOM",
- "MIDDLE": "MIDDLE",
- "TOP": "TOP"
- },
- "type": "enum"
- },
- "enum": {
- "BOTTOM": "BOTTOM",
- "MIDDLE": "MIDDLE",
- "TOP": "TOP"
- },
- "options": [
- "TOP",
- "MIDDLE",
- "BOTTOM"
- ],
- "type": "enum"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "wrapStrategy": {
- "def": {
- "innerType": {
- "def": {
- "entries": {
- "CLIP": "CLIP",
- "LEGACY_WRAP": "LEGACY_WRAP",
- "OVERFLOW_CELL": "OVERFLOW_CELL",
- "WRAP": "WRAP"
- },
- "type": "enum"
- },
- "enum": {
- "CLIP": "CLIP",
- "LEGACY_WRAP": "LEGACY_WRAP",
- "OVERFLOW_CELL": "OVERFLOW_CELL",
- "WRAP": "WRAP"
- },
- "options": [
- "OVERFLOW_CELL",
- "LEGACY_WRAP",
- "CLIP",
- "WRAP"
- ],
- "type": "enum"
- },
- "type": "optional"
- },
- "type": "optional"
- }
- },
- "type": "object"
-}Input schema / properties / format / propertiesAdded value: +{
+ "backgroundColor": {
+ "properties": {
+ "alpha": {
+ "maximum": 1,
+ "minimum": 0,
+ "type": "number"
+ },
+ "blue": {
+ "maximum": 1,
+ "minimum": 0,
+ "type": "number"
+ },
+ "green": {
+ "maximum": 1,
+ "minimum": 0,
+ "type": "number"
+ },
+ "red": {
+ "maximum": 1,
+ "minimum": 0,
+ "type": "number"
+ }
+ },
+ "type": "object"
+ },
+ "horizontalAlignment": {
+ "enum": [
+ "LEFT",
+ "CENTER",
+ "RIGHT"
+ ],
+ "type": "string"
+ },
+ "numberFormat": {
+ "properties": {
+ "pattern": {
+ "type": "string"
+ },
+ "type": {
+ "enum": [
+ "TEXT",
+ "NUMBER",
+ "PERCENT",
+ "CURRENCY",
+ "DATE",
+ "TIME",
+ "DATE_TIME",
+ "SCIENTIFIC"
+ ],
+ "type": "string"
+ }
+ },
+ "required": [
+ "type"
+ ],
+ "type": "object"
+ },
+ "padding": {
+ "properties": {
+ "bottom": {
+ "type": "number"
+ },
+ "left": {
+ "type": "number"
+ },
+ "right": {
+ "type": "number"
+ },
+ "top": {
+ "type": "number"
+ }
+ },
+ "type": "object"
+ },
+ "textFormat": {
+ "properties": {
+ "bold": {
+ "type": "boolean"
+ },
+ "fontFamily": {
+ "type": "string"
+ },
+ "fontSize": {
+ "exclusiveMinimum": 0,
+ "type": "number"
+ },
+ "foregroundColor": {
+ "properties": {
+ "alpha": {
+ "maximum": 1,
+ "minimum": 0,
+ "type": "number"
+ },
+ "blue": {
+ "maximum": 1,
+ "minimum": 0,
+ "type": "number"
+ },
+ "green": {
+ "maximum": 1,
+ "minimum": 0,
+ "type": "number"
+ },
+ "red": {
+ "maximum": 1,
+ "minimum": 0,
+ "type": "number"
+ }
+ },
+ "type": "object"
+ },
+ "italic": {
+ "type": "boolean"
+ },
+ "strikethrough": {
+ "type": "boolean"
+ },
+ "underline": {
+ "type": "boolean"
+ }
+ },
+ "type": "object"
+ },
+ "verticalAlignment": {
+ "enum": [
+ "TOP",
+ "MIDDLE",
+ "BOTTOM"
+ ],
+ "type": "string"
+ },
+ "wrapStrategy": {
+ "enum": [
+ "OVERFLOW_CELL",
+ "LEGACY_WRAP",
+ "CLIP",
+ "WRAP"
+ ],
+ "type": "string"
+ }
+}Input schema / properties / range / defRemoved value: -{
- "type": "string"
-}Input schema / properties / range / formatRemoved value: -nullInput schema / properties / range / maxLengthRemoved value: -nullInput schema / properties / range / minLengthRemoved value: -nullInput schema / properties / spreadsheetId / defRemoved value: -{
- "type": "string"
-}Input schema / properties / spreadsheetId / formatRemoved value: -nullInput schema / properties / spreadsheetId / maxLengthRemoved value: -nullInput schema / properties / spreadsheetId / minLengthRemoved value: -nullv1.10.1Input schema / properties / format / _cachedRemoved value: -nullInput schema / properties / format / _defRemoved value: -{
- "catchall": {
- "_def": {
- "typeName": "ZodNever"
- },
- "~standard": {
- "vendor": "zod",
- "version": 1
- }
- },
- "typeName": "ZodObject",
- "unknownKeys": "strip"
-}Input schema / properties / format / defAdded value: +{
+ "shape": {
+ "backgroundColor": {
+ "def": {
+ "innerType": {
+ "def": {
+ "shape": {
+ "alpha": {
+ "def": {
+ "innerType": {
+ "def": {
+ "checks": [
+ {},
+ {}
+ ],
+ "type": "number"
+ },
+ "format": null,
+ "isFinite": true,
+ "isInt": false,
+ "maxValue": 1,
+ "minValue": 0,
+ "type": "number"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "blue": {
+ "def": {
+ "innerType": {
+ "def": {
+ "checks": [
+ {},
+ {}
+ ],
+ "type": "number"
+ },
+ "format": null,
+ "isFinite": true,
+ "isInt": false,
+ "maxValue": 1,
+ "minValue": 0,
+ "type": "number"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "green": {
+ "def": {
+ "innerType": {
+ "def": {
+ "checks": [
+ {},
+ {}
+ ],
+ "type": "number"
+ },
+ "format": null,
+ "isFinite": true,
+ "isInt": false,
+ "maxValue": 1,
+ "minValue": 0,
+ "type": "number"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "red": {
+ "def": {
+ "innerType": {
+ "def": {
+ "checks": [
+ {},
+ {}
+ ],
+ "type": "number"
+ },
+ "format": null,
+ "isFinite": true,
+ "isInt": false,
+ "maxValue": 1,
+ "minValue": 0,
+ "type": "number"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "horizontalAlignment": {
+ "def": {
+ "innerType": {
+ "def": {
+ "entries": {
+ "CENTER": "CENTER",
+ "LEFT": "LEFT",
+ "RIGHT": "RIGHT"
+ },
+ "type": "enum"
+ },
+ "enum": {
+ "CENTER": "CENTER",
+ "LEFT": "LEFT",
+ "RIGHT": "RIGHT"
+ },
+ "options": [
+ "LEFT",
+ "CENTER",
+ "RIGHT"
+ ],
+ "type": "enum"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "numberFormat": {
+ "def": {
+ "innerType": {
+ "def": {
+ "shape": {
+ "pattern": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "type": {
+ "def": {
+ "entries": {
+ "CURRENCY": "CURRENCY",
+ "DATE": "DATE",
+ "DATE_TIME": "DATE_TIME",
+ "NUMBER": "NUMBER",
+ "PERCENT": "PERCENT",
+ "SCIENTIFIC": "SCIENTIFIC",
+ "TEXT": "TEXT",
+ "TIME": "TIME"
+ },
+ "type": "enum"
+ },
+ "enum": {
+ "CURRENCY": "CURRENCY",
+ "DATE": "DATE",
+ "DATE_TIME": "DATE_TIME",
+ "NUMBER": "NUMBER",
+ "PERCENT": "PERCENT",
+ "SCIENTIFIC": "SCIENTIFIC",
+ "TEXT": "TEXT",
+ "TIME": "TIME"
+ },
+ "options": [
+ "TEXT",
+ "NUMBER",
+ "PERCENT",
+ "CURRENCY",
+ "DATE",
+ "TIME",
+ "DATE_TIME",
+ "SCIENTIFIC"
+ ],
+ "type": "enum"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "padding": {
+ "def": {
+ "innerType": {
+ "def": {
+ "shape": {
+ "bottom": {
+ "def": {
+ "innerType": {
+ "def": {
+ "checks": [],
+ "type": "number"
+ },
+ "format": null,
+ "isFinite": true,
+ "isInt": false,
+ "maxValue": null,
+ "minValue": null,
+ "type": "number"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "left": {
+ "def": {
+ "innerType": {
+ "def": {
+ "checks": [],
+ "type": "number"
+ },
+ "format": null,
+ "isFinite": true,
+ "isInt": false,
+ "maxValue": null,
+ "minValue": null,
+ "type": "number"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "right": {
+ "def": {
+ "innerType": {
+ "def": {
+ "checks": [],
+ "type": "number"
+ },
+ "format": null,
+ "isFinite": true,
+ "isInt": false,
+ "maxValue": null,
+ "minValue": null,
+ "type": "number"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "top": {
+ "def": {
+ "innerType": {
+ "def": {
+ "checks": [],
+ "type": "number"
+ },
+ "format": null,
+ "isFinite": true,
+ "isInt": false,
+ "maxValue": null,
+ "minValue": null,
+ "type": "number"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "textFormat": {
+ "def": {
+ "innerType": {
+ "def": {
+ "shape": {
+ "bold": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "boolean"
+ },
+ "type": "boolean"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "fontFamily": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "fontSize": {
+ "def": {
+ "innerType": {
+ "def": {
+ "checks": [
+ {}
+ ],
+ "type": "number"
+ },
+ "format": null,
+ "isFinite": true,
+ "isInt": false,
+ "maxValue": null,
+ "minValue": 0,
+ "type": "number"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "foregroundColor": {
+ "def": {
+ "innerType": {
+ "def": {
+ "shape": {
+ "alpha": {
+ "def": {
+ "innerType": {
+ "def": {
+ "checks": [
+ {},
+ {}
+ ],
+ "type": "number"
+ },
+ "format": null,
+ "isFinite": true,
+ "isInt": false,
+ "maxValue": 1,
+ "minValue": 0,
+ "type": "number"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "blue": {
+ "def": {
+ "innerType": {
+ "def": {
+ "checks": [
+ {},
+ {}
+ ],
+ "type": "number"
+ },
+ "format": null,
+ "isFinite": true,
+ "isInt": false,
+ "maxValue": 1,
+ "minValue": 0,
+ "type": "number"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "green": {
+ "def": {
+ "innerType": {
+ "def": {
+ "checks": [
+ {},
+ {}
+ ],
+ "type": "number"
+ },
+ "format": null,
+ "isFinite": true,
+ "isInt": false,
+ "maxValue": 1,
+ "minValue": 0,
+ "type": "number"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "red": {
+ "def": {
+ "innerType": {
+ "def": {
+ "checks": [
+ {},
+ {}
+ ],
+ "type": "number"
+ },
+ "format": null,
+ "isFinite": true,
+ "isInt": false,
+ "maxValue": 1,
+ "minValue": 0,
+ "type": "number"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "italic": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "boolean"
+ },
+ "type": "boolean"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "strikethrough": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "boolean"
+ },
+ "type": "boolean"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "underline": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "boolean"
+ },
+ "type": "boolean"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "verticalAlignment": {
+ "def": {
+ "innerType": {
+ "def": {
+ "entries": {
+ "BOTTOM": "BOTTOM",
+ "MIDDLE": "MIDDLE",
+ "TOP": "TOP"
+ },
+ "type": "enum"
+ },
+ "enum": {
+ "BOTTOM": "BOTTOM",
+ "MIDDLE": "MIDDLE",
+ "TOP": "TOP"
+ },
+ "options": [
+ "TOP",
+ "MIDDLE",
+ "BOTTOM"
+ ],
+ "type": "enum"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "wrapStrategy": {
+ "def": {
+ "innerType": {
+ "def": {
+ "entries": {
+ "CLIP": "CLIP",
+ "LEGACY_WRAP": "LEGACY_WRAP",
+ "OVERFLOW_CELL": "OVERFLOW_CELL",
+ "WRAP": "WRAP"
+ },
+ "type": "enum"
+ },
+ "enum": {
+ "CLIP": "CLIP",
+ "LEGACY_WRAP": "LEGACY_WRAP",
+ "OVERFLOW_CELL": "OVERFLOW_CELL",
+ "WRAP": "WRAP"
+ },
+ "options": [
+ "OVERFLOW_CELL",
+ "LEGACY_WRAP",
+ "CLIP",
+ "WRAP"
+ ],
+ "type": "enum"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ }
+ },
+ "type": "object"
+}Input schema / properties / format / typeAdded value: +"object"Input schema / properties / format / ~standardRemoved value: -{
- "vendor": "zod",
- "version": 1
-}Input schema / properties / range / _defRemoved value: -{
- "checks": [],
- "coerce": false,
- "typeName": "ZodString"
-}Input schema / properties / range / defAdded value: +{
+ "type": "string"
+}Input schema / properties / range / formatAdded value: +nullInput schema / properties / range / maxLengthAdded value: +nullInput schema / properties / range / minLengthAdded value: +nullInput schema / properties / range / typeAdded value: +"string"Input schema / properties / range / ~standardRemoved value: -{
- "vendor": "zod",
- "version": 1
-}Input schema / properties / spreadsheetId / _defRemoved value: -{
- "checks": [],
- "coerce": false,
- "typeName": "ZodString"
-}Input schema / properties / spreadsheetId / defAdded value: +{
+ "type": "string"
+}Input schema / properties / spreadsheetId / formatAdded value: +nullInput schema / properties / spreadsheetId / maxLengthAdded value: +nullInput schema / properties / spreadsheetId / minLengthAdded value: +nullInput schema / properties / spreadsheetId / typeAdded value: +"string"Input schema / properties / spreadsheetId / ~standardRemoved value: -{
- "vendor": "zod",
- "version": 1
-}v1.0.0Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With annotations showing idempotentHint=true and destructiveHint=false, the description adds no additional behavioral context. It fails to disclose what happens to existing formatting, whether the operation overrides all styles or just specified ones, or any permission requirements. The description only restates what the tool does without deeper behavioral insight.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is extremely concise, consisting of one sentence that front-loads the primary purpose and examples of formatting types. No redundant information is present, making it efficient to parse.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the tool's complexity—a deeply nested format object, numerous enum options, and no output schema—the description is severely under-specified. It does not cover how the format object should be structured, the meaning of different color fields, or behavioral details like whether existing partial formatting is preserved. The lack of any examples or parameter explanations makes it inadequate for correct invocation.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 0%, and the description does not explain the meaning or expected usage of any parameters. While the schema is rich with nested objects and enums, the description provides no additional clarity (e.g., how to specify colors or number formats). The brief mention of format categories gives only a high-level hint of the format object's contents.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states it formats cells in a Google Sheet and lists specific formatting categories (colors, fonts, alignment, number formats). It distinguishes the general purpose from siblings like sheets_batch_format_cells, though it doesn't explicitly differentiate between single and batch operations.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives such as sheets_batch_format_cells or sheets_update_borders. There is no mention of prerequisites, limitations, or context where a different formatting tool would be more appropriate.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.