Advertise
MCP.so
Sign In

Google Sheets MCP Server

@mkummer225

Repository

Basic information

Category

Other

License

MIT

Transports

stdio

Author

mkummer225

Submitted by

Matt Kummer

About Google Sheets MCP Server

Google Sheets MCP Server 📊🤖

Google Sheets MCP Server config

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

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

Google Sheets MCP 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 Google Sheets Mcp?

Google Sheets Mcp is a Model Context Protocol (MCP) connector that enables AI agents to read, write, and manage Google Sheets spreadsheets directly through natural language or tool calls.

How to use Google Sheets Mcp?

Clone the repository, run npm install and npm run build, then place your Google OAuth credentials file (gcp-oauth.keys.json) in the dist directory. Start the server with npm run start and configure your MCP client with the sample JSON config pointing to the built index.js file. Specify a spreadsheetId or ask your agent to create a new spreadsheet.

Key features of Google Sheets Mcp

  • Authenticate using Google OAuth 2.0 with desktop credentials
  • List, create, and rename sheets and spreadsheets
  • Read all data, specific rows, or columns from a sheet
  • Edit individual cells, entire rows, or entire columns
  • Insert new rows or columns at specified positions
  • Refresh authentication when credentials expire

Use cases of Google Sheets Mcp

  • An AI assistant automatically populates a weekly report spreadsheet
  • A chatbot reads and updates a shared budget tracker
  • A productivity agent creates new project sheets and manages task lists
  • An automation pipeline inserts data rows into a live spreadsheet

Frequently asked questions

1

What does Google Sheets Mcp do?

It acts as a bridge between AI agents and Google Sheets, allowing agents to perform spreadsheet operations via the Model Context Protocol.

2

How do I authenticate with Google Sheets?

You must create OAuth 2.0 credentials in Google Cloud Platform, enable the Sheets API, and save the downloaded `gcp-oauth.keys.json` file in the `dist` directory. The server will prompt you to authenticate on first run.

3

What operations are available?

It supports reading/writing cells, rows, and columns; creating and renaming sheets and spreadsheets; inserting rows/columns; and listing sheet names. A full table of 14 actions is provided in the README.

4

What runtime dependencies does it require?

Node.js and npm are needed to install dependencies and build the project. The server runs locally and communicates over stdio via the MCP protocol.

Comments

More Other MCP servers

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

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

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

Codelf

unbug

A search tool helps dev to solve the naming things problem.

14.2K
Advertise