A
license-
qualityC
maintenanceA 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
967
MIT
Google Sheets MCP
by mkummer225
Provides OAuth authentication through Google Cloud Platform to enable secure access to Google Sheets data.
Allows AI agents to interact directly with Google Sheets spreadsheets, including creating new spreadsheets, reading and editing cell data, adding/editing rows and columns, and managing sheets/tabs within spreadsheets.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Google Sheets MCPadd a new row to the budget sheet with these values: Rent, $1200, 2024-01-15"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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
Related MCP server: Google Sheets MCP
Setup
Clone this repository:
git clone https://github.com/mkummer225/google-sheets-mcp
cd google-sheets-mcpInstall dependencies:
npm installBuild:
npm run buildCreate 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 |
| Re-authenticate your Google Account when credentials expire |
| List all sheets/tabs in a Google Spreadsheet |
| Create a new sheet/tab in a Google Spreadsheet |
| Create a new Google Spreadsheet |
| Read all data from a specified sheet |
| Read the column headings from a sheet |
| Read specific rows from a sheet |
| Read specific columns from a sheet |
| Edit a single cell in a sheet |
| Edit an entire row in a sheet |
| Edit an entire column in a sheet |
| Insert a new row at specified position |
| Insert a new column at specified position |
| Rename a sheet/tab in a spreadsheet |
| Rename a Google Spreadsheet |
License
MIT
This server cannot be installed
Maintenance
–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Servers
- Alicense-qualityDmaintenanceEnables AI agents to interact directly with Google Sheets to create, read, and edit spreadsheets through the Model Context Protocol. It supports a wide range of actions including cell manipulation, row and column management, and sheet organization.Last updated1,224MIT
- Flicense-qualityCmaintenanceEnables AI assistants to read, write, and format Google Spreadsheets through the Model Context Protocol. It supports comprehensive operations including data retrieval, sheet creation, and cell formatting using natural language commands.Last updated
- Alicense-qualityDmaintenanceEnables AI assistants to read, write, and manage Google Sheets spreadsheets through natural language commands, providing a bridge between MCP clients and the Google Sheets API.Last updated9371MIT
Related MCP Connectors
Hosted Google Calendar MCP server for AI agents. No self-hosting or Google Cloud setup.
Your memory, everywhere AI goes. Build knowledge once, access it via MCP anywhere.
The financial MCP for AI agents - 90+ financial tables, SEC filings, signals, alt-data.
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/mkummer225/google-sheets-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server