MCP Gsheets
未认领MCP server for Google Sheets - Read, write and manipulate spreadsheets through Claude Desktop
安装
claude mcp add mcp-gsheets npx mcp-gsheets@latest工具（40 个）
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)