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

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

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.

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

der die das – German noun genders (Lingviko)

Lingviko

The article (der, die, das) of 90,000 German nouns, compounds included, plus a checker that finds wrong articles in German text (“mit der Zug” → dem). Uses dictionary data, not AI guessing. Free, no login.

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K
Advertise