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

Clone this repository:

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

Install dependencies: npm install
Build: npm run build
Create OAuth credentials in Google Cloud Platform:
- Create a new project in Google Cloud Console
- Enable the Google Sheets API
- Configure the OAuth consent screen
- Create OAuth client ID credentials (Desktop application) with an appropriate redirect URI (ex: http://localhost:3000/oauth2callback)
- Download the credentials and save as gcp-oauth.keys.json in the dist subdirectory
Start the MCP server (you'll automatically be prompted to authenticate/re-authenticate your Google account when necessary): npm run start

Usage

Sample config:

{
    "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

This server cannot be installed

security - not tested

license - permissive license

quality - not tested

How are these scores calculated?

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

A Model Context Protocol (MCP) connector that allows AI agents to directly interact with Google Sheets, enabling creation, reading, and modification of spreadsheets through natural language.

Related MCP Servers

mcp-google
Ejb503
-
security
F
license
-
quality
A specialized Model Context Protocol (MCP) server that integrates Google services (Gmail, Calendar, etc.) into your AI workflows. This server enables seamless access to Google services through MCP, allowing AI agents to interact with Gmail, Google Calendar, and other Google services.
Last updated -
10
3
TypeScript
mcp-google-sheets
xing5
-
security
A
license
-
quality
A Model Context Protocol server that integrates with Google Drive and Google Sheets, enabling users to create, read, update, and manage spreadsheets through natural language commands.
Last updated -
295
Python
MIT License
Spreadsheet MCP Server
HosakaKeigo
A
security
F
license
A
quality
Provides a Model Context Protocol (MCP) server that enables LLMs to directly access and interact with Google Spreadsheet data.
Last updated -
2
1
TypeScript
MCP Google Workspace Server
josedu90
A
security
A
license
A
quality
A Model Context Protocol server that enables AI agents to interact with Google Workspace services including Drive, Docs, and Sheets through natural language commands.
Last updated -
8
Python
MIT License

View all related MCP servers

Google Sheets MCP