How do I install the mcp google sheets mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

The recorded environment keys are `SERVICE_ACCOUNT_PATH`, `ENABLED_TOOLS`, `DRIVE_FOLDER_ID`, `CREDENTIALS_CONFIG`, `THIS_IS_THE_FOLDER_ID`, `CREDENTIALS_PATH`, `TOKEN_PATH`. Keep credentials outside committed files and confirm the configuration required by your installed version.

SSyncDev

Start a project

MCP Google Sheets MCP Server

`mcp-google-sheets` is a Python-based MCP server that acts as a bridge between any MCP-compatible client (like Claude Desktop) and the Google Sheets

Local serverstdioPython

What is the MCP Google Sheets MCP Server?

mcp-google-sheets is a Python-based MCP server that acts as a bridge between any MCP-compatible client (like Claude Desktop) and the Google Sheets API. It allows

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.

Tool	What it does
get_sheet_data	get_sheet_formulas
update_cells	Write to spreadsheets
list_spreadsheets	rename_sheet
list_sheets	Navigate tabs
add_columns	add_rows
batch_update	batch_update_cells
copy_sheet	create_sheet
create_spreadsheet	find_in_spreadsheet
get_multiple_sheet_data	get_multiple_spreadsheet_summary
list_folders	list_sheets
search_spreadsheets	share_spreadsheet

How to install the MCP Google Sheets MCP Server

{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": [
        "mcp-google-sheets@latest",
        "--include-tools",
        "get_sheet_data,update_cells,list_spreadsheets,list_sheets"
      ],
      "env": {
        "SERVICE_ACCOUNT_PATH": "/path/to/credentials.json"
      }
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

Variable	Description	Required
SERVICE_ACCOUNT_PATH	Declared in the maintainer’s client configuration.	Check documentation

Frequently asked questions

`mcp-google-sheets` is a Python-based MCP server that acts as a bridge between any MCP-compatible client (like Claude Desktop) and the Google Sheets API. It allows Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.

Alternatives to the MCP Google Sheets MCP Server

Filesystem

Official

Read, search and edit files inside allowed directories with the Model Context Protocol reference Filesystem server.

File Systems & StorageTypeScript★ 63.0k

Context7

Official

Retrieve version-aware library documentation and code examples with Context7 MCP, using resolve-library-id and query-docs.

Documentation & API ReferencesRemoteTypeScript★ 32.0k

Feishu

All-in-one Feishu/Lark MCP for Claude Code & Codex. 84 tools, 3 auth layers, send-as-user.

Developer ToolsPython

Valyu MCP Js

MCP server implementation for Valyu API

Developer Tools

Hyperiux Vault

150+ effects in total - 50+ free and open source, 100+ pro effects available with a Pro subscription. The CLI installs source code directly into your project - you own what you install.