google-sheets-mcp

Google Sheets MCP Server 📊🤖 JavaScript-based implementation.

101 stars JavaScriptServers & Infrastructure Updated Nov 2, 2025

Documentation

Google Sheets MCP

A Model Context Protocol (MCP) connector for Google Sheets that allows AI agents to interact with spreadsheets directly.

Demo

https://github.com/user-attachments/assets/cc4729d9-4e6e-437b-848b-6da9a09418c3

Setup

1. Clone this repository:

bash

git clone https://github.com/mkummer225/google-sheets-mcp
cd google-sheets-mcp

2. Install dependencies:

`npm install`

3. Build:

`npm run build`

4. Create OAuth credentials in Google Cloud Platform:

5. Start the MCP server (you'll automatically be prompted to authenticate/re-authenticate your Google account when necessary):

`npm run start`

Usage

Sample config:

json

{
    "mcpServers": {
    "google-sheets-mcp": {
      "command": "node",
      "args": [
        "/{path_to_dir}/google-sheets-mcp/dist/index.js"
      ]
    }
  }
}

Then you should be able to simply specify your spreadsheetId or ask your agent to create a new one for you.

Available Actions

Action	Description
`refresh_auth`	Re-authenticate your Google Account when credentials expire
`list_sheets`	List all sheets/tabs in a Google Spreadsheet
`create_sheet`	Create a new sheet/tab in a Google Spreadsheet
`create_spreadsheet`	Create a new Google Spreadsheet
`read_all_from_sheet`	Read all data from a specified sheet
`read_headings`	Read the column headings from a sheet
`read_rows`	Read specific rows from a sheet
`read_columns`	Read specific columns from a sheet
`edit_cell`	Edit a single cell in a sheet
`edit_row`	Edit an entire row in a sheet
`edit_column`	Edit an entire column in a sheet
`insert_row`	Insert a new row at specified position
`insert_column`	Insert a new column at specified position
`rename_sheet`	Rename a sheet/tab in a spreadsheet
`rename_doc`	Rename a Google Spreadsheet

License

MIT

Frequently asked questions

What is google-sheets-mcp?

google-sheets-mcp is Google Sheets MCP Server 📊🤖 JavaScript-based implementation.

How do I install google-sheets-mcp?

Open the GitHub repository and follow its README. Most MCP servers are added to your client's MCP config, then called by your agent.

Is google-sheets-mcp open source?

Yes — it is hosted on GitHub at https://github.com/mkummer225/google-sheets-mcp and has 101 stars.

Related MCP tools

mcp-installer

An MCP server that installs other MCP servers for you JavaScript-based implementation. Trusted by 1400+ developers. Trusted by 1400+ developers.

1,454 JavaScript

ios-simulator-mcp

MCP server for interacting with the iOS simulator JavaScript-based implementation. Trusted by 1200+ developers. Trusted by 1200+ developers.

1,205 JavaScript

mcp-server-mysql

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only...

889 JavaScript

mcp-server-youtube-transcript

This is an MCP server that allows you to directly download transcripts of YouTube videos. JavaScript-based implementation.

334 JavaScript

anything-llm

The all-in-one Desktop & Docker AI application with built-in RAG, AI agents, No-code agent builder, MCP compatibility, and more.

50,686 JavaScript

ai-agentscustom-ai-agentsdeepseek+16

claude-task-master

An AI-powered task-management system you can drop into Cursor, Lovable, Windsurf, Roo, and others. Built for the Model Context Protocol to enhance AI capabiliti

23,033 JavaScript

aicursorcursor-ai+9

Run your own MCP server? See who uses it and what to fix.

Measure it with TrackMCP