Google Sheets

Create a new Google Sheets spreadsheet. Optionally specify sheet/tab names, locale, and timezone. Returns the spreadsheet ID and URL.

Get spreadsheet metadata — title, sheets list with properties (ID, title, row/column count, frozen rows), and optionally cell data for specific ranges.

Read cell values from a range using A1 notation (e.g. "Sheet1!A1:C10", "A1:Z", "Sheet1"). Returns a 2D array of values.

Read values from multiple ranges at once. More efficient than multiple gs_read_values calls.

Write values to a range. Values are provided as a 2D array (rows of columns). By default uses USER_ENTERED input (formulas and formatting are parsed).

Append rows after the last row with data in the specified range. Automatically finds the end of existing data and adds new rows below.

Clear all values in a range. Only clears values — formatting, data validation, and other properties are preserved.

Write values to multiple ranges at once. More efficient than multiple gs_write_values calls.

Add a new sheet/tab to a spreadsheet. Optionally set row/column count and tab color.

Delete a sheet/tab from a spreadsheet. Use gs_get_spreadsheet to find the sheet_id first. This action is irreversible.

Rename a sheet/tab in a spreadsheet.

Copy a sheet/tab to another spreadsheet. The authenticated user must have edit access to the destination spreadsheet.

Duplicate a sheet/tab within the same spreadsheet. Creates a copy with an optional new name.

Apply formatting to cells in a range — bold, italic, font size, colors, alignment, number format, and more. Uses 0-based row/column indices.

Merge cells in a range. All values except the top-left cell are cleared.

Unmerge previously merged cells in a range.

Auto-resize columns or rows to fit their content.

Sort a range of data by a specific column. Uses 0-based indices for the range and sort column.

Find and replace text across one sheet or all sheets. Supports case-sensitive and regex search.

Set or clear a basic filter (auto-filter) on a sheet. When set, filter dropdowns appear in column headers.

Protect a range of cells from editing. Optionally allow specific editors or show a warning instead of blocking.

Add a chart to a sheet. Specify chart type, data range, and anchor position. The chart is overlaid on the sheet.

Send a raw batchUpdate request with one or more request objects. Use this for advanced operations not covered by other tools (e.g. conditional formatting, data validation, dimension properties). See Google Sheets API batchUpdate documentation for available request types.