google-sheet-mcp
Provides tools for creating, reading, updating, appending, and clearing values in Google Sheets, as well as adding sheets and pasting markdown reports.
Click on "Deploy 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-sheet-mcp Read the range A1:C10 from my budget sheet"
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 local MCP server for creating, reading, and updating Google Sheets.
Tools
sheets_create_spreadsheet- create a new Google spreadsheetsheets_get_values- read a range from a sheetsheets_update_values- overwrite a rangesheets_append_values- append rowssheets_clear_values- clear a rangesheets_add_sheet- add a new tabsheets_paste_markdown_report- paste a markdown report as one line per row
Related MCP server: google-sheets-mcp
Setup
Enable the Google Sheets API for the Google Cloud project.
Enable the Google Drive API if you want to create new spreadsheets.
Fill
.envwith your OAuth client values.Generate a Sheets-scoped refresh token:
npm run authOpen the printed Google URL, approve access, then copy the printed SHEETS_REFRESH_TOKEN into .env.
Install and build:
npm install
npm run buildCodex config
[mcp_servers.google-sheets]
command = "node"
args = ["/Users/sandeshsonabakhilari/Desktop/my-mcp/google-sheets-mcp/dist/index.js"]The MCP reads credentials from /Users/sandeshsonabakhilari/Desktop/my-mcp/google-sheets-mcp/.env.
Example
Create a spreadsheet:
{
"title": "Gmail Reports",
"sheetTitle": "Read Mail Priority"
}Paste a report:
{
"spreadsheetId": "...",
"range": "Read Mail Priority!A1",
"markdown": "# Report...",
"clearFirst": true
}Available Tools
7 toolssheets_add_sheetC
Add a new tab/sheet to a spreadsheet.
Inputs: title (required), spreadsheetId (required).
sheets_append_valuesC
Append rows to a Google Sheet range.
Inputs: range (required), values (required), spreadsheetId (required), valueInputOption.
sheets_clear_valuesC
Clear values from a Google Sheet range.
Inputs: range (required), spreadsheetId (required).
sheets_create_spreadsheetB
Create a new Google spreadsheet.
Inputs: title (required), sheetTitle.
sheets_get_valuesC
Read values from a Google Sheet range.
Inputs: range (required), spreadsheetId (required).
sheets_paste_markdown_reportB
Paste a markdown report into a sheet as one line per row.
Inputs: range (required), markdown (required), spreadsheetId (required), clearFirst.
sheets_update_valuesC
Overwrite values in a Google Sheet range.
Inputs: range (required), values (required), spreadsheetId (required), valueInputOption.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 7 tools
Each tool targets a distinct action (add sheet, append, clear, create, get, paste markdown, update) with no overlap in purpose, ensuring an agent can easily distinguish them.
All tools follow a consistent 'sheets_verb_noun' pattern (e.g., sheets_add_sheet, sheets_get_values), with only 'sheets_paste_markdown_report' slightly deviating in verb form but still predictable.
Seven tools is well-scoped for a Google Sheets server, covering creation, reading, writing, appending, clearing, tab management, and a specialized markdown paste function without being overwhelming.
The tool set covers core operations (create, read, update, append, clear) and adds tab management and markdown support, though missing explicit delete operations (e.g., delete sheet or row) which are minor gaps.
Related MCP Connectors
Hosted Google Sheets MCP server, with each action switched on or off per account.
An MCP server that provides read access to your cloud storage providers, bank accounts and more.
Streamable HTTP MCP server for Google Calendar and Sheets with OAuth login.
A MCP server that works with Google Calendar to manage event listing, reading, and updates.
Related MCP Servers
- FlicenseNot gradedqualityDmaintenanceAn MCP server that enables interaction with Google Sheets through natural language, allowing users to create, read, update, and manage spreadsheet data via the Google Sheets API v4.-
- AlicenseNot gradedqualityBmaintenanceMCP server for Google Sheets - read, write, and query spreadsheet data.599 npm2MIT
- AlicenseAqualityDmaintenanceMCP server for interacting with Google Sheets, providing tools to list sheets, read data from cell ranges, and write data to cell ranges.33MIT
- AlicenseCqualityDmaintenanceA locally running MCP server that provides cell-level and formatting-level control over Google Sheets via the Sheets API v4, enabling reading, writing, formatting, and managing spreadsheets through natural language.83MIT