Lists the tabs of a spreadsheet with their dimensions and sheetId, plus the file title.

Reads the values of a range in A1 notation. Passing only a tab name (e.g. 'Sheet1') returns all data in that tab.

Finds rows matching one or more criteria and returns only those, along with their absolute row numbers. Prefer this over read_range on long tables: it avoids pulling hundreds of irrelevant rows into the conversation. The row numbers it returns can be passed straight to update_row.

Changes the value of a single cell. Prefer this over write_range when the target is one cell: it cannot touch anything around it by accident.

Modifies only the named columns of an existing row, leaving every other column untouched. This is the right tool for changing a status or fixing a field in a register: unlike write_range it does not overwrite the whole row. The row is identified either by number (from find_rows) or by matching a value in a column.

Overwrites the cells of a range with the given values. Warning: existing data in that range is lost. To add rows at the end use append_rows; to change a field in an existing record use update_row.

Adds rows after the last occupied row of the given table. This is the safe way to insert new data without touching what is already there.

Clears the values of a range while leaving formatting intact. Destructive operation.

Creates a new spreadsheet in the user's Drive and returns its ID and URL.

Adds a new tab to an existing spreadsheet.

Renames an existing tab. Formulas referencing it are updated by Google automatically.

Permanently deletes a tab and all its contents. Not reversible from this server: the only recovery is Google Sheets' version history. Requires confirm=true, and explicit user confirmation should be obtained before calling it.