Sheets

Get a Google Sheets spreadsheet's metadata, sheets, and named ranges.

Read cell values from a range using A1 notation (e.g. 'Sheet1!A1:D10').

Read cell values from multiple ranges in a single request.

Create a new Google Sheets spreadsheet.

Write cell values to a range using A1 notation. Overwrites existing data in the range.

Append rows after the last row of data in a range. Ideal for adding new records.

Clear all values from a range without changing formatting.

Clear values from multiple ranges in a single request.

Add a new sheet (tab) to a spreadsheet.

Delete a sheet (tab) from a spreadsheet by its sheet ID.

Duplicate an existing sheet within the same spreadsheet.

Update sheet properties like title, tab color, hidden, or frozen rows/columns.

Find and replace text across a sheet or range.

Sort a range of data by one or more columns.

Insert rows or columns into a sheet.

Delete rows or columns from a sheet.

Merge a range of cells together.

Unmerge previously merged cells.

Add an embedded chart (bar, line, pie, etc.) to a sheet.

Add a conditional formatting rule to a range of cells.

Set data validation rules on a range (dropdown lists, number ranges, etc.).

Auto-resize rows or columns to fit their content.

Copy a sheet from one spreadsheet to another.

Execute one or more structural mutation actions on a spreadsheet. Supports all 47 Google Sheets API batchUpdate actions. Use this for advanced operations not covered by individual tools.