MCP Gsheets
UnclaimedMCP server for Google Sheets - Read, write and manipulate spreadsheets through Claude Desktop
Install
claude mcp add mcp-gsheets npx mcp-gsheets@latestSet up this server
More in Automation
Browse the full directoryUnclaimed listing
Is this your MCP server?
This listing was auto-indexed from the public record. Claim it to edit the page, set compatibility and unlock growth tools. Takes under two minutes.
Claim this serverSecurity profile
Claimed and verified servers get a weekly static scan that shows what the code can reach: external services, environment variables, shell commands, agent configuration folders, plus any dependencies with known advisories. Claim this listing to get one. How the security profile works
40 of 40 tools
Documented tools (40)
From project documentation. A server handshake does not verify each tool’s description or behavior.
sheets_add_conditional_formatting
Add a conditional formatting rule (gradient or boolean) to a range
sheets_add_table
Create a native Google Sheets table with typed columns and optional dropdown values
sheets_append_values
Append rows after the last row of an existing table. Default insertDataOption is OVERWRITE — set INSERTROWS to push existing rows down
sheets_batch_delete_sheets
Delete multiple sheet tabs in one request
sheets_batch_format_cells
Apply different formats to multiple ranges in one request
sheets_batch_get_values
Read cell values from multiple ranges in one request
sheets_batch_update_values
Write values to multiple ranges in one request
sheets_check_access
Verify that the service account can access a spreadsheet
sheets_clear_values
Clear all values in a range (preserves formatting)
sheets_copy_to
Copy a sheet to a different spreadsheet
sheets_create_chart
Create a bar, line, pie, column or other chart on a sheet
sheets_create_spreadsheet
Create a new Google Sheets file
sheets_delete_chart
Remove a chart from a spreadsheet
sheets_delete_columns
Delete one or more columns using a full-column A1 range
sheets_delete_rows
Delete one or more rows using a full-row A1 range
sheets_delete_sheet
Remove a sheet tab by its numeric sheet ID
sheets_delete_table
Delete a native Google Sheets table by table ID
sheets_duplicate_sheet
Copy a sheet within the same spreadsheet
sheets_format_cells
Apply background colour, font style, alignment and number format to a range
sheets_get_conditional_formatting
Read all conditional formatting rules and banded (alternating-colour) ranges defined on a sheet
sheets_get_formatting_compact
Read cell formatting for a range and return it as compact A1Range→format pairs (run-length encoded). Identical adjacent cells are collapsed into rectangular ranges — reduces output by 90 %+ compared to per-cell data
sheets_get_full_sheet_snapshot
Master one-shot tool — returns all structural and formatting metadata (merges, dimensions, conditional formatting, and optionally cell formatting) in a single API call. Supports fields filter and compactMode to limit response size
sheets_get_merged_cells
Return all merged cell ranges for a sheet, with A1 notation and raw GridRange coordinates
sheets_get_metadata
Get spreadsheet metadata: title, locale, sheets list with IDs, row/column counts
sheets_get_sheet_dimensions
Return column widths, row heights, frozen column/row counts, and hidden flags for every column and row
sheets_get_sheet_formatting
Read raw cell formatting (background colour, font, borders, alignment, number format) for a range without returning cell values
sheets_get_sheet_structure
Lightweight structural metadata only — no per-cell data. Returns dimensions, frozen rows/cols, tab colour, column widths, row heights, hidden columns/rows, and all merges in A1 notation. Single fast API call
sheets_get_tables
Read native tables for a spreadsheet or a specific sheet
sheets_get_values
Read cell values from a single range
sheets_insert_date
Insert a date/datetime value formatted correctly into a cell
sheets_insert_link
Insert a hyperlink formula into a cell
sheets_insert_rows
Insert blank or pre-filled rows at a specific position
sheets_insert_sheet
Add a new sheet tab to an existing spreadsheet
sheets_merge_cells
Merge a range of cells
sheets_unmerge_cells
Unmerge previously merged cells in a range
sheets_update_borders
Set or remove borders on a range (style, width, colour per side)
sheets_update_chart
Modify an existing chart's spec or position
sheets_update_sheet_properties
Rename a sheet, change tab colour, toggle grid lines, etc.
sheets_update_table
Update an existing native Google Sheets table by table ID using an explicit field mask
sheets_update_values
Write values to a single range (overwrites existing content)
Tool change history
FAQ
Questions about MCP Gsheets MCP Server
- How do I connect MCP Gsheets MCP Server to Claude?
- The listing records `claude mcp add mcp-gsheets npx mcp-gsheets@latest` as its setup step. Run it, then follow the repository's instructions for the client configuration; the listing names Claude Desktop, Claude Code, Cursor as compatible clients.
- Is MCP Gsheets MCP Server free?
- The listed licence is MIT. Check the upstream terms for permitted use and commercial requirements; a public repository does not by itself mean the software is free or open source. Connected APIs and hosted services may have separate charges.
- What can MCP Gsheets MCP Server do?
- MCP Gsheets MCP Server documents 40 tools to the agent, including sheets_add_conditional_formatting, sheets_add_table, sheets_append_values. The descriptions above come from project documentation. A live handshake does not test individual tool behavior.