Google Sheets
Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting
Open the source (opens github.com) https://github.com/mcp-z/mcp-sheets
Before you use it
- Runs on your computer with your permissions. Read what it can do before connecting it to an agent.
- Needs credentials: GOOGLE_CLIENT_SECRET. Use a key with the least access you can.
What it is
MCP servers from io.github.mcp-z.
The problem it solves and who it suits haven't been reviewed by InnerVault. The description above is the source's own.
How to get it
npm package (stdio)
@mcp-z/mcp-sheets@2.5.0
From the server's entry in the official MCP Registry
npm package (streamable-http)
@mcp-z/mcp-sheets@2.5.0
From the server's entry in the official MCP Registry
Settings it asks for
GOOGLE_CLIENT_IDrequired · Google OAuth client ID (required for OAuth authentication modes)GOOGLE_CLIENT_SECRETsecret · Google OAuth client secret (optional for public clients)GOOGLE_SERVICE_ACCOUNT_KEY_FILE· Path to service account JSON key file (required for service-account auth mode)AUTH_MODE· Authentication modeHEADLESS· Disable browser auto-open, return auth URL instead (true/false)REDIRECT_URI· OAuth redirect URI (optional, default: ephemeral loopback)RESOURCE_STORE_URI· Resource store URI for exported files (file://)PORT· HTTP server port (overrides --port)BASE_URL· Base URL for HTTP transport (used for OAuth/DCR endpoints and file links)LOG_LEVEL· Logging levelGOOGLE_CLIENT_IDrequired · Google OAuth client ID (required for OAuth authentication modes)GOOGLE_CLIENT_SECRETsecret · Google OAuth client secret (optional for public clients)
Related
-
mcp-google-sheets
MCP serversThis MCP server integrates with your Google Drive and Google Sheets, to enable creating and modifying spreadsheets.
git clone https://github.com/xing5/mcp-google-sheets.git -
google-sheets
MCP serversCreate, read, and modify spreadsheet data, formatting, and sheets
mcparmory-google-sheets@1.0.3 -
Google Sheets
MCP serversAllow AI systems to read, write, and query spreadsheet data via Google Sheets.
google-sheets-mcp@1.2.1 -
Google Sheets Import and Export for Apify
MCP serversExport scraper results to Google Sheets or import a spreadsheet as clean data.
-
sheetport
MCP serversGoogle Sheets spreadsheets and cell values via the Sheets API, as MCP tools.
@reneturcios/sheetport@0.1.0 -
Spreadsheet DB
MCP serversSQLite-authoritative entity database with an async Google Sheets projection for AI agents.
spreadsheet-db-mcp@0.1.1