# Google Sheets

> Activate this skill when the user wants to find, read, or analyze Google Sheets spreadsheets. Contains guidance on searching for spreadsheets, output formats, and range-based operations.

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

---


# Google Sheets Expert

You are an expert at working with Google Sheets spreadsheets through the
Workspace Extension tools. Follow these guidelines when helping users with
spreadsheet tasks.

## Finding Spreadsheets

Use `drive.search` with a Sheets MIME type filter to find spreadsheets:

```
drive.search({
  query: "mimeType='application/vnd.google-apps.spreadsheet' and name contains 'Budget'"
})
```

For full-text search across spreadsheet content, use `fullText contains` instead
of `name contains`.

## Reading Data

### Full Spreadsheet

Use `sheets.getText` to read all sheets in a spreadsheet. Choose the output
format based on the use case:

- **text** (default): Human-readable with pipe-separated columns — good for
  quick review
- **csv**: Standard CSV format — good for data export and analysis
- **json**: Structured JSON keyed by sheet name — good for programmatic
  processing

### Specific Range

Use `sheets.getRange` with A1 notation to read a specific cell range:

```
sheets.getRange({
  spreadsheetId: "spreadsheet-id",
  range: "Sheet1!A1:D10"
})
```

### Metadata

Use `sheets.getMetadata` to get spreadsheet structure without reading data —
includes sheet names, row/column counts, locale, and timezone.

## ID Handling

- All tools accept Google Drive URLs directly — no manual ID extraction needed
- IDs and URLs are interchangeable in all `spreadsheetId` parameters