Google Sheets MCP
Allows AI agents to interact with Google Sheets directly, providing tools to create, read, and edit spreadsheets, sheets, rows, and columns, as well as manage sheet metadata and authentication.
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
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: MCP Google Sheets Server
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
Hosted / Railway (SSE transport)
If you need a URL-based MCP endpoint (e.g., for the Agent Toolkit’s “Connect to MCP Server” flow), run with the SSE transport and deploy to a host like Railway:
Build:
npm run buildSet env vars (do not commit secrets):
MCP_TRANSPORT=ssePORT=3000(or your platform’s port)GSHEETS_OAUTH_JSON— your OAuth client JSON (plain or base64-encoded). Required if the filedist/gcp-oauth.keys.jsonis not present.GSHEETS_CREDENTIALS_JSON— a pre-authorized credentials JSON (plain or base64-encoded). Use this to avoid interactive auth on hosted environments.
Deploy
dist/to Railway and runnode dist/index.js.In your client/UI, point the MCP URL to
https://<your-railway-app>.up.railway.app/sse(the server will direct POSTs to/messagesvia the SSE endpoint event).
Note: Keep *.keys.json and credential files out of git. Use env vars or your host’s secrets manager instead.
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
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
Related MCP Connectors
Connect AI assistants to Google Sheets through controlled tools for reading and updating rows.
Online office suite for AI agents: edit docs, sheets, slides and PDFs in browser or via MCP.
Connect an AI assistant to your Google Sheets, Drive, Docs, PDFs, BigQuery and Gmail.
1Google Sheets via Apify: write Apify datasets or JSON rows to a sheet, or read a sheet as JSON.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceA 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.599 npm138MIT
- AlicenseNot gradedqualityDmaintenanceEnables reading, writing, and managing Google Sheets documents with support for batch operations, formatting, charts, and conditional formatting through the Model Context Protocol.5,983 npmMIT
- FlicenseNot gradedqualityDmaintenanceProvides comprehensive Google Sheets integration for creating, reading, updating, and managing spreadsheets programmatically via tools like batch updates and range operations. It enables automated workflows for data analysis, project management, and synchronization within the Model Context Protocol.-
- AlicenseNot gradedqualityDmaintenanceEnables 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.MIT