src/tools/sheets/README.md

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