# Google Sheets MCP Server

> Use this tool when you need to manage and manipulate Google Sheets data securely, and automate tasks such as batch updates, CSV imports, and conditional formatting. It provides a bridge for AI assistants to interact with the Google Sheets API through 31 tools, supporting Service Account and OAuth 2.0 authentication. Ideal for use cases requiring spreadsheet management, data manipulation, and table-level operations, with inputs including sheet IDs, cell ranges, and formatting rules, and outputs including updated sheets, imported data, and formatted tables.

Canonical page: https://skillsregistry.net/skills/santiagopereda-mcp-googlesheets  
JSON: https://api.skillsregistry.net/v1/skills/santiagopereda-mcp-googlesheets

## Description

Provides a secure bridge for AI assistants to interact with the Google Sheets API via 31 tools for spreadsheet management, data manipulation, and table-level operations. It supports both Service Account and OAuth 2.0 authentication for tasks including batch updates, CSV imports, and conditional formatting.

## Trust

- **Trust score (0–1):** 0.96
- **Verification tier:** verified
- **Last scanned:** 2026-09-28

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** security
- **Updated:** 2026-09-28

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/ywbtffxb95)
- **Repository:** <https://github.com/santiagopereda/MCP_GoogleSheets>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "santiagopereda-mcp-googlesheets"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/santiagopereda-mcp-googlesheets` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/santiagopereda-mcp-googlesheets/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt