Google Sheets MCP
A server for interacting with Google Sheets, allowing you to read, write, and manage spreadsheet data.
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.jsonin thedistsubdirectory
-
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
Serveurs connexes
Kone.vc
sponsorMonetize your AI agent with contextual product recommendations
Date-time Tools
A server for date-time manipulation and timezone conversion.
OnlyBots.Exchange
AI agent skill marketplace — 38 pre-built skills across 13 categories. Discovery API, MCP server, and npm SDK for programmatic integration.
P-Link.io
HTTP402 implementation - Gives agents the capacity to pay 402 links and send money to any email, request money
Shortcut
Interact with the Shortcut project management tool, formerly known as Clubhouse.
Clanki - Claude's Anki Integration
Enables AI assistants to interact with Anki flashcard decks via the AnkiConnect plugin.
crm-cli
A local-first personal CRM for the terminal — manage contacts, deals, interactions, and tasks from Claude with 18 built-in tools, all stored in a local SQLite file.
Notion
Search, read, create, and update pages and databases in your Notion workspace.
Google Calendar Integration Project
Manage and interact with Google Calendar events using the Google Calendar API.
appium-mcp
MCP server for Mobile Development and Automation | iOS, Android, Simulator, Emulator, and Real Devices
Rednote MCP
An automated tool for searching and commenting on the social media platform Xiaohongshu (Rednote) using Playwright.