Add conditional formatting rules to a Google Sheet to visually highlight cells when they meet specific conditions. Define boolean or gradient rules with custom formatting and target ranges.
Add conditional formatting rules to a Google Sheet
| Name | Required | Description | Default |
|---|---|---|---|
| rules | Yes | ||
| spreadsheetId | Yes |
Changes observed during successful MCP inspections. Dates show when Glama detected each change.
v1.10.2Input schema / properties / rules / defRemoved value: -{
- "element": {
- "def": {
- "shape": {
- "booleanRule": {
- "def": {
- "innerType": {
- "def": {
- "shape": {
- "condition": {
- "def": {
- "shape": {
- "type": {
- "def": {
- "entries": {
- "BLANK": "BLANK",
- "CUSTOM_FORMULA": "CUSTOM_FORMULA",
- "NOT_BLANK": "NOT_BLANK",
- "NUMBER_BETWEEN": "NUMBER_BETWEEN",
- "NUMBER_EQ": "NUMBER_EQ",
- "NUMBER_GREATER": "NUMBER_GREATER",
- "NUMBER_GREATER_THAN_EQ": "NUMBER_GREATER_THAN_EQ",
- "NUMBER_LESS": "NUMBER_LESS",
- "NUMBER_LESS_THAN_EQ": "NUMBER_LESS_THAN_EQ",
- "NUMBER_NOT_BETWEEN": "NUMBER_NOT_BETWEEN",
- "NUMBER_NOT_EQ": "NUMBER_NOT_EQ",
- "TEXT_CONTAINS": "TEXT_CONTAINS",
- "TEXT_ENDS_WITH": "TEXT_ENDS_WITH",
- "TEXT_EQ": "TEXT_EQ",
- "TEXT_NOT_CONTAINS": "TEXT_NOT_CONTAINS",
- "TEXT_STARTS_WITH": "TEXT_STARTS_WITH"
- },
- "type": "enum"
- },
- "enum": {
- "BLANK": "BLANK",
- "CUSTOM_FORMULA": "CUSTOM_FORMULA",
- "NOT_BLANK": "NOT_BLANK",
- "NUMBER_BETWEEN": "NUMBER_BETWEEN",
- "NUMBER_EQ": "NUMBER_EQ",
- "NUMBER_GREATER": "NUMBER_GREATER",
- "NUMBER_GREATER_THAN_EQ": "NUMBER_GREATER_THAN_EQ",
- "NUMBER_LESS": "NUMBER_LESS",
- "NUMBER_LESS_THAN_EQ": "NUMBER_LESS_THAN_EQ",
- "NUMBER_NOT_BETWEEN": "NUMBER_NOT_BETWEEN",
- "NUMBER_NOT_EQ": "NUMBER_NOT_EQ",
- "TEXT_CONTAINS": "TEXT_CONTAINS",
- "TEXT_ENDS_WITH": "TEXT_ENDS_WITH",
- "TEXT_EQ": "TEXT_EQ",
- "TEXT_NOT_CONTAINS": "TEXT_NOT_CONTAINS",
- "TEXT_STARTS_WITH": "TEXT_STARTS_WITH"
- },
- "options": [
- "NUMBER_GREATER",
- "NUMBER_GREATER_THAN_EQ",
- "NUMBER_LESS",
- "NUMBER_LESS_THAN_EQ",
- "NUMBER_EQ",
- "NUMBER_NOT_EQ",
- "NUMBER_BETWEEN",
- "NUMBER_NOT_BETWEEN",
- "TEXT_CONTAINS",
- "TEXT_NOT_CONTAINS",
- "TEXT_STARTS_WITH",
- "TEXT_ENDS_WITH",
- "TEXT_EQ",
- "BLANK",
- "NOT_BLANK",
- "CUSTOM_FORMULA"
- ],
- "type": "enum"
- },
- "values": {
- "def": {
- "innerType": {
- "def": {
- "element": {
- "def": {
- "shape": {
- "relativeDate": {
- "def": {
- "innerType": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "userEnteredValue": {
- "def": {
- "innerType": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "optional"
- },
- "type": "optional"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "type": "array"
- },
- "element": {
- "def": {
- "shape": {
- "relativeDate": {
- "def": {
- "innerType": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "userEnteredValue": {
- "def": {
- "innerType": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "optional"
- },
- "type": "optional"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "type": "array"
- },
- "type": "optional"
- },
- "type": "optional"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "format": {
- "def": {
- "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"
- },
- "type": "object"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "gradientRule": {
- "def": {
- "innerType": {
- "def": {
- "shape": {
- "maxpoint": {
- "def": {
- "shape": {
- "color": {
- "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": {
- "def": {
- "entries": {
- "MAX": "MAX",
- "MIN": "MIN",
- "NUMBER": "NUMBER",
- "PERCENT": "PERCENT",
- "PERCENTILE": "PERCENTILE"
- },
- "type": "enum"
- },
- "enum": {
- "MAX": "MAX",
- "MIN": "MIN",
- "NUMBER": "NUMBER",
- "PERCENT": "PERCENT",
- "PERCENTILE": "PERCENTILE"
- },
- "options": [
- "MIN",
- "MAX",
- "NUMBER",
- "PERCENT",
- "PERCENTILE"
- ],
- "type": "enum"
- },
- "value": {
- "def": {
- "innerType": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "optional"
- },
- "type": "optional"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "midpoint": {
- "def": {
- "innerType": {
- "def": {
- "shape": {
- "color": {
- "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": {
- "def": {
- "entries": {
- "MAX": "MAX",
- "MIN": "MIN",
- "NUMBER": "NUMBER",
- "PERCENT": "PERCENT",
- "PERCENTILE": "PERCENTILE"
- },
- "type": "enum"
- },
- "enum": {
- "MAX": "MAX",
- "MIN": "MIN",
- "NUMBER": "NUMBER",
- "PERCENT": "PERCENT",
- "PERCENTILE": "PERCENTILE"
- },
- "options": [
- "MIN",
- "MAX",
- "NUMBER",
- "PERCENT",
- "PERCENTILE"
- ],
- "type": "enum"
- },
- "value": {
- "def": {
- "innerType": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "optional"
- },
- "type": "optional"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "minpoint": {
- "def": {
- "shape": {
- "color": {
- "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": {
- "def": {
- "entries": {
- "MAX": "MAX",
- "MIN": "MIN",
- "NUMBER": "NUMBER",
- "PERCENT": "PERCENT",
- "PERCENTILE": "PERCENTILE"
- },
- "type": "enum"
- },
- "enum": {
- "MAX": "MAX",
- "MIN": "MIN",
- "NUMBER": "NUMBER",
- "PERCENT": "PERCENT",
- "PERCENTILE": "PERCENTILE"
- },
- "options": [
- "MIN",
- "MAX",
- "NUMBER",
- "PERCENT",
- "PERCENTILE"
- ],
- "type": "enum"
- },
- "value": {
- "def": {
- "innerType": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "optional"
- },
- "type": "optional"
- }
- },
- "type": "object"
- },
- "type": "object"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "ranges": {
- "def": {
- "element": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "array"
- },
- "element": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "array"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "type": "array"
-}Input schema / properties / rules / elementRemoved value: -{
- "def": {
- "shape": {
- "booleanRule": {
- "def": {
- "innerType": {
- "def": {
- "shape": {
- "condition": {
- "def": {
- "shape": {
- "type": {
- "def": {
- "entries": {
- "BLANK": "BLANK",
- "CUSTOM_FORMULA": "CUSTOM_FORMULA",
- "NOT_BLANK": "NOT_BLANK",
- "NUMBER_BETWEEN": "NUMBER_BETWEEN",
- "NUMBER_EQ": "NUMBER_EQ",
- "NUMBER_GREATER": "NUMBER_GREATER",
- "NUMBER_GREATER_THAN_EQ": "NUMBER_GREATER_THAN_EQ",
- "NUMBER_LESS": "NUMBER_LESS",
- "NUMBER_LESS_THAN_EQ": "NUMBER_LESS_THAN_EQ",
- "NUMBER_NOT_BETWEEN": "NUMBER_NOT_BETWEEN",
- "NUMBER_NOT_EQ": "NUMBER_NOT_EQ",
- "TEXT_CONTAINS": "TEXT_CONTAINS",
- "TEXT_ENDS_WITH": "TEXT_ENDS_WITH",
- "TEXT_EQ": "TEXT_EQ",
- "TEXT_NOT_CONTAINS": "TEXT_NOT_CONTAINS",
- "TEXT_STARTS_WITH": "TEXT_STARTS_WITH"
- },
- "type": "enum"
- },
- "enum": {
- "BLANK": "BLANK",
- "CUSTOM_FORMULA": "CUSTOM_FORMULA",
- "NOT_BLANK": "NOT_BLANK",
- "NUMBER_BETWEEN": "NUMBER_BETWEEN",
- "NUMBER_EQ": "NUMBER_EQ",
- "NUMBER_GREATER": "NUMBER_GREATER",
- "NUMBER_GREATER_THAN_EQ": "NUMBER_GREATER_THAN_EQ",
- "NUMBER_LESS": "NUMBER_LESS",
- "NUMBER_LESS_THAN_EQ": "NUMBER_LESS_THAN_EQ",
- "NUMBER_NOT_BETWEEN": "NUMBER_NOT_BETWEEN",
- "NUMBER_NOT_EQ": "NUMBER_NOT_EQ",
- "TEXT_CONTAINS": "TEXT_CONTAINS",
- "TEXT_ENDS_WITH": "TEXT_ENDS_WITH",
- "TEXT_EQ": "TEXT_EQ",
- "TEXT_NOT_CONTAINS": "TEXT_NOT_CONTAINS",
- "TEXT_STARTS_WITH": "TEXT_STARTS_WITH"
- },
- "options": [
- "NUMBER_GREATER",
- "NUMBER_GREATER_THAN_EQ",
- "NUMBER_LESS",
- "NUMBER_LESS_THAN_EQ",
- "NUMBER_EQ",
- "NUMBER_NOT_EQ",
- "NUMBER_BETWEEN",
- "NUMBER_NOT_BETWEEN",
- "TEXT_CONTAINS",
- "TEXT_NOT_CONTAINS",
- "TEXT_STARTS_WITH",
- "TEXT_ENDS_WITH",
- "TEXT_EQ",
- "BLANK",
- "NOT_BLANK",
- "CUSTOM_FORMULA"
- ],
- "type": "enum"
- },
- "values": {
- "def": {
- "innerType": {
- "def": {
- "element": {
- "def": {
- "shape": {
- "relativeDate": {
- "def": {
- "innerType": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "userEnteredValue": {
- "def": {
- "innerType": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "optional"
- },
- "type": "optional"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "type": "array"
- },
- "element": {
- "def": {
- "shape": {
- "relativeDate": {
- "def": {
- "innerType": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "userEnteredValue": {
- "def": {
- "innerType": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "optional"
- },
- "type": "optional"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "type": "array"
- },
- "type": "optional"
- },
- "type": "optional"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "format": {
- "def": {
- "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"
- },
- "type": "object"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "gradientRule": {
- "def": {
- "innerType": {
- "def": {
- "shape": {
- "maxpoint": {
- "def": {
- "shape": {
- "color": {
- "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": {
- "def": {
- "entries": {
- "MAX": "MAX",
- "MIN": "MIN",
- "NUMBER": "NUMBER",
- "PERCENT": "PERCENT",
- "PERCENTILE": "PERCENTILE"
- },
- "type": "enum"
- },
- "enum": {
- "MAX": "MAX",
- "MIN": "MIN",
- "NUMBER": "NUMBER",
- "PERCENT": "PERCENT",
- "PERCENTILE": "PERCENTILE"
- },
- "options": [
- "MIN",
- "MAX",
- "NUMBER",
- "PERCENT",
- "PERCENTILE"
- ],
- "type": "enum"
- },
- "value": {
- "def": {
- "innerType": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "optional"
- },
- "type": "optional"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "midpoint": {
- "def": {
- "innerType": {
- "def": {
- "shape": {
- "color": {
- "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": {
- "def": {
- "entries": {
- "MAX": "MAX",
- "MIN": "MIN",
- "NUMBER": "NUMBER",
- "PERCENT": "PERCENT",
- "PERCENTILE": "PERCENTILE"
- },
- "type": "enum"
- },
- "enum": {
- "MAX": "MAX",
- "MIN": "MIN",
- "NUMBER": "NUMBER",
- "PERCENT": "PERCENT",
- "PERCENTILE": "PERCENTILE"
- },
- "options": [
- "MIN",
- "MAX",
- "NUMBER",
- "PERCENT",
- "PERCENTILE"
- ],
- "type": "enum"
- },
- "value": {
- "def": {
- "innerType": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "optional"
- },
- "type": "optional"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "minpoint": {
- "def": {
- "shape": {
- "color": {
- "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": {
- "def": {
- "entries": {
- "MAX": "MAX",
- "MIN": "MIN",
- "NUMBER": "NUMBER",
- "PERCENT": "PERCENT",
- "PERCENTILE": "PERCENTILE"
- },
- "type": "enum"
- },
- "enum": {
- "MAX": "MAX",
- "MIN": "MIN",
- "NUMBER": "NUMBER",
- "PERCENT": "PERCENT",
- "PERCENTILE": "PERCENTILE"
- },
- "options": [
- "MIN",
- "MAX",
- "NUMBER",
- "PERCENT",
- "PERCENTILE"
- ],
- "type": "enum"
- },
- "value": {
- "def": {
- "innerType": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "optional"
- },
- "type": "optional"
- }
- },
- "type": "object"
- },
- "type": "object"
- }
- },
- "type": "object"
- },
- "type": "object"
- },
- "type": "optional"
- },
- "type": "optional"
- },
- "ranges": {
- "def": {
- "element": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "array"
- },
- "element": {
- "def": {
- "type": "string"
- },
- "format": null,
- "maxLength": null,
- "minLength": null,
- "type": "string"
- },
- "type": "array"
- }
- },
- "type": "object"
- },
- "type": "object"
-}Input schema / properties / rules / itemsAdded value: +{
+ "properties": {
+ "booleanRule": {
+ "properties": {
+ "condition": {
+ "properties": {
+ "type": {
+ "enum": [
+ "NUMBER_GREATER",
+ "NUMBER_GREATER_THAN_EQ",
+ "NUMBER_LESS",
+ "NUMBER_LESS_THAN_EQ",
+ "NUMBER_EQ",
+ "NUMBER_NOT_EQ",
+ "NUMBER_BETWEEN",
+ "NUMBER_NOT_BETWEEN",
+ "TEXT_CONTAINS",
+ "TEXT_NOT_CONTAINS",
+ "TEXT_STARTS_WITH",
+ "TEXT_ENDS_WITH",
+ "TEXT_EQ",
+ "BLANK",
+ "NOT_BLANK",
+ "CUSTOM_FORMULA"
+ ],
+ "type": "string"
+ },
+ "values": {
+ "items": {
+ "properties": {
+ "relativeDate": {
+ "type": "string"
+ },
+ "userEnteredValue": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "required": [
+ "type"
+ ],
+ "type": "object"
+ },
+ "format": {
+ "properties": {
+ "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"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "required": [
+ "condition",
+ "format"
+ ],
+ "type": "object"
+ },
+ "gradientRule": {
+ "properties": {
+ "maxpoint": {
+ "properties": {
+ "color": {
+ "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"
+ },
+ "type": {
+ "enum": [
+ "MIN",
+ "MAX",
+ "NUMBER",
+ "PERCENT",
+ "PERCENTILE"
+ ],
+ "type": "string"
+ },
+ "value": {
+ "type": "string"
+ }
+ },
+ "required": [
+ "color",
+ "type"
+ ],
+ "type": "object"
+ },
+ "midpoint": {
+ "properties": {
+ "color": {
+ "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"
+ },
+ "type": {
+ "enum": [
+ "MIN",
+ "MAX",
+ "NUMBER",
+ "PERCENT",
+ "PERCENTILE"
+ ],
+ "type": "string"
+ },
+ "value": {
+ "type": "string"
+ }
+ },
+ "required": [
+ "color",
+ "type"
+ ],
+ "type": "object"
+ },
+ "minpoint": {
+ "properties": {
+ "color": {
+ "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"
+ },
+ "type": {
+ "enum": [
+ "MIN",
+ "MAX",
+ "NUMBER",
+ "PERCENT",
+ "PERCENTILE"
+ ],
+ "type": "string"
+ },
+ "value": {
+ "type": "string"
+ }
+ },
+ "required": [
+ "color",
+ "type"
+ ],
+ "type": "object"
+ }
+ },
+ "required": [
+ "minpoint",
+ "maxpoint"
+ ],
+ "type": "object"
+ },
+ "ranges": {
+ "items": {
+ "type": "string"
+ },
+ "type": "array"
+ }
+ },
+ "required": [
+ "ranges"
+ ],
+ "type": "object"
+}Input 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 / rules / _defRemoved value: -{
- "exactLength": null,
- "maxLength": null,
- "minLength": null,
- "type": {
- "_cached": null,
- "_def": {
- "catchall": {
- "_def": {
- "typeName": "ZodNever"
- },
- "~standard": {
- "vendor": "zod",
- "version": 1
- }
- },
- "typeName": "ZodObject",
- "unknownKeys": "strip"
- },
- "~standard": {
- "vendor": "zod",
- "version": 1
- }
- },
- "typeName": "ZodArray"
-}Input schema / properties / rules / defAdded value: +{
+ "element": {
+ "def": {
+ "shape": {
+ "booleanRule": {
+ "def": {
+ "innerType": {
+ "def": {
+ "shape": {
+ "condition": {
+ "def": {
+ "shape": {
+ "type": {
+ "def": {
+ "entries": {
+ "BLANK": "BLANK",
+ "CUSTOM_FORMULA": "CUSTOM_FORMULA",
+ "NOT_BLANK": "NOT_BLANK",
+ "NUMBER_BETWEEN": "NUMBER_BETWEEN",
+ "NUMBER_EQ": "NUMBER_EQ",
+ "NUMBER_GREATER": "NUMBER_GREATER",
+ "NUMBER_GREATER_THAN_EQ": "NUMBER_GREATER_THAN_EQ",
+ "NUMBER_LESS": "NUMBER_LESS",
+ "NUMBER_LESS_THAN_EQ": "NUMBER_LESS_THAN_EQ",
+ "NUMBER_NOT_BETWEEN": "NUMBER_NOT_BETWEEN",
+ "NUMBER_NOT_EQ": "NUMBER_NOT_EQ",
+ "TEXT_CONTAINS": "TEXT_CONTAINS",
+ "TEXT_ENDS_WITH": "TEXT_ENDS_WITH",
+ "TEXT_EQ": "TEXT_EQ",
+ "TEXT_NOT_CONTAINS": "TEXT_NOT_CONTAINS",
+ "TEXT_STARTS_WITH": "TEXT_STARTS_WITH"
+ },
+ "type": "enum"
+ },
+ "enum": {
+ "BLANK": "BLANK",
+ "CUSTOM_FORMULA": "CUSTOM_FORMULA",
+ "NOT_BLANK": "NOT_BLANK",
+ "NUMBER_BETWEEN": "NUMBER_BETWEEN",
+ "NUMBER_EQ": "NUMBER_EQ",
+ "NUMBER_GREATER": "NUMBER_GREATER",
+ "NUMBER_GREATER_THAN_EQ": "NUMBER_GREATER_THAN_EQ",
+ "NUMBER_LESS": "NUMBER_LESS",
+ "NUMBER_LESS_THAN_EQ": "NUMBER_LESS_THAN_EQ",
+ "NUMBER_NOT_BETWEEN": "NUMBER_NOT_BETWEEN",
+ "NUMBER_NOT_EQ": "NUMBER_NOT_EQ",
+ "TEXT_CONTAINS": "TEXT_CONTAINS",
+ "TEXT_ENDS_WITH": "TEXT_ENDS_WITH",
+ "TEXT_EQ": "TEXT_EQ",
+ "TEXT_NOT_CONTAINS": "TEXT_NOT_CONTAINS",
+ "TEXT_STARTS_WITH": "TEXT_STARTS_WITH"
+ },
+ "options": [
+ "NUMBER_GREATER",
+ "NUMBER_GREATER_THAN_EQ",
+ "NUMBER_LESS",
+ "NUMBER_LESS_THAN_EQ",
+ "NUMBER_EQ",
+ "NUMBER_NOT_EQ",
+ "NUMBER_BETWEEN",
+ "NUMBER_NOT_BETWEEN",
+ "TEXT_CONTAINS",
+ "TEXT_NOT_CONTAINS",
+ "TEXT_STARTS_WITH",
+ "TEXT_ENDS_WITH",
+ "TEXT_EQ",
+ "BLANK",
+ "NOT_BLANK",
+ "CUSTOM_FORMULA"
+ ],
+ "type": "enum"
+ },
+ "values": {
+ "def": {
+ "innerType": {
+ "def": {
+ "element": {
+ "def": {
+ "shape": {
+ "relativeDate": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "userEnteredValue": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "element": {
+ "def": {
+ "shape": {
+ "relativeDate": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "userEnteredValue": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "format": {
+ "def": {
+ "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"
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "gradientRule": {
+ "def": {
+ "innerType": {
+ "def": {
+ "shape": {
+ "maxpoint": {
+ "def": {
+ "shape": {
+ "color": {
+ "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": {
+ "def": {
+ "entries": {
+ "MAX": "MAX",
+ "MIN": "MIN",
+ "NUMBER": "NUMBER",
+ "PERCENT": "PERCENT",
+ "PERCENTILE": "PERCENTILE"
+ },
+ "type": "enum"
+ },
+ "enum": {
+ "MAX": "MAX",
+ "MIN": "MIN",
+ "NUMBER": "NUMBER",
+ "PERCENT": "PERCENT",
+ "PERCENTILE": "PERCENTILE"
+ },
+ "options": [
+ "MIN",
+ "MAX",
+ "NUMBER",
+ "PERCENT",
+ "PERCENTILE"
+ ],
+ "type": "enum"
+ },
+ "value": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "midpoint": {
+ "def": {
+ "innerType": {
+ "def": {
+ "shape": {
+ "color": {
+ "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": {
+ "def": {
+ "entries": {
+ "MAX": "MAX",
+ "MIN": "MIN",
+ "NUMBER": "NUMBER",
+ "PERCENT": "PERCENT",
+ "PERCENTILE": "PERCENTILE"
+ },
+ "type": "enum"
+ },
+ "enum": {
+ "MAX": "MAX",
+ "MIN": "MIN",
+ "NUMBER": "NUMBER",
+ "PERCENT": "PERCENT",
+ "PERCENTILE": "PERCENTILE"
+ },
+ "options": [
+ "MIN",
+ "MAX",
+ "NUMBER",
+ "PERCENT",
+ "PERCENTILE"
+ ],
+ "type": "enum"
+ },
+ "value": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "minpoint": {
+ "def": {
+ "shape": {
+ "color": {
+ "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": {
+ "def": {
+ "entries": {
+ "MAX": "MAX",
+ "MIN": "MIN",
+ "NUMBER": "NUMBER",
+ "PERCENT": "PERCENT",
+ "PERCENTILE": "PERCENTILE"
+ },
+ "type": "enum"
+ },
+ "enum": {
+ "MAX": "MAX",
+ "MIN": "MIN",
+ "NUMBER": "NUMBER",
+ "PERCENT": "PERCENT",
+ "PERCENTILE": "PERCENTILE"
+ },
+ "options": [
+ "MIN",
+ "MAX",
+ "NUMBER",
+ "PERCENT",
+ "PERCENTILE"
+ ],
+ "type": "enum"
+ },
+ "value": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "ranges": {
+ "def": {
+ "element": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "array"
+ },
+ "element": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "type": "array"
+}Input schema / properties / rules / elementAdded value: +{
+ "def": {
+ "shape": {
+ "booleanRule": {
+ "def": {
+ "innerType": {
+ "def": {
+ "shape": {
+ "condition": {
+ "def": {
+ "shape": {
+ "type": {
+ "def": {
+ "entries": {
+ "BLANK": "BLANK",
+ "CUSTOM_FORMULA": "CUSTOM_FORMULA",
+ "NOT_BLANK": "NOT_BLANK",
+ "NUMBER_BETWEEN": "NUMBER_BETWEEN",
+ "NUMBER_EQ": "NUMBER_EQ",
+ "NUMBER_GREATER": "NUMBER_GREATER",
+ "NUMBER_GREATER_THAN_EQ": "NUMBER_GREATER_THAN_EQ",
+ "NUMBER_LESS": "NUMBER_LESS",
+ "NUMBER_LESS_THAN_EQ": "NUMBER_LESS_THAN_EQ",
+ "NUMBER_NOT_BETWEEN": "NUMBER_NOT_BETWEEN",
+ "NUMBER_NOT_EQ": "NUMBER_NOT_EQ",
+ "TEXT_CONTAINS": "TEXT_CONTAINS",
+ "TEXT_ENDS_WITH": "TEXT_ENDS_WITH",
+ "TEXT_EQ": "TEXT_EQ",
+ "TEXT_NOT_CONTAINS": "TEXT_NOT_CONTAINS",
+ "TEXT_STARTS_WITH": "TEXT_STARTS_WITH"
+ },
+ "type": "enum"
+ },
+ "enum": {
+ "BLANK": "BLANK",
+ "CUSTOM_FORMULA": "CUSTOM_FORMULA",
+ "NOT_BLANK": "NOT_BLANK",
+ "NUMBER_BETWEEN": "NUMBER_BETWEEN",
+ "NUMBER_EQ": "NUMBER_EQ",
+ "NUMBER_GREATER": "NUMBER_GREATER",
+ "NUMBER_GREATER_THAN_EQ": "NUMBER_GREATER_THAN_EQ",
+ "NUMBER_LESS": "NUMBER_LESS",
+ "NUMBER_LESS_THAN_EQ": "NUMBER_LESS_THAN_EQ",
+ "NUMBER_NOT_BETWEEN": "NUMBER_NOT_BETWEEN",
+ "NUMBER_NOT_EQ": "NUMBER_NOT_EQ",
+ "TEXT_CONTAINS": "TEXT_CONTAINS",
+ "TEXT_ENDS_WITH": "TEXT_ENDS_WITH",
+ "TEXT_EQ": "TEXT_EQ",
+ "TEXT_NOT_CONTAINS": "TEXT_NOT_CONTAINS",
+ "TEXT_STARTS_WITH": "TEXT_STARTS_WITH"
+ },
+ "options": [
+ "NUMBER_GREATER",
+ "NUMBER_GREATER_THAN_EQ",
+ "NUMBER_LESS",
+ "NUMBER_LESS_THAN_EQ",
+ "NUMBER_EQ",
+ "NUMBER_NOT_EQ",
+ "NUMBER_BETWEEN",
+ "NUMBER_NOT_BETWEEN",
+ "TEXT_CONTAINS",
+ "TEXT_NOT_CONTAINS",
+ "TEXT_STARTS_WITH",
+ "TEXT_ENDS_WITH",
+ "TEXT_EQ",
+ "BLANK",
+ "NOT_BLANK",
+ "CUSTOM_FORMULA"
+ ],
+ "type": "enum"
+ },
+ "values": {
+ "def": {
+ "innerType": {
+ "def": {
+ "element": {
+ "def": {
+ "shape": {
+ "relativeDate": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "userEnteredValue": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "element": {
+ "def": {
+ "shape": {
+ "relativeDate": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "userEnteredValue": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "format": {
+ "def": {
+ "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"
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "gradientRule": {
+ "def": {
+ "innerType": {
+ "def": {
+ "shape": {
+ "maxpoint": {
+ "def": {
+ "shape": {
+ "color": {
+ "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": {
+ "def": {
+ "entries": {
+ "MAX": "MAX",
+ "MIN": "MIN",
+ "NUMBER": "NUMBER",
+ "PERCENT": "PERCENT",
+ "PERCENTILE": "PERCENTILE"
+ },
+ "type": "enum"
+ },
+ "enum": {
+ "MAX": "MAX",
+ "MIN": "MIN",
+ "NUMBER": "NUMBER",
+ "PERCENT": "PERCENT",
+ "PERCENTILE": "PERCENTILE"
+ },
+ "options": [
+ "MIN",
+ "MAX",
+ "NUMBER",
+ "PERCENT",
+ "PERCENTILE"
+ ],
+ "type": "enum"
+ },
+ "value": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "midpoint": {
+ "def": {
+ "innerType": {
+ "def": {
+ "shape": {
+ "color": {
+ "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": {
+ "def": {
+ "entries": {
+ "MAX": "MAX",
+ "MIN": "MIN",
+ "NUMBER": "NUMBER",
+ "PERCENT": "PERCENT",
+ "PERCENTILE": "PERCENTILE"
+ },
+ "type": "enum"
+ },
+ "enum": {
+ "MAX": "MAX",
+ "MIN": "MIN",
+ "NUMBER": "NUMBER",
+ "PERCENT": "PERCENT",
+ "PERCENTILE": "PERCENTILE"
+ },
+ "options": [
+ "MIN",
+ "MAX",
+ "NUMBER",
+ "PERCENT",
+ "PERCENTILE"
+ ],
+ "type": "enum"
+ },
+ "value": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "minpoint": {
+ "def": {
+ "shape": {
+ "color": {
+ "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": {
+ "def": {
+ "entries": {
+ "MAX": "MAX",
+ "MIN": "MIN",
+ "NUMBER": "NUMBER",
+ "PERCENT": "PERCENT",
+ "PERCENTILE": "PERCENTILE"
+ },
+ "type": "enum"
+ },
+ "enum": {
+ "MAX": "MAX",
+ "MIN": "MIN",
+ "NUMBER": "NUMBER",
+ "PERCENT": "PERCENT",
+ "PERCENTILE": "PERCENTILE"
+ },
+ "options": [
+ "MIN",
+ "MAX",
+ "NUMBER",
+ "PERCENT",
+ "PERCENTILE"
+ ],
+ "type": "enum"
+ },
+ "value": {
+ "def": {
+ "innerType": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+ },
+ "type": "optional"
+ },
+ "type": "optional"
+ },
+ "ranges": {
+ "def": {
+ "element": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "array"
+ },
+ "element": {
+ "def": {
+ "type": "string"
+ },
+ "format": null,
+ "maxLength": null,
+ "minLength": null,
+ "type": "string"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ },
+ "type": "object"
+}Input schema / properties / rules / typeAdded value: +"array"Input schema / properties / rules / ~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?
Annotations already declare idempotentHint=true and destructiveHint=false, so the agent knows it's a safe, idempotent write operation. The description adds no additional behavioral context (e.g., how rules are merged, conflict behavior, or reply details), providing zero value beyond the annotations.
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 a single, efficient sentence with no fluff, but it is drastically under-specified for the tool's complexity. While it scores well on brevity, it fails to earn its place by omitting critical usage details.
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?
The tool has a very complex nested schema (rules with conditions, formats, gradient points) and no output schema. The description provides only a high-level action, leaving out the structure of rules, condition types, and formatting options. It is severely incomplete for an agent to make correct calls.
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 offers no explanation of the two required parameters (spreadsheetId, rules) or the complex nested structure. The agent must rely entirely on the raw schema, which is extensive but lacks semantic hints on how to construct rules (e.g., boolean vs. gradient, condition types).
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 the tool's purpose: 'Add conditional formatting rules to a Google Sheet' with a specific verb ('Add') and resource ('conditional formatting rules'). It distinguishes from sibling sheets_get_conditional_formatting which retrieves rules.
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?
No guidance is provided on when to use this tool versus alternatives, nor any exclusions or prerequisites. The description only states what it does, not when to choose it over other tools like sheets_get_conditional_formatting or sheets_format_cells.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/freema/mcp-gsheets'
If you have feedback or need assistance with the MCP directory API, please join our Discord server