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.
来源信息
- 仓库
- gemini-cli-extensions/workspace
- 最近来源活动
- 2026年3月11日 19:39
- 检测到的 SKILL.md 语言
- 英语
- 星标
- 645
- 分支
- 107
安装方式
默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。
检查来源文件
决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。
正在显示 SKILL.md
SKILL.md
来源说明 · 只读预览- name
- google-sheets
- description
- 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.
# 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
在 GitHub 查看