get_spreadsheet_infoLABSCO SUMMARY
It formats and charts, not just reads and writes.
Most spreadsheet servers stop at cell values, which leaves the tedious half — header styling, column widths, building the chart — still manual. Having format_cells, set_column_width and create_chart in the same surface is what turns "put the numbers in" into a finished sheet. The service-account model is also the access control: nothing is reachable until you share it.
What it is
An MCP server covering Google Sheets end to end: reading and writing cells, formulas, sheet management, formatting, charts, sorting and sharing. It authenticates as a Google service account, so the agent only reaches the spreadsheets you share with it.
What you get
- Spreadsheets and sheets —
get_spreadsheet_info,create_spreadsheet,list_sheets,create_sheet,delete_sheet,rename_sheet,duplicate_sheet - Cells —
read_cells,write_cells(formulas included),batch_read,batch_write,append_rows,clear_cells,get_last_row - Rows and columns —
insert_rows,insert_columns,delete_rows,delete_columns - Formatting —
format_cellsfor bold, colours and alignment,set_column_width,merge_cells - Charts —
create_chartfor bar, line, pie, column, area and scatter, pluslist_chartsanddelete_chart - Data and sharing —
sort_range,find_replace,share_spreadsheet
Requirements
A Google Cloud project with the Sheets API and Drive API enabled, and a service account whose JSON key you save as credentials/service-account.json. Every spreadsheet you want reachable must be shared with the service account's email — a 403 almost always means you skipped that step. Install with uv sync, run uv run spreadsheet-mcp, and register the same command in Claude Desktop, Claude Code, Cursor or Gemini CLI. Package version 0.1.0. MIT.
Setup effort
Build from source — git clone https://github.com/dudegladiator/spreadsheet-mcp.git
USE CASES
01
Building a report sheet from scratch
Create the sheet, write headers and rows with formulas, style the header row, and add the chart.
02
Summarising data someone else maintains
Find where the data ends, read the range, and answer from it without exporting anything.
03
Appending results as they arrive
Add new rows at the end of the existing data rather than overwriting a range.
04
Cleaning up a messy sheet
Replace placeholder values throughout, sort by the column that matters, and widen the columns that are cut off.
27 tools
Listed in project docs. Your client may show a different list.
create_spreadsheetlist_sheetscreate_sheetdelete_sheetrename_sheetduplicate_sheetread_cellswrite_cellsbatch_readbatch_writeappend_rowsclear_cellsget_last_rowinsert_rowsinsert_columnsdelete_rowsdelete_columnsformat_cellsset_column_widthmerge_cellscreate_chartlist_chartsdelete_chartsort_rangefind_replaceshare_spreadsheetBEFORE YOU INSTALL
What to know first
Tools you get
27 tools named in the project's documentation.
Requires
uv on PATH
Where it runs
All 4 documented clients run the server on your machine.
INSTALLATION
Connect your client
You clone this one yourself.
Server setup
TERMINAL
git clone https://github.com/dudegladiator/spreadsheet-mcp.git
cd spreadsheet-mcp
uv syncIn Google Cloud, enable the Sheets API and the Drive API, create a service account, save its JSON key as credentials/service-account.json inside the clone, and share each spreadsheet with the service account's email
TERMINAL
uv run spreadsheet-mcpMCP Clients
Claude Desktop, Claude Code, Cursor, Gemini CLI
JSON
{
"mcpServers": {
"google-sheets": {
"command": "uv",
"args": [
"--directory",
"<YOUR_PATH_TO_SPREADSHEET_MCP>",
"run",
"spreadsheet-mcp"
]
}
}
}
