Advertise
MCP.so
Sign In

MCP Google Sheets Server

@freema

Repository

Basic information

Category

Other

License

MIT license

Transports

stdio

Author

freema

About MCP Google Sheets Server

MCP server for Google Sheets - Read, write and manipulate spreadsheets through Claude Desktop

#nodejs#automation#typescript#mcp#google-sheets-api

MCP Google Sheets Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "node",
      "args": [
        "/absolute/path/to/mcp-gsheets/dist/index.js"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "",
        "GOOGLE_APPLICATION_CREDENTIALS": ""
      }
    }
  }
}

MCP Google Sheets Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is MCP Google Sheets Server?

MCP Google Sheets Server is a Model Context Protocol (MCP) server that integrates the Google Sheets API directly into MCP clients such as Claude Desktop. It enables reading, writing, and managing Google Sheets documents programmatically. Designed for developers and users who need to control spreadsheets via natural language or automation in an MCP environment.

How to use MCP Google Sheets Server?

Requires Node.js 18+, a Google Cloud project with the Sheets API enabled, and a service account JSON key. Install via git clone, then run npm install and npm run build. Use the interactive setup script (npm run setup) or manually configure your MCP client (e.g., Claude Desktop) by adding the server configuration with absolute paths to the built script and environment variables for GOOGLE_PROJECT_ID and GOOGLE_APPLICATION_CREDENTIALS. After configuration, restart your MCP client.

Key features of MCP Google Sheets Server

  • Read cell values, ranges, and metadata from spreadsheets
  • Write, update, append, and clear cell data
  • Add, delete, duplicate, and copy sheets
  • Format cells with colors, fonts, alignment, and borders
  • Merge and unmerge cells; add conditional formatting rules

Use cases of MCP Google Sheets Server

  • Automatically populate a spreadsheet from chat prompts
  • Read and summarize spreadsheet data in natural language
  • Manage sheet structure (add/delete sheets) from an MCP client
  • Apply consistent formatting across multiple ranges
  • Check permissions before performing operations

Frequently asked questions

1

What are the prerequisites?

Node.js v18 or higher, a Google Cloud project with the Sheets API enabled, and a service account JSON key file.

2

How do I authenticate with Google Sheets?

Create a service account in Google Cloud Console, download its JSON key, and share your spreadsheet with the service account email (Editor permissions). Set the `GOOGLE_APPLICATION_CREDENTIALS` environment variable to the absolute path of that key.

3

How do I find a spreadsheet ID?

The spreadsheet ID is the long string in the sheet’s URL: `https://docs.google.com/spreadsheets/d/[SPREADSHEET_ID]/edit`.

4

What tools does MCP Google Sheets Server provide?

It offers tools for reading data (`sheets_get_values`, `sheets_batch_get_values`, `sheets_get_metadata`, `sheets_check_access`), writing data (`sheets_update_values`, `sheets_batch_update_values`, `sheets_append_values`, `sheets_clear_values`), sheet management (`sheets_insert_sheet`, `sheets_delete_sheet`, `sheets_duplicate_sheet`, `sheets_copy_to`, `sheets_update_sheet_properties`), and cell formatting (`sheets_format_cells`, `sheets_update_borders`, `sheets_merge_cells`, `sheets_unmerge_cells`, `sheets_add_conditional_formatting`).

5

How can I debug connection issues?

Ensure you are using the built version (`dist/index.js`), that the Node.js path in your MCP client config is correct, and check the client logs. You can also run `npm run inspector` to debug the MCP server.

Comments

More Other MCP servers

P

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

Glasswarp

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K
Advertise