Google Sheets MCP Server

Returns the spreadsheet metadata and structure at the given ID.

Returns a range of values (cell data) from a spreadsheet.

Returns the developer metadata with the specified ID.

Returns the spreadsheet at the given ID using a data filter.

Returns all developer metadata matching the specified DataFilter.

Returns one or more ranges of values from a spreadsheet.

Returns one or more ranges of values that match the specified data filters.

A sheet in a spreadsheet, containing data, properties, and formatting rules.

Data and formatting information for a specific cell within a sheet. This object is nested within the Sheet resource.

A pivot table configuration, defining rows, columns, values, and source data.

A chart embedded in a sheet, defining visualization properties and data source.

The format of a run of text in a cell, including font, size, and styling.

Represents a color in the RGBA color space, used for formatting.

A color value, which can be defined by RGB or a theme color.

An external or local reference.

Overall properties and settings of a spreadsheet, including title, locale, and calculation rules.

A defined range of cells with a specific name and ID.

Information about an external data source (e.g., BigQuery, Looker) connected to the spreadsheet.

Settings to control how circular dependencies are resolved with iterative calculation.

The format of a cell.

The number format of a cell.

The borders of the cell.

Creates a spreadsheet.

Applies one or more updates to the spreadsheet (structure/metadata).

Sets values in a range of a spreadsheet.

Appends values to a spreadsheet.

Clears values from a spreadsheet.

Copies a single sheet from a spreadsheet to another spreadsheet.

Clears one or more ranges of values from a spreadsheet.

Clears one or more ranges of values from a spreadsheet using a data filter.

Sets values in one or more ranges of a spreadsheet.

Sets values in one or more ranges of a spreadsheet using a data filter.