# Google Sheets

> Google Sheets

- Skill: `tankpkg/google-sheets` (Agent Skill, multi-file: 3 files)
- Install (CLI): `npx skillmds@latest add tankpkg/google-sheets`
- Raw SKILL.md: https://api.skillmd.com/api/skills/tankpkg/google-sheets/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: tankpkg (https://skillmd.com/u/tankpkg)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/tankpkg/google-sheets

---

# Google Sheets

Read, write, format, and analyze spreadsheet data through the Google Sheets API.

## Overview

This skill teaches AI agents to work with Google Sheets — reading and writing cell data, formatting, creating charts, managing named ranges, and using formulas. Supports both simple value operations and complex batch updates.

## Capabilities

### Reading Data

- Read single cells, ranges, and multiple ranges in one call
- Get values with formatting metadata
- Read entire sheets or named ranges
- Choose value render options: FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA

### Writing Data

- Write to single cells or ranges
- Append rows to the end of a table
- Batch update multiple ranges in a single request
- Choose input options: RAW or USER_ENTERED

### Formatting

- Set cell background colors, font styles, sizes, and colors
- Apply number formats (currency, percentage, dates, custom)
- Set borders, merge cells, alignment
- Apply conditional formatting rules and data validation

### Sheet Management

- Create, rename, delete, and reorder sheets
- Copy sheets between spreadsheets
- Freeze rows and columns, hide/show elements
- Set sheet-level protection

### Charts & Visualization

- Create embedded charts (bar, line, pie, scatter, area, combo)
- Configure chart titles, legends, axes, and data ranges

## Authentication

Requires Google OAuth 2.0 with `spreadsheets` or `spreadsheets.readonly` scope.

## Permissions

| Permission | Scope                 | Reason                    |
| ---------- | --------------------- | ------------------------- |
| Network    | `*.googleapis.com`    | Sheets API calls          |
| Network    | `accounts.google.com` | OAuth authentication      |
| Filesystem | Read `./**`           | Read local CSV/data files |
| Subprocess | None                  | Not required              |

## Best Practices

1. **Use A1 notation** for ranges — quote sheet names with spaces
2. **Batch operations** to minimize API calls
3. **USER_ENTERED** for formulas and dates
4. **Append, don't overwrite** — use `values.append` for adding rows
5. **Named ranges** instead of hardcoded A1 references