広告掲載
MCP.so
ログイン

GoogleSheet MCP Server

@Aryan1718

リポジトリ

基本情報

カテゴリ

その他

トランスポート

stdio

作者

Aryan1718

投稿者

Aryan Pandit

GoogleSheet MCP Server について

This MCP server provides tools to interact with Google Sheets, allowing you to read, write, and update data in your spreadsheets.

#mcp-server#google-sheet

GoogleSheet MCP Server の設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

GoogleSheet MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is GoogleSheet MCP?

GoogleSheet MCP is a Model Context Protocol server that provides tools to read, write, and update data in Google Sheets. It is designed for developers who want to integrate spreadsheet data into AI-assisted workflows using a service account.

How to use GoogleSheet MCP?

Install required Python packages, set up Google Cloud Platform credentials, enable the Google Sheets API, create a service account, and share your sheet with the service account email. Configure a .env file with your API key, then run mcp install main.py to start the server.

Key features of GoogleSheet MCP

  • List all spreadsheets shared with the service account
  • Get detailed information about a specific spreadsheet
  • Retrieve content from a specific sheet
  • Generate realistic test data based on sheet attributes
  • Add pre-formatted data (list or CSV formats) to a sheet
  • Update existing records by matching ID or name

Use cases of GoogleSheet MCP

  • Automate reading and writing spreadsheet data within AI agent workflows
  • Populate sheets with generated test data for development or demos
  • Update specific records in a spreadsheet by identifier without manual edits
  • Build tools that list available sheets and inspect their structure

よくある質問

1

What are the prerequisites for using GoogleSheet MCP?

You need Python 3.8 or higher, a Google Cloud Platform account, and a Google Sheet you want to interact with.

2

How do I authenticate the server?

You must create a service account in Google Cloud Console, download the JSON key as `credentials.json`, place it in the server directory, and share your Google Sheet with the service account’s email giving it Editor access.

3

What data formats are accepted when adding data to a sheet?

Data can be provided as a list of lists (e.g., `[["value1", "value2"], ["value3", "value4"]]`) or as CSV text (e.g., `value1,value2\nvalue3,value4`).

4

What should I do if I get authentication errors?

Ensure the service account email is added as an editor to the spreadsheet, verify your `credentials.json` file is valid, and confirm the Google Sheets API is enabled in your project.

5

Where do sensitive credentials live and how should they be protected?

Credentials live in the `credentials.json` file and the API key in the `.env` file. Both must never be committed to version control, and API keys should be rotated regularly.

コメント

「その他」の他のコンテンツ

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

The Living Bread

The Living Bread

A free remote MCP server for The Living Bread. Bible passages read word for word from a stored public domain text with an evidence label, keyword search and cross references, real churches, gatherings and prayer groups w

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K
広告掲載