GoogleSheets-mcp-server

GoogleSheets-mcp-server

1
cloud_platforms

The project is a Model Context Protocol server to manage Google Sheets through an API. It enables full CRUD operations for spreadsheets, supports sheet and value management, and integrates developer metadata. It uses OAuth 2.0 for authentication.

Google Sheets API MCP Server

A comprehensive Model Context Protocol server for interacting with the Google Sheets API, focusing on manipulating spreadsheets, sheets, values, and developer metadata.

Features

  • Create, read, update, and delete spreadsheets
  • Manage sheets
  • Handle values: read, write, append, clear
  • Work with developer metadata

Prerequisites

  • Node.js 16 or higher
  • Google Cloud Project with Sheets API enabled
  • OAuth 2.0 credentials

Setup

  1. Clone repository
  2. Install dependencies
  3. Configure .env with API credentials

Usage

  • Run server: npm start
  • Development mode: npm run dev
  • Testing: npm run inspect

Available Tools

  • Spreadsheet, Sheet, Values, and Developer Metadata Management

Authentication

Utilizes OAuth 2.0 with necessary credentials in .env.

License

MIT