google-sheets-mcp-server

google-sheets-mcp-server

0
cloud_platforms

The Google Sheets MCP Server is designed for seamless interaction with Google Sheets via Claude Desktop. It offers functionalities to manage and manipulate sheets, supporting various tasks like data reading, writing, and formula insertion.

Google Sheets MCP Server

A Model Context Protocol (MCP) server for Google Sheets that integrates with Claude Desktop. It allows users to create, read, write, and perform various management tasks on Google Sheets.

Features

  • Create, read, and write Google Sheets
  • Format cells and ranges
  • Manage sheets (add/delete)
  • Write formulas
  • Search and list available sheets

Prerequisites

  • Python 3.10+
  • Google Cloud Project with Sheets API enabled
  • OAuth 2.0 credentials
  • Claude Desktop

Installation

  1. Clone the repository.
  2. Set up virtual environment.
  3. Install dependencies.
  4. Configure Google Cloud credentials.

Usage

  • Integrate with Claude Desktop using specified commands for managing Google Sheets.