agents-libagents-lib
AgentsMCP ServersWorkflowsTutorialsComparisonsTemplatesNewsAbout
🔌

Google Sheets MCP

Productivity•⭐ 900

Read and write Google Sheets spreadsheets for data management and analysis.

GitHubWebsite →
Claude DesktopCursor

Overview

Read and write Google Sheets spreadsheets for data management and analysis.

Setup

Run with npx:

npx -y @modelcontextprotocol/server-google-sheets

Configuration

GOOGLE_APPLICATION_CREDENTIALS path to OAuth credentials JSON

Documentation

Google Sheets MCP (Enhanced)

Overview

Google Sheets MCP provides access to Google Sheets for spreadsheet creation, editing, and data analysis.

Features

  • Spreadsheet creation and editing
  • Cell-level operations
  • Formula support
  • Data visualization
  • Collaboration features

Installation

npx -y @modelcontextprotocol/server-google-sheets

Configuration

Set up OAuth credentials:

export GOOGLE_APPLICATION_CREDENTIALS=path/to/credentials.json

Get your credentials from Google Cloud Console.

Available Operations

OperationDescription
CreateCreate new spreadsheets
ReadRead cell values and ranges
WriteUpdate cell values
DeleteRemove rows/columns
ShareManage sharing permissions

Usage Examples

Create Spreadsheet

{
  "action": "create",
  "title": "Project Tracker",
  "sheets": [
    { "title": "Tasks", "data": [["Task", "Status", "Assignee"]] }
  ]
}

Read Range

{
  "action": "read",
  "spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
  "range": "Sheet1!A1:C10"
}

Write Cells

{
  "action": "write",
  "spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
  "range": "Sheet1!A1:C3",
  "values": [
    ["Task", "Status", "Assignee"],
    ["Research", "Done", "Alice"],
    ["Development", "In Progress", "Bob"]
  ]
}

Pros

  • ✅ Native Google integration
  • ✅ Real-time collaboration
  • ✅ Rich formula support
  • ✅ Easy sharing

Cons

  • ❌ Requires OAuth setup
  • ❌ Google ecosystem dependency
  • ❌ Limited offline support

Resources