Skip to main content
Glama

sheets_update_borders

Idempotent

Define and apply borders to a Google Sheets range by specifying style, color, and width per edge, including inner borders, to improve table formatting.

Instructions

Update borders of cells in a Google Sheet

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
rangeYes
bordersYes
spreadsheetIdYes

Schema Changelog

Changes observed during successful MCP inspections. Dates show when Glama detected each change.

  1. Changed10 schema fields changedv1.10.2
    • removedInput schema / properties / borders / def
      Removed value: -{
      -  "shape": {
      -    "bottom": {
      -      "def": {
      -        "innerType": {
      -          "def": {
      -            "shape": {
      -              "color": {
      -                "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"
      -              },
      -              "style": {
      -                "def": {
      -                  "entries": {
      -                    "DASHED": "DASHED",
      -                    "DOTTED": "DOTTED",
      -                    "DOUBLE": "DOUBLE",
      -                    "NONE": "NONE",
      -                    "SOLID": "SOLID",
      -                    "SOLID_MEDIUM": "SOLID_MEDIUM",
      -                    "SOLID_THICK": "SOLID_THICK"
      -                  },
      -                  "type": "enum"
      -                },
      -                "enum": {
      -                  "DASHED": "DASHED",
      -                  "DOTTED": "DOTTED",
      -                  "DOUBLE": "DOUBLE",
      -                  "NONE": "NONE",
      -                  "SOLID": "SOLID",
      -                  "SOLID_MEDIUM": "SOLID_MEDIUM",
      -                  "SOLID_THICK": "SOLID_THICK"
      -                },
      -                "options": [
      -                  "NONE",
      -                  "SOLID",
      -                  "DASHED",
      -                  "DOTTED",
      -                  "SOLID_MEDIUM",
      -                  "SOLID_THICK",
      -                  "DOUBLE"
      -                ],
      -                "type": "enum"
      -              },
      -              "width": {
      -                "def": {
      -                  "innerType": {
      -                    "def": {
      -                      "checks": [
      -                        {}
      -                      ],
      -                      "type": "number"
      -                    },
      -                    "format": null,
      -                    "isFinite": true,
      -                    "isInt": false,
      -                    "maxValue": null,
      -                    "minValue": 0,
      -                    "type": "number"
      -                  },
      -                  "type": "optional"
      -                },
      -                "type": "optional"
      -              }
      -            },
      -            "type": "object"
      -          },
      -          "type": "object"
      -        },
      -        "type": "optional"
      -      },
      -      "type": "optional"
      -    },
      -    "innerHorizontal": {
      -      "def": {
      -        "innerType": {
      -          "def": {
      -            "shape": {
      -              "color": {
      -                "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"
      -              },
      -              "style": {
      -                "def": {
      -                  "entries": {
      -                    "DASHED": "DASHED",
      -                    "DOTTED": "DOTTED",
      -                    "DOUBLE": "DOUBLE",
      -                    "NONE": "NONE",
      -                    "SOLID": "SOLID",
      -                    "SOLID_MEDIUM": "SOLID_MEDIUM",
      -                    "SOLID_THICK": "SOLID_THICK"
      -                  },
      -                  "type": "enum"
      -                },
      -                "enum": {
      -                  "DASHED": "DASHED",
      -                  "DOTTED": "DOTTED",
      -                  "DOUBLE": "DOUBLE",
      -                  "NONE": "NONE",
      -                  "SOLID": "SOLID",
      -                  "SOLID_MEDIUM": "SOLID_MEDIUM",
      -                  "SOLID_THICK": "SOLID_THICK"
      -                },
      -                "options": [
      -                  "NONE",
      -                  "SOLID",
      -                  "DASHED",
      -                  "DOTTED",
      -                  "SOLID_MEDIUM",
      -                  "SOLID_THICK",
      -                  "DOUBLE"
      -                ],
      -                "type": "enum"
      -              },
      -              "width": {
      -                "def": {
      -                  "innerType": {
      -                    "def": {
      -                      "checks": [
      -                        {}
      -                      ],
      -                      "type": "number"
      -                    },
      -                    "format": null,
      -                    "isFinite": true,
      -                    "isInt": false,
      -                    "maxValue": null,
      -                    "minValue": 0,
      -                    "type": "number"
      -                  },
      -                  "type": "optional"
      -                },
      -                "type": "optional"
      -              }
      -            },
      -            "type": "object"
      -          },
      -          "type": "object"
      -        },
      -        "type": "optional"
      -      },
      -      "type": "optional"
      -    },
      -    "innerVertical": {
      -      "def": {
      -        "innerType": {
      -          "def": {
      -            "shape": {
      -              "color": {
      -                "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"
      -              },
      -              "style": {
      -                "def": {
      -                  "entries": {
      -                    "DASHED": "DASHED",
      -                    "DOTTED": "DOTTED",
      -                    "DOUBLE": "DOUBLE",
      -                    "NONE": "NONE",
      -                    "SOLID": "SOLID",
      -                    "SOLID_MEDIUM": "SOLID_MEDIUM",
      -                    "SOLID_THICK": "SOLID_THICK"
      -                  },
      -                  "type": "enum"
      -                },
      -                "enum": {
      -                  "DASHED": "DASHED",
      -                  "DOTTED": "DOTTED",
      -                  "DOUBLE": "DOUBLE",
      -                  "NONE": "NONE",
      -                  "SOLID": "SOLID",
      -                  "SOLID_MEDIUM": "SOLID_MEDIUM",
      -                  "SOLID_THICK": "SOLID_THICK"
      -                },
      -                "options": [
      -                  "NONE",
      -                  "SOLID",
      -                  "DASHED",
      -                  "DOTTED",
      -                  "SOLID_MEDIUM",
      -                  "SOLID_THICK",
      -                  "DOUBLE"
      -                ],
      -                "type": "enum"
      -              },
      -              "width": {
      -                "def": {
      -                  "innerType": {
      -                    "def": {
      -                      "checks": [
      -                        {}
      -                      ],
      -                      "type": "number"
      -                    },
      -                    "format": null,
      -                    "isFinite": true,
      -                    "isInt": false,
      -                    "maxValue": null,
      -                    "minValue": 0,
      -                    "type": "number"
      -                  },
      -                  "type": "optional"
      -                },
      -                "type": "optional"
      -              }
      -            },
      -            "type": "object"
      -          },
      -          "type": "object"
      -        },
      -        "type": "optional"
      -      },
      -      "type": "optional"
      -    },
      -    "left": {
      -      "def": {
      -        "innerType": {
      -          "def": {
      -            "shape": {
      -              "color": {
      -                "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"
      -              },
      -              "style": {
      -                "def": {
      -                  "entries": {
      -                    "DASHED": "DASHED",
      -                    "DOTTED": "DOTTED",
      -                    "DOUBLE": "DOUBLE",
      -                    "NONE": "NONE",
      -                    "SOLID": "SOLID",
      -                    "SOLID_MEDIUM": "SOLID_MEDIUM",
      -                    "SOLID_THICK": "SOLID_THICK"
      -                  },
      -                  "type": "enum"
      -                },
      -                "enum": {
      -                  "DASHED": "DASHED",
      -                  "DOTTED": "DOTTED",
      -                  "DOUBLE": "DOUBLE",
      -                  "NONE": "NONE",
      -                  "SOLID": "SOLID",
      -                  "SOLID_MEDIUM": "SOLID_MEDIUM",
      -                  "SOLID_THICK": "SOLID_THICK"
      -                },
      -                "options": [
      -                  "NONE",
      -                  "SOLID",
      -                  "DASHED",
      -                  "DOTTED",
      -                  "SOLID_MEDIUM",
      -                  "SOLID_THICK",
      -                  "DOUBLE"
      -                ],
      -                "type": "enum"
      -              },
      -              "width": {
      -                "def": {
      -                  "innerType": {
      -                    "def": {
      -                      "checks": [
      -                        {}
      -                      ],
      -                      "type": "number"
      -                    },
      -                    "format": null,
      -                    "isFinite": true,
      -                    "isInt": false,
      -                    "maxValue": null,
      -                    "minValue": 0,
      -                    "type": "number"
      -                  },
      -                  "type": "optional"
      -                },
      -                "type": "optional"
      -              }
      -            },
      -            "type": "object"
      -          },
      -          "type": "object"
      -        },
      -        "type": "optional"
      -      },
      -      "type": "optional"
      -    },
      -    "right": {
      -      "def": {
      -        "innerType": {
      -          "def": {
      -            "shape": {
      -              "color": {
      -                "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"
      -              },
      -              "style": {
      -                "def": {
      -                  "entries": {
      -                    "DASHED": "DASHED",
      -                    "DOTTED": "DOTTED",
      -                    "DOUBLE": "DOUBLE",
      -                    "NONE": "NONE",
      -                    "SOLID": "SOLID",
      -                    "SOLID_MEDIUM": "SOLID_MEDIUM",
      -                    "SOLID_THICK": "SOLID_THICK"
      -                  },
      -                  "type": "enum"
      -                },
      -                "enum": {
      -                  "DASHED": "DASHED",
      -                  "DOTTED": "DOTTED",
      -                  "DOUBLE": "DOUBLE",
      -                  "NONE": "NONE",
      -                  "SOLID": "SOLID",
      -                  "SOLID_MEDIUM": "SOLID_MEDIUM",
      -                  "SOLID_THICK": "SOLID_THICK"
      -                },
      -                "options": [
      -                  "NONE",
      -                  "SOLID",
      -                  "DASHED",
      -                  "DOTTED",
      -                  "SOLID_MEDIUM",
      -                  "SOLID_THICK",
      -                  "DOUBLE"
      -                ],
      -                "type": "enum"
      -              },
      -              "width": {
      -                "def": {
      -                  "innerType": {
      -                    "def": {
      -                      "checks": [
      -                        {}
      -                      ],
      -                      "type": "number"
      -                    },
      -                    "format": null,
      -                    "isFinite": true,
      -                    "isInt": false,
      -                    "maxValue": null,
      -                    "minValue": 0,
      -                    "type": "number"
      -                  },
      -                  "type": "optional"
      -                },
      -                "type": "optional"
      -              }
      -            },
      -            "type": "object"
      -          },
      -          "type": "object"
      -        },
      -        "type": "optional"
      -      },
      -      "type": "optional"
      -    },
      -    "top": {
      -      "def": {
      -        "innerType": {
      -          "def": {
      -            "shape": {
      -              "color": {
      -                "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"
      -              },
      -              "style": {
      -                "def": {
      -                  "entries": {
      -                    "DASHED": "DASHED",
      -                    "DOTTED": "DOTTED",
      -                    "DOUBLE": "DOUBLE",
      -                    "NONE": "NONE",
      -                    "SOLID": "SOLID",
      -                    "SOLID_MEDIUM": "SOLID_MEDIUM",
      -                    "SOLID_THICK": "SOLID_THICK"
      -                  },
      -                  "type": "enum"
      -                },
      -                "enum": {
      -                  "DASHED": "DASHED",
      -                  "DOTTED": "DOTTED",
      -                  "DOUBLE": "DOUBLE",
      -                  "NONE": "NONE",
      -                  "SOLID": "SOLID",
      -                  "SOLID_MEDIUM": "SOLID_MEDIUM",
      -                  "SOLID_THICK": "SOLID_THICK"
      -                },
      -                "options": [
      -                  "NONE",
      -                  "SOLID",
      -                  "DASHED",
      -                  "DOTTED",
      -                  "SOLID_MEDIUM",
      -                  "SOLID_THICK",
      -                  "DOUBLE"
      -                ],
      -                "type": "enum"
      -              },
      -              "width": {
      -                "def": {
      -                  "innerType": {
      -                    "def": {
      -                      "checks": [
      -                        {}
      -                      ],
      -                      "type": "number"
      -                    },
      -                    "format": null,
      -                    "isFinite": true,
      -                    "isInt": false,
      -                    "maxValue": null,
      -                    "minValue": 0,
      -                    "type": "number"
      -                  },
      -                  "type": "optional"
      -                },
      -                "type": "optional"
      -              }
      -            },
      -            "type": "object"
      -          },
      -          "type": "object"
      -        },
      -        "type": "optional"
      -      },
      -      "type": "optional"
      -    }
      -  },
      -  "type": "object"
      -}
    • addedInput schema / properties / borders / properties
      Added value: +{
      +  "bottom": {
      +    "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"
      +      },
      +      "style": {
      +        "enum": [
      +          "NONE",
      +          "SOLID",
      +          "DASHED",
      +          "DOTTED",
      +          "SOLID_MEDIUM",
      +          "SOLID_THICK",
      +          "DOUBLE"
      +        ],
      +        "type": "string"
      +      },
      +      "width": {
      +        "exclusiveMinimum": 0,
      +        "type": "number"
      +      }
      +    },
      +    "required": [
      +      "style"
      +    ],
      +    "type": "object"
      +  },
      +  "innerHorizontal": {
      +    "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"
      +      },
      +      "style": {
      +        "enum": [
      +          "NONE",
      +          "SOLID",
      +          "DASHED",
      +          "DOTTED",
      +          "SOLID_MEDIUM",
      +          "SOLID_THICK",
      +          "DOUBLE"
      +        ],
      +        "type": "string"
      +      },
      +      "width": {
      +        "exclusiveMinimum": 0,
      +        "type": "number"
      +      }
      +    },
      +    "required": [
      +      "style"
      +    ],
      +    "type": "object"
      +  },
      +  "innerVertical": {
      +    "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"
      +      },
      +      "style": {
      +        "enum": [
      +          "NONE",
      +          "SOLID",
      +          "DASHED",
      +          "DOTTED",
      +          "SOLID_MEDIUM",
      +          "SOLID_THICK",
      +          "DOUBLE"
      +        ],
      +        "type": "string"
      +      },
      +      "width": {
      +        "exclusiveMinimum": 0,
      +        "type": "number"
      +      }
      +    },
      +    "required": [
      +      "style"
      +    ],
      +    "type": "object"
      +  },
      +  "left": {
      +    "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"
      +      },
      +      "style": {
      +        "enum": [
      +          "NONE",
      +          "SOLID",
      +          "DASHED",
      +          "DOTTED",
      +          "SOLID_MEDIUM",
      +          "SOLID_THICK",
      +          "DOUBLE"
      +        ],
      +        "type": "string"
      +      },
      +      "width": {
      +        "exclusiveMinimum": 0,
      +        "type": "number"
      +      }
      +    },
      +    "required": [
      +      "style"
      +    ],
      +    "type": "object"
      +  },
      +  "right": {
      +    "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"
      +      },
      +      "style": {
      +        "enum": [
      +          "NONE",
      +          "SOLID",
      +          "DASHED",
      +          "DOTTED",
      +          "SOLID_MEDIUM",
      +          "SOLID_THICK",
      +          "DOUBLE"
      +        ],
      +        "type": "string"
      +      },
      +      "width": {
      +        "exclusiveMinimum": 0,
      +        "type": "number"
      +      }
      +    },
      +    "required": [
      +      "style"
      +    ],
      +    "type": "object"
      +  },
      +  "top": {
      +    "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"
      +      },
      +      "style": {
      +        "enum": [
      +          "NONE",
      +          "SOLID",
      +          "DASHED",
      +          "DOTTED",
      +          "SOLID_MEDIUM",
      +          "SOLID_THICK",
      +          "DOUBLE"
      +        ],
      +        "type": "string"
      +      },
      +      "width": {
      +        "exclusiveMinimum": 0,
      +        "type": "number"
      +      }
      +    },
      +    "required": [
      +      "style"
      +    ],
      +    "type": "object"
      +  }
      +}
    • removedInput schema / properties / range / def
      Removed value: -{
      -  "type": "string"
      -}
    • removedInput schema / properties / range / format
      Removed value: -null
    • removedInput schema / properties / range / maxLength
      Removed value: -null
    • removedInput schema / properties / range / minLength
      Removed value: -null
    • removedInput schema / properties / spreadsheetId / def
      Removed value: -{
      -  "type": "string"
      -}
    • removedInput schema / properties / spreadsheetId / format
      Removed value: -null
    • removedInput schema / properties / spreadsheetId / maxLength
      Removed value: -null
    • removedInput schema / properties / spreadsheetId / minLength
      Removed value: -null
  2. Changed19 schema fields changedv1.10.1
    • removedInput schema / properties / borders / _cached
      Removed value: -null
    • removedInput schema / properties / borders / _def
      Removed value: -{
      -  "catchall": {
      -    "_def": {
      -      "typeName": "ZodNever"
      -    },
      -    "~standard": {
      -      "vendor": "zod",
      -      "version": 1
      -    }
      -  },
      -  "typeName": "ZodObject",
      -  "unknownKeys": "strip"
      -}
    • addedInput schema / properties / borders / def
      Added value: +{
      +  "shape": {
      +    "bottom": {
      +      "def": {
      +        "innerType": {
      +          "def": {
      +            "shape": {
      +              "color": {
      +                "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"
      +              },
      +              "style": {
      +                "def": {
      +                  "entries": {
      +                    "DASHED": "DASHED",
      +                    "DOTTED": "DOTTED",
      +                    "DOUBLE": "DOUBLE",
      +                    "NONE": "NONE",
      +                    "SOLID": "SOLID",
      +                    "SOLID_MEDIUM": "SOLID_MEDIUM",
      +                    "SOLID_THICK": "SOLID_THICK"
      +                  },
      +                  "type": "enum"
      +                },
      +                "enum": {
      +                  "DASHED": "DASHED",
      +                  "DOTTED": "DOTTED",
      +                  "DOUBLE": "DOUBLE",
      +                  "NONE": "NONE",
      +                  "SOLID": "SOLID",
      +                  "SOLID_MEDIUM": "SOLID_MEDIUM",
      +                  "SOLID_THICK": "SOLID_THICK"
      +                },
      +                "options": [
      +                  "NONE",
      +                  "SOLID",
      +                  "DASHED",
      +                  "DOTTED",
      +                  "SOLID_MEDIUM",
      +                  "SOLID_THICK",
      +                  "DOUBLE"
      +                ],
      +                "type": "enum"
      +              },
      +              "width": {
      +                "def": {
      +                  "innerType": {
      +                    "def": {
      +                      "checks": [
      +                        {}
      +                      ],
      +                      "type": "number"
      +                    },
      +                    "format": null,
      +                    "isFinite": true,
      +                    "isInt": false,
      +                    "maxValue": null,
      +                    "minValue": 0,
      +                    "type": "number"
      +                  },
      +                  "type": "optional"
      +                },
      +                "type": "optional"
      +              }
      +            },
      +            "type": "object"
      +          },
      +          "type": "object"
      +        },
      +        "type": "optional"
      +      },
      +      "type": "optional"
      +    },
      +    "innerHorizontal": {
      +      "def": {
      +        "innerType": {
      +          "def": {
      +            "shape": {
      +              "color": {
      +                "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"
      +              },
      +              "style": {
      +                "def": {
      +                  "entries": {
      +                    "DASHED": "DASHED",
      +                    "DOTTED": "DOTTED",
      +                    "DOUBLE": "DOUBLE",
      +                    "NONE": "NONE",
      +                    "SOLID": "SOLID",
      +                    "SOLID_MEDIUM": "SOLID_MEDIUM",
      +                    "SOLID_THICK": "SOLID_THICK"
      +                  },
      +                  "type": "enum"
      +                },
      +                "enum": {
      +                  "DASHED": "DASHED",
      +                  "DOTTED": "DOTTED",
      +                  "DOUBLE": "DOUBLE",
      +                  "NONE": "NONE",
      +                  "SOLID": "SOLID",
      +                  "SOLID_MEDIUM": "SOLID_MEDIUM",
      +                  "SOLID_THICK": "SOLID_THICK"
      +                },
      +                "options": [
      +                  "NONE",
      +                  "SOLID",
      +                  "DASHED",
      +                  "DOTTED",
      +                  "SOLID_MEDIUM",
      +                  "SOLID_THICK",
      +                  "DOUBLE"
      +                ],
      +                "type": "enum"
      +              },
      +              "width": {
      +                "def": {
      +                  "innerType": {
      +                    "def": {
      +                      "checks": [
      +                        {}
      +                      ],
      +                      "type": "number"
      +                    },
      +                    "format": null,
      +                    "isFinite": true,
      +                    "isInt": false,
      +                    "maxValue": null,
      +                    "minValue": 0,
      +                    "type": "number"
      +                  },
      +                  "type": "optional"
      +                },
      +                "type": "optional"
      +              }
      +            },
      +            "type": "object"
      +          },
      +          "type": "object"
      +        },
      +        "type": "optional"
      +      },
      +      "type": "optional"
      +    },
      +    "innerVertical": {
      +      "def": {
      +        "innerType": {
      +          "def": {
      +            "shape": {
      +              "color": {
      +                "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"
      +              },
      +              "style": {
      +                "def": {
      +                  "entries": {
      +                    "DASHED": "DASHED",
      +                    "DOTTED": "DOTTED",
      +                    "DOUBLE": "DOUBLE",
      +                    "NONE": "NONE",
      +                    "SOLID": "SOLID",
      +                    "SOLID_MEDIUM": "SOLID_MEDIUM",
      +                    "SOLID_THICK": "SOLID_THICK"
      +                  },
      +                  "type": "enum"
      +                },
      +                "enum": {
      +                  "DASHED": "DASHED",
      +                  "DOTTED": "DOTTED",
      +                  "DOUBLE": "DOUBLE",
      +                  "NONE": "NONE",
      +                  "SOLID": "SOLID",
      +                  "SOLID_MEDIUM": "SOLID_MEDIUM",
      +                  "SOLID_THICK": "SOLID_THICK"
      +                },
      +                "options": [
      +                  "NONE",
      +                  "SOLID",
      +                  "DASHED",
      +                  "DOTTED",
      +                  "SOLID_MEDIUM",
      +                  "SOLID_THICK",
      +                  "DOUBLE"
      +                ],
      +                "type": "enum"
      +              },
      +              "width": {
      +                "def": {
      +                  "innerType": {
      +                    "def": {
      +                      "checks": [
      +                        {}
      +                      ],
      +                      "type": "number"
      +                    },
      +                    "format": null,
      +                    "isFinite": true,
      +                    "isInt": false,
      +                    "maxValue": null,
      +                    "minValue": 0,
      +                    "type": "number"
      +                  },
      +                  "type": "optional"
      +                },
      +                "type": "optional"
      +              }
      +            },
      +            "type": "object"
      +          },
      +          "type": "object"
      +        },
      +        "type": "optional"
      +      },
      +      "type": "optional"
      +    },
      +    "left": {
      +      "def": {
      +        "innerType": {
      +          "def": {
      +            "shape": {
      +              "color": {
      +                "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"
      +              },
      +              "style": {
      +                "def": {
      +                  "entries": {
      +                    "DASHED": "DASHED",
      +                    "DOTTED": "DOTTED",
      +                    "DOUBLE": "DOUBLE",
      +                    "NONE": "NONE",
      +                    "SOLID": "SOLID",
      +                    "SOLID_MEDIUM": "SOLID_MEDIUM",
      +                    "SOLID_THICK": "SOLID_THICK"
      +                  },
      +                  "type": "enum"
      +                },
      +                "enum": {
      +                  "DASHED": "DASHED",
      +                  "DOTTED": "DOTTED",
      +                  "DOUBLE": "DOUBLE",
      +                  "NONE": "NONE",
      +                  "SOLID": "SOLID",
      +                  "SOLID_MEDIUM": "SOLID_MEDIUM",
      +                  "SOLID_THICK": "SOLID_THICK"
      +                },
      +                "options": [
      +                  "NONE",
      +                  "SOLID",
      +                  "DASHED",
      +                  "DOTTED",
      +                  "SOLID_MEDIUM",
      +                  "SOLID_THICK",
      +                  "DOUBLE"
      +                ],
      +                "type": "enum"
      +              },
      +              "width": {
      +                "def": {
      +                  "innerType": {
      +                    "def": {
      +                      "checks": [
      +                        {}
      +                      ],
      +                      "type": "number"
      +                    },
      +                    "format": null,
      +                    "isFinite": true,
      +                    "isInt": false,
      +                    "maxValue": null,
      +                    "minValue": 0,
      +                    "type": "number"
      +                  },
      +                  "type": "optional"
      +                },
      +                "type": "optional"
      +              }
      +            },
      +            "type": "object"
      +          },
      +          "type": "object"
      +        },
      +        "type": "optional"
      +      },
      +      "type": "optional"
      +    },
      +    "right": {
      +      "def": {
      +        "innerType": {
      +          "def": {
      +            "shape": {
      +              "color": {
      +                "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"
      +              },
      +              "style": {
      +                "def": {
      +                  "entries": {
      +                    "DASHED": "DASHED",
      +                    "DOTTED": "DOTTED",
      +                    "DOUBLE": "DOUBLE",
      +                    "NONE": "NONE",
      +                    "SOLID": "SOLID",
      +                    "SOLID_MEDIUM": "SOLID_MEDIUM",
      +                    "SOLID_THICK": "SOLID_THICK"
      +                  },
      +                  "type": "enum"
      +                },
      +                "enum": {
      +                  "DASHED": "DASHED",
      +                  "DOTTED": "DOTTED",
      +                  "DOUBLE": "DOUBLE",
      +                  "NONE": "NONE",
      +                  "SOLID": "SOLID",
      +                  "SOLID_MEDIUM": "SOLID_MEDIUM",
      +                  "SOLID_THICK": "SOLID_THICK"
      +                },
      +                "options": [
      +                  "NONE",
      +                  "SOLID",
      +                  "DASHED",
      +                  "DOTTED",
      +                  "SOLID_MEDIUM",
      +                  "SOLID_THICK",
      +                  "DOUBLE"
      +                ],
      +                "type": "enum"
      +              },
      +              "width": {
      +                "def": {
      +                  "innerType": {
      +                    "def": {
      +                      "checks": [
      +                        {}
      +                      ],
      +                      "type": "number"
      +                    },
      +                    "format": null,
      +                    "isFinite": true,
      +                    "isInt": false,
      +                    "maxValue": null,
      +                    "minValue": 0,
      +                    "type": "number"
      +                  },
      +                  "type": "optional"
      +                },
      +                "type": "optional"
      +              }
      +            },
      +            "type": "object"
      +          },
      +          "type": "object"
      +        },
      +        "type": "optional"
      +      },
      +      "type": "optional"
      +    },
      +    "top": {
      +      "def": {
      +        "innerType": {
      +          "def": {
      +            "shape": {
      +              "color": {
      +                "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"
      +              },
      +              "style": {
      +                "def": {
      +                  "entries": {
      +                    "DASHED": "DASHED",
      +                    "DOTTED": "DOTTED",
      +                    "DOUBLE": "DOUBLE",
      +                    "NONE": "NONE",
      +                    "SOLID": "SOLID",
      +                    "SOLID_MEDIUM": "SOLID_MEDIUM",
      +                    "SOLID_THICK": "SOLID_THICK"
      +                  },
      +                  "type": "enum"
      +                },
      +                "enum": {
      +                  "DASHED": "DASHED",
      +                  "DOTTED": "DOTTED",
      +                  "DOUBLE": "DOUBLE",
      +                  "NONE": "NONE",
      +                  "SOLID": "SOLID",
      +                  "SOLID_MEDIUM": "SOLID_MEDIUM",
      +                  "SOLID_THICK": "SOLID_THICK"
      +                },
      +                "options": [
      +                  "NONE",
      +                  "SOLID",
      +                  "DASHED",
      +                  "DOTTED",
      +                  "SOLID_MEDIUM",
      +                  "SOLID_THICK",
      +                  "DOUBLE"
      +                ],
      +                "type": "enum"
      +              },
      +              "width": {
      +                "def": {
      +                  "innerType": {
      +                    "def": {
      +                      "checks": [
      +                        {}
      +                      ],
      +                      "type": "number"
      +                    },
      +                    "format": null,
      +                    "isFinite": true,
      +                    "isInt": false,
      +                    "maxValue": null,
      +                    "minValue": 0,
      +                    "type": "number"
      +                  },
      +                  "type": "optional"
      +                },
      +                "type": "optional"
      +              }
      +            },
      +            "type": "object"
      +          },
      +          "type": "object"
      +        },
      +        "type": "optional"
      +      },
      +      "type": "optional"
      +    }
      +  },
      +  "type": "object"
      +}
    • addedInput schema / properties / borders / type
      Added value: +"object"
    • removedInput schema / properties / borders / ~standard
      Removed value: -{
      -  "vendor": "zod",
      -  "version": 1
      -}
    • removedInput schema / properties / range / _def
      Removed value: -{
      -  "checks": [],
      -  "coerce": false,
      -  "typeName": "ZodString"
      -}
    • addedInput schema / properties / range / def
      Added value: +{
      +  "type": "string"
      +}
    • addedInput schema / properties / range / format
      Added value: +null
    • addedInput schema / properties / range / maxLength
      Added value: +null
    • addedInput schema / properties / range / minLength
      Added value: +null
    • addedInput schema / properties / range / type
      Added value: +"string"
    • removedInput schema / properties / range / ~standard
      Removed value: -{
      -  "vendor": "zod",
      -  "version": 1
      -}
    • removedInput schema / properties / spreadsheetId / _def
      Removed value: -{
      -  "checks": [],
      -  "coerce": false,
      -  "typeName": "ZodString"
      -}
    • addedInput schema / properties / spreadsheetId / def
      Added value: +{
      +  "type": "string"
      +}
    • addedInput schema / properties / spreadsheetId / format
      Added value: +null
    • addedInput schema / properties / spreadsheetId / maxLength
      Added value: +null
    • addedInput schema / properties / spreadsheetId / minLength
      Added value: +null
    • addedInput schema / properties / spreadsheetId / type
      Added value: +"string"
    • removedInput schema / properties / spreadsheetId / ~standard
      Removed value: -{
      -  "vendor": "zod",
      -  "version": 1
      -}
  3. First observedv1.0.0

TDQS

C2.6/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With annotations idempotentHint:true and destructiveHint:false already declaring the safety profile, the description adds no behavioral context beyond what's in the annotation. It doesn't disclose that calling this tool overwrites existing border formatting on the range, or that style:NONE removes borders, which is critical behavioral knowledge for a tool that does full replacement of border settings.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness3/5

Is the description appropriately sized, front-loaded, and free of redundancy?

At nine words, there's no wasted language and the core action is front-loaded. However, it's so minimal that it reads as merely a grammatical expansion of the tool name rather than a thoughtfully concise description. Concise writing is good, but this egregiously under-uses the available space.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a parameter with complex nested object semantics and no output schema, the description is inadequate. It fails to explain border replacement/overwrite semantics, how to remove borders, the color format specification, or the fact that the borders parameter is flexible. The sibling sheets_get_border_map could have been cross-referenced to complete the picture.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters2/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

With 0% schema description coverage, the description was responsible for compensating, but it provides zero parameter guidance. The 'range' parameter's format (A1 notation) is never mentioned, and the borders object's per-side structure (top/left/right/bottom/innerHorizontal/innerVertical) and color semantics are left entirely to schema inference. The RGBA color object format and width constraints are particularly non-obvious without documentation.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description uses a specific verb+resource structure ('Update borders of cells in a Google Sheet') that clearly conveys what the tool does. It doesn't explicitly distinguish itself from potentially overlapping siblings like sheets_format_cells (which might also touch borders), but the intent is immediately apparent.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

There is no guidance on when to use this tool versus alternatives such as sheets_format_cells, sheets_get_border_map, or batch operations. No preconditions (e.g., spreadsheet permissions), range format expectations, or notes about how it differs from the format_cells siblings are provided. The agent must infer usage entirely from the name and schema.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Latest Blog Posts

MCP directory API

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