MCP Google Sheets Server

@shionhonda

a year ago

Model Context Protocol (MCP) server that allows interaction with Google Sheets

Overview

What is MCP Google Sheets Server?

MCP Google Sheets Server is a Model Context Protocol (MCP) server that facilitates interaction with Google Sheets, allowing users to read and write data within spreadsheets.

How to use MCP Google Sheets Server?

To use the MCP Google Sheets Server, set up a Google Cloud project with the Google Sheets API enabled, configure your service account credentials, and run the server using the command line tool provided in the repository.

Key features of MCP Google Sheets Server?

List sheets (tabs) within a spreadsheet.
Read data from specific cell ranges.
Write data to specific cell ranges.
Does not manage Google Drive files, focusing solely on spreadsheet content.

Use cases of MCP Google Sheets Server?

Automating data entry into Google Sheets.
Extracting data from Google Sheets for analysis.
Integrating Google Sheets with other applications via MCP.

FAQ from MCP Google Sheets Server?

What are the prerequisites to use this server?

You need Python 3.8+, a Google Cloud project with the Google Sheets API enabled, and a service account key.

Can I manage Google Drive files with this server?

No, this server is specifically designed for interacting with Google Sheets only.

How do I run the server?

Use the command mcp run gsheet_mcp_server.py after setting up your environment.

Build with ShipAny.