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.

「開発者ツール」の他のコンテンツ

Foremerge

naw103

Catch intent conflicts before code conflicts. The open-source coordination protocol for coding agents, built above Git.

Meticulous

Mcp-Warden

ermoluk

Local-first credential broker for MCP. AI coding agents (Claude Code, Cursor, Codex…) call APIs, SSH and databases through scoped presets; secrets stay in your OS keychain and never enter the agent's context.

LocalCan

Gives AI agents public URLs (tunnels) for localhost, live HTTP traffic inspection, snapshot publishing, and access control. Part of LocalCan, the ngrok alternative for Mac, Windows and Linux. Free plan.

Modelglass

Modelglass turns "which model should I use?" into a lookup instead of a guess. Seven tools give your agent live pricing across image, language, video, and audio models. Sourced and versioned, not scraped once and forgott