mcp-gsheet

mcp-gsheet

0
cloud_platforms

This project is an MCP Server designed for interaction with Google Sheets. It includes capabilities for listing sheets and reading or writing data within spreadsheets. Notably, it doesn't handle Google Drive file management.

MCP Google Sheets Server

This project provides a Model Context Protocol (MCP) server for interacting with Google Sheets.

  • Features include listing sheets, reading from specific cell ranges, and writing to specific cell ranges.
  • It does not manage Google Drive files outside the spreadsheet content.

Prerequisites

  • Python 3.11+
  • Google Cloud Project with Google Sheets API enabled
  • Service Account Key with proper permissions

How to use

  1. Clone the repository.
  2. Set up Google Credentials.
  3. Install dependencies.
  4. Run the server using MCP Inspector or standard method.

MCP Tools Provided

  • list_sheets(spreadsheet_id): Lists all sheets in a spreadsheet.
  • read_cells(spreadsheet_id, range_name): Reads data from a specified cell range.
  • write_cells(spreadsheet_id, range_name, values): Writes data to a specified cell range.