Sheet MCP Server

A specialized Google Sheets integration server that allows the LLM to read, write, and manage spreadsheet data in real-time. This server supports

Local serverstdioPython

What is the Sheet MCP Server?

A specialized Google Sheets integration server that allows the LLM to read, write, and manage spreadsheet data in real-time. This server supports cell-level

What it actually does

A powerful, comprehensive Model Context Protocol (MCP) server that enables AI agents to interact directly with Google Sheets. Perform everything from simple cell updates to complex data analysis and visualization using natural language.

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
read_rangeRetrieves values from a specific rectangular range (e.g., A1:C10).
read_batch_rangesRetrieves values from multiple non-contiguous ranges in one call.
read_sheetFetches every single populated row and column from the worksheet.
get_cell_valueRetrieves the value of a single specific cell.
set_cell_valueUpdates the value of a single specific cell.
update_row_by_indexUpdates an entire row with new data based on the row number.
update_or_insert_columnUpdates or inserts values into a specific column.
append_data_batch_in_rowsAppends multiple rows of data, automatically finding the end if needed.
clear_rangeDeletes all content within a specified range of cells.
list_sheetsRetrieves a list of all worksheet titles in the current spreadsheet.
create_sheetCreates a new worksheet with optional row/column size.
delete_sheetDeletes an existing worksheet by its name.
rename_sheetUpdates the title of an existing worksheet.
set_text_styleSets bold, italic, and font size for a range.

Configuration

VariableDescriptionRequired
SERVICE_FILE_PATHFilesystem location the server is allowed to use.Optional

Example prompts to try

  • “Use Sheet to read range.”
  • “Use Sheet to read batch ranges.”
  • “Use Sheet to read sheet.”

Frequently asked questions

A specialized Google Sheets integration server that allows the LLM to read, write, and manage spreadsheet data in real-time. This server supports cell-level Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.