mcp-gsheetsTools Reference
sheets_update_borders
Add or modify cell borders
sheets_update_borders
Add or modify borders for a range of cells.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The spreadsheet ID |
range | string | Yes | A1 notation range |
borders | object | Yes | Border configuration |
Example
{
"tool": "sheets_update_borders",
"arguments": {
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"range": "Sheet1!A1:D10",
"borders": {
"top": { "style": "SOLID", "color": { "red": 0, "green": 0, "blue": 0 } },
"bottom": { "style": "SOLID" },
"left": { "style": "SOLID" },
"right": { "style": "SOLID" }
}
}
}Border Styles
DOTTED, DASHED, SOLID, SOLID_MEDIUM, SOLID_THICK, DOUBLE