Set cell borders
set_bordersSet borders on a spreadsheet range by choosing styles and colors for outer edges and inner grid lines; use NONE to remove a side.
Instructions
Draws borders around and/or inside a grid range. top/bottom/left/right are the range's outer edges; inner_horizontal/inner_vertical are the grid lines between cells inside it. Each side takes {style, color?} — styles SOLID, SOLID_MEDIUM, SOLID_THICK, DOTTED, DASHED, DOUBLE, or NONE to remove that side's border. Only the provided sides change; at least one is required. Colors are "#RRGGBB" hex (default black).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | Border line: {style, color?}. | |
| left | No | Border line: {style, color?}. | |
| range | Yes | Cell rectangle in grid coordinates: rows 1-10 × columns A-B = {start_row_index:0, end_row_index:10, start_column_index:0, end_column_index:2}. | |
| right | No | Border line: {style, color?}. | |
| bottom | No | Border line: {style, color?}. | |
| inner_vertical | No | Vertical lines between columns inside the range. | |
| spreadsheet_id | Yes | The spreadsheet id — the long id from the URL (docs.google.com/spreadsheets/d/<spreadsheetId>/edit) or from create_spreadsheet / search_spreadsheets output. | |
| inner_horizontal | No | Horizontal lines between rows inside the range. |