# 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                       |