广告合作
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.

评论

其他 分类下的更多 MCP 服务器

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

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

ICSS

chokcoco

不止于 CSS

20.7K

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

广告合作