Google Sheets MCP Server

MCPOfficialOpen SourceMIT42.7

by freema • Visualization & Charts

An MCP server that lets MCP-enabled agents read, write, and manage Google Sheets documents via the Google Sheets API.

Example Use Cases

1
Read and query spreadsheet ranges or metadata to fetch up-to-date structured data.
2
Write, append, or batch-update rows and ranges (including value input options and row insertion).
3
Manage sheets, formatting, borders, merges, conditional formatting, and create or update charts programmatically.

Description

This server provides full Google Sheets API integration for MCP clients, enabling reading, writing, batch operations, formatting, charts, and sheet management. It supports flexible authentication via service account JSON files or a JSON string for containerized/CI environments. Built with TypeScript for Node.js (v18+), it includes comprehensive error handling and is intended to be production ready for automation and agent workflows.

Quick Actions

View on GitHub

Security

Scanned 2 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

D44/100

4/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelFree

Capabilities0 Tools / 0 Prompts / 0 Resources

Ownerfreema

CategoryVisualization & Charts

DependenciesStandalone