Mcp Gsheets
Connects Claude to the Google Sheets API with full read/write access and batch operations. You get all the usual spreadsheet actions: read and update cells, format ranges, create charts, apply conditional formatting. Authentication works three ways: point to a service account JSON file, pass the credentials as an environment variable, or just provide the private key and email directly. Built in TypeScript with stdio transport, so it runs via npx without installation. Useful when you need Claude to analyze data in sheets, generate reports, or automate spreadsheet tasks without copying data back and forth manually.
- GitHub stars
- 104
- tools
- 42
- auth
- Secret needed
- transport
- STDIO
- env vars
- 5
- last updated
- Nov 6, 2026
Tools
42 toolsPublic tool metadata for what this MCP can expose to an agent.
sheets_get_valuesRead cell values from a single range
Read cell values from a single range
No parameter schema in public metadata yet.
sheets_batch_get_valuesRead cell values from multiple ranges in one request
Read cell values from multiple ranges in one request
No parameter schema in public metadata yet.
sheets_get_metadataGet spreadsheet metadata: title, locale, sheets list with IDs, row/column counts
Get spreadsheet metadata: title, locale, sheets list with IDs, row/column counts
No parameter schema in public metadata yet.
sheets_check_accessVerify that the service account can access a spreadsheet
Verify that the service account can access a spreadsheet
No parameter schema in public metadata yet.
sheets_update_valuesWrite values to a single range (overwrites existing content)
Write values to a single range (overwrites existing content)
No parameter schema in public metadata yet.
sheets_batch_update_valuesWrite values to multiple ranges in one request
Write values to multiple ranges in one request
No parameter schema in public metadata yet.
sheets_append_valuesAppend rows after the last row of an existing table
Append rows after the last row of an existing table
No parameter schema in public metadata yet.
sheets_clear_valuesClear all values in a range (preserves formatting)
Clear all values in a range (preserves formatting)
No parameter schema in public metadata yet.
sheets_insert_rowsInsert blank or pre-filled rows at a specific position
Insert blank or pre-filled rows at a specific position
No parameter schema in public metadata yet.
sheets_delete_columnsDelete one or more columns using a full-column A1 range
Delete one or more columns using a full-column A1 range
No parameter schema in public metadata yet.
sheets_delete_rowsDelete one or more rows using a full-row A1 range
Delete one or more rows using a full-row A1 range
No parameter schema in public metadata yet.
sheets_insert_linkInsert a hyperlink formula into a cell
Insert a hyperlink formula into a cell
No parameter schema in public metadata yet.
sheets_insert_dateInsert a date/datetime value formatted correctly into a cell
Insert a date/datetime value formatted correctly into a cell
No parameter schema in public metadata yet.
sheets_create_spreadsheetCreate a new Google Sheets file
Create a new Google Sheets file
No parameter schema in public metadata yet.
sheets_insert_sheetAdd a new sheet tab to an existing spreadsheet
Add a new sheet tab to an existing spreadsheet
No parameter schema in public metadata yet.
sheets_delete_sheetRemove a sheet tab by its numeric sheet ID
Remove a sheet tab by its numeric sheet ID
No parameter schema in public metadata yet.
sheets_duplicate_sheetCopy a sheet within the same spreadsheet
Copy a sheet within the same spreadsheet
No parameter schema in public metadata yet.
sheets_copy_toCopy a sheet to a different spreadsheet
Copy a sheet to a different spreadsheet
No parameter schema in public metadata yet.
sheets_update_sheet_propertiesRename a sheet, change tab colour, toggle grid lines, etc.
Rename a sheet, change tab colour, toggle grid lines, etc.
No parameter schema in public metadata yet.
sheets_batch_delete_sheetsDelete multiple sheet tabs in one request
Delete multiple sheet tabs in one request
No parameter schema in public metadata yet.
sheets_format_cellsApply background colour, font style, alignment and number format to a range
Apply background colour, font style, alignment and number format to a range
No parameter schema in public metadata yet.
sheets_batch_format_cellsApply different formats to multiple ranges in one request
Apply different formats to multiple ranges in one request
No parameter schema in public metadata yet.
sheets_update_bordersSet or remove borders on a range
Set or remove borders on a range
No parameter schema in public metadata yet.
sheets_merge_cellsMerge a range of cells
Merge a range of cells
No parameter schema in public metadata yet.
sheets_unmerge_cellsUnmerge previously merged cells in a range
Unmerge previously merged cells in a range
No parameter schema in public metadata yet.
sheets_add_conditional_formattingAdd a conditional formatting rule (gradient or boolean) to a range
Add a conditional formatting rule (gradient or boolean) to a range
No parameter schema in public metadata yet.
sheets_add_tableCreate a native Google Sheets table with typed columns and optional dropdown values
Create a native Google Sheets table with typed columns and optional dropdown values
No parameter schema in public metadata yet.
sheets_update_tableUpdate an existing native Google Sheets table by table ID using an explicit field mask
Update an existing native Google Sheets table by table ID using an explicit field mask
No parameter schema in public metadata yet.
sheets_delete_tableDelete a native Google Sheets table by table ID
Delete a native Google Sheets table by table ID
No parameter schema in public metadata yet.
sheets_get_tablesRead native tables for a spreadsheet or a specific sheet
Read native tables for a spreadsheet or a specific sheet
No parameter schema in public metadata yet.
sheets_create_chartCreate a bar, line, pie, column or other chart on a sheet
Create a bar, line, pie, column or other chart on a sheet
No parameter schema in public metadata yet.
sheets_update_chartModify an existing chart's spec or position
Modify an existing chart's spec or position
No parameter schema in public metadata yet.
sheets_delete_chartRemove a chart from a spreadsheet
Remove a chart from a spreadsheet
No parameter schema in public metadata yet.
sheets_get_merged_cellsReturn all merged cell ranges for a sheet, with A1 notation and raw GridRange coordinates
Return all merged cell ranges for a sheet, with A1 notation and raw GridRange coordinates
No parameter schema in public metadata yet.
sheets_get_sheet_dimensionsReturn column widths, row heights, frozen column/row counts, and hidden flags for every column and row
Return column widths, row heights, frozen column/row counts, and hidden flags for every column and row
No parameter schema in public metadata yet.
sheets_get_sheet_formattingRead raw cell formatting for a range without returning cell values
Read raw cell formatting for a range without returning cell values
No parameter schema in public metadata yet.
sheets_get_conditional_formattingRead all conditional formatting rules and banded ranges defined on a sheet
Read all conditional formatting rules and banded ranges defined on a sheet
No parameter schema in public metadata yet.
sheets_get_sheet_structureLightweight structural metadata only, no per-cell data
Lightweight structural metadata only, no per-cell data
No parameter schema in public metadata yet.
sheets_get_formatting_compactRead cell formatting for a range and return it as compact A1Range to format pairs (run-length encoded)
Read cell formatting for a range and return it as compact A1Range to format pairs (run-length encoded)
No parameter schema in public metadata yet.
sheets_get_full_sheet_snapshotReturns all structural and formatting metadata in a single API call
Returns all structural and formatting metadata in a single API call
No parameter schema in public metadata yet.
sheets_get_basic_filterRead the Basic Filter (AutoFilter) configuration for a sheet
Read the Basic Filter (AutoFilter) configuration for a sheet
No parameter schema in public metadata yet.
sheets_get_data_validationRead data validation rules from a sheet or range
Read data validation rules from a sheet or range
No parameter schema in public metadata yet.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageConfiguration
GOOGLE_PROJECT_ID*Google Cloud project ID
GOOGLE_APPLICATION_CREDENTIALSPath to service account key JSON file (auth method 1)
GOOGLE_SERVICE_ACCOUNT_KEYsecretService account key as JSON string (auth method 2)
GOOGLE_PRIVATE_KEYsecretService account private key in PEM format (auth method 3)
GOOGLE_CLIENT_EMAILService account email (auth method 3)
Readme
MCP Google Sheets Server
A Model Context Protocol (MCP) server for Google Sheets API integration. Enables reading, writing, and managing Google Sheets documents directly from your MCP client (e.g., Claude Code, Claude Desktop, Cursor, etc.).
Key Features
Details
- Repository
- github.com/freema/mcp-gsheets
- Category
- Data & Analytics
- Package
mcp-gsheets- Transport
- STDIO
- Auth
- Required
- Registry
- MCP registry, active
More from freema
Related Data & Analytics MCP servers
View all
ClariLayerclarilayer/clarilayerIndividual-analyst context layer: recall, remember, and reconcile your data and engineering context.71stars
BoardGameGeek MCP Serverkkjdaniel/bgg-mcpBoardGameGeek MCP server providing access to BGG API data through standardized tools59stars
Saga Mcpspranab/saga-mcpJira-like project tracker for AI agents with SQLite, full task hierarchy, and dashboard42stars
Alive Analysiswith-geun/alive-analysisQuery alive-analysis history from any AI client. Tools: list, get, search, dashboard export.42stars