Google Sheets API MCP Server

@mattcoatsworth

代码仓库

基本信息

分类

开发工具

传输方式

stdio

作者

mattcoatsworth

关于 Google Sheets API MCP Server

暂无概览

#google-sheets #api #mcp-server

Google Sheets API MCP Server 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

Google Sheets API MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Google Sheets API MCP Server?

A comprehensive Model Context Protocol (MCP) server for interacting with the Google Sheets API. It provides tools and resources for managing spreadsheets, sheets, values, and developer metadata, intended for developers building AI or automation workflows that need to read and write Google Sheets data.

How to use Google Sheets API MCP Server?

Clone the repository, install dependencies with npm install, and create a .env file with your Google OAuth 2.0 credentials (CLIENT_ID, CLIENT_SECRET, REDIRECT_URI, REFRESH_TOKEN). Run the server with npm start, or use npm run dev for development mode and npm run inspect to test with the MCP Inspector.

Key features of Google Sheets API MCP Server

Create, read, update, and delete spreadsheets
Manage sheets within spreadsheets
Read, write, append, and clear cell values
Work with developer metadata
Access spreadsheet data through MCP resources

Use cases of Google Sheets API MCP Server

Automating spreadsheet creation and population
Reading and updating cell ranges in existing sheets
Managing sheet properties and metadata programmatically
Copying sheets between different spreadsheets
Batch reading or writing values across multiple ranges

常见问题

What are the prerequisites to use this server?

Node.js 16 or higher, a Google Cloud Platform project with the Google Sheets API enabled, and OAuth 2.0 credentials (client ID, client secret, refresh token).

How does authentication work?

The server uses OAuth 2.0. You must provide a CLIENT_ID, CLIENT_SECRET, REDIRECT_URI, and a REFRESH_TOKEN in the `.env` file.

What tools are available?

Tools for spreadsheet management (create, get, batch update), sheet management (copy, add, delete, update properties), values management (get, update, append, clear, batch get/update), and developer metadata (get, create, update, delete).

What resources does the server expose?

Resources follow the pattern `sheets://spreadsheet/{spreadsheetId}`, `sheets://spreadsheet/{spreadsheetId}/sheet/{sheetName}`, `sheets://spreadsheet/{spreadsheetId}/values/{range}`, and `sheets://spreadsheet/{spreadsheetId}/metadata`.

What license is this server distributed under?

MIT.

开发工具分类下的更多 MCP 服务器

Official Porkbun MCP Server

Porkbun LLC

Official Porkbun MCP server, maintained by Porkbun. Check domain availability and pricing, register, renew and transfer domains, and manage DNS records, nameservers, URL forwarding, glue records, DNSSEC and domain contac

FARPY

mangomunchr

Verified distributed compute for humans, applications, and agents. Submit Blender, Octane, and video workloads, route them across qualified GPUs, track asynchronous execution, download finished artifacts, and verify FARP

Capgo MCP

Cap-go

Console, Backend and CLI to manage Capgo Instant update and Native build for Capacitor apps Build and upload to app store your mobile app

Moxie Docs

Jackalope-Dev

Automated codebase documentation for GitHub: searchable docs, MCP context for AI agents, doc drift detection, and Friday Cleanup PRs.

ArtiBot Cloud MCP - Zhijiangyun 智匠云

bofob

ArtiBot Cloud MCP (Zhijiangyun 智匠云) — cloud MCP server for robot manipulation data & GPU workloads. 15 tools: robot fleet management, data collection & video recording, post-processing pipelines, and benchmark evaluation