# Google Sheets

> Use this tool when you need to automate Google Sheets tasks, such as managing spreadsheets, performing CRUD operations, and manipulating tables and cells. It solves problems related to structured data management, organization, and integration, making it ideal for business automation workflows and AI interactions. With inputs including spreadsheet notations and JSON data, and outputs featuring compact JSON responses, this tool provides a comprehensive interface for efficient Google Sheets automation.

Canonical page: https://skillsregistry.net/skills/henilcalagiya-google-sheets  
JSON: https://api.skillsregistry.net/v1/skills/henilcalagiya-google-sheets

## Description

Provides Google Sheets automation capabilities through 25 specialized tools covering spreadsheet discovery, sheet management, and table operations including CRUD functionality, column type management, sorting, and cell manipulation. Built by Henil C Alagiya using Python and the Google Sheets API, the implementation offers comprehensive table-centric operations with structured data validation, batch processing capabilities, and compact JSON responses optimized for AI interactions. Features include table creation with typed columns and data validation rules, record management with flexible filtering, cell updates by notation or range, and advanced operations like dropdown option management and table sorting with automatic filter removal. Valuable for business automation workflows requiring structured data management, AI agents that need to maintain organized datasets in spreadsheets, and applications that require reliable Google Sheets integration with proper error handling and input validation.

## Trust

- **Trust score (0–1):** 0.65
- **Verification tier:** unverified

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** ai-ml
- **Updated:** 2026-05-22

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/henilcalagiya-google-sheets)
- **Repository:** <https://github.com/henilcalagiya/google-sheets-mcp>

## 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": "henilcalagiya-google-sheets"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/henilcalagiya-google-sheets` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/henilcalagiya-google-sheets/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