sheets_get_border_map
Returns a visual map of cell borders for a range, using compact grids to show top/bottom/left/right border styles. Resolves ambiguity between adjacent cells' borders.
Instructions
Returns a visual tabular map of borders for a range. Instead of per-cell JSON with 4 separate border objects, returns compact grids showing which cells have top/bottom/left/right borders and their styles. Solves the ambiguity between "right border of cell N" vs "left border of cell N+1". Output: a horizontal-lines grid and a vertical-lines grid, each as a 2D array of line styles. Set includeStyle:true to include color and width details (larger output).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | Range with sheet prefix, e.g. "Sheet1!A1:F10". Sheet name is required to resolve the range correctly. | |
| includeStyle | No | Default: false. When true, each border line includes color and width details. When false, only the style name (SOLID, DASHED, etc.) is shown — more compact. | |
| spreadsheetId | Yes | The ID of the spreadsheet (found in the URL after /d/) |