Google MCP Server

Google Sheets API -- simple interface to read/write data and manage sheets

Local serverstdioTypeScript

What is the Google MCP Server?

Google Sheets API -- simple interface to read/write data and manage sheets

The short version

The following examples are meant to give you an idea of just some of the things you can do

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.

ToolWhat it does
cellbased API - read, write, bulk-updates, formatting
rowbased API - read, update, delete (based on the old v3 row-based calls)
exportdownload sheet/docs in various formats

How to install the Google MCP Server

{
  "mcpServers": {
    "google-spreadsheet": {
      "command": "npx",
      "args": ["-y", "google-spreadsheet"],
      "env": {
        "GOOGLE_PRIVATE_KEY": "your-value"
      }
    }
  }
}

Add to claude_desktop_config.json, then restart Claude Desktop.

Configuration

VariableDescriptionRequired
GOOGLE_PRIVATE_KEYCredential the server authenticates with.Yes

Example prompts to try

  • “Use Google to cell.”
  • “Use Google to row.”
  • “Use Google to export.”

Frequently asked questions

Google Sheets API -- simple interface to read/write data and manage sheets Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.