# Sheets

Tools for reading, writing, and managing Google Spreadsheets, including cell data operations, formatting, validation, sheet/tab management, and spreadsheet creation.

## Data

| Tool               | Description                                              |
| ------------------ | -------------------------------------------------------- |
| `readSpreadsheet`  | Reads data from a range in a spreadsheet                 |
| `writeSpreadsheet` | Writes data to a range, overwriting existing values      |
| `appendRows`       | Appends rows to the end of a sheet                       |
| `clearRange`       | Clears all cell values in a range without deleting cells |

## Formatting & Validation

| Tool                    | Description                                                             |
| ----------------------- | ----------------------------------------------------------------------- |
| `formatCells`           | Applies formatting (bold, colors, alignment) to a range, row, or column |
| `freezeRowsAndColumns`  | Pins rows and/or columns so they stay visible when scrolling            |
| `setDropdownValidation` | Adds a dropdown list to cells, restricting input to specified values    |

## Management

| Tool                 | Description                                            |
| -------------------- | ------------------------------------------------------ |
| `getSpreadsheetInfo` | Gets metadata about a spreadsheet including all sheets |
| `addSheet`           | Adds a new sheet (tab) to an existing spreadsheet      |
| `createSpreadsheet`  | Creates a new spreadsheet                              |
| `listSpreadsheets`   | Lists spreadsheets in your Drive                       |

## Comments

| Tool                   | Description                                                                 |
| ---------------------- | --------------------------------------------------------------------------- |
| `createSheetsComment`  | Creates a new spreadsheet comment, optionally with a direct cell/range link |
| `createSheetsCellNote` | Creates or replaces a native cell note attached to a cell or range          |
| `listSheetsComments`   | Lists spreadsheet comments with optional sheet/row/cell/range filters       |
| `getSheetsComment`     | Gets a specific spreadsheet comment thread                                  |
| `replyToSheetsComment` | Adds a reply to an existing spreadsheet comment thread                      |
| `resolveSheetsComment` | Marks a spreadsheet comment as resolved                                     |
| `deleteSheetsComment`  | Permanently deletes a spreadsheet comment thread                            |
