sheets-list
Google Sheets の一覧を取得する。「スプレッドシート一覧」「Sheets 一覧」「Google Sheets 一覧」「Sheets を見たい」「スプレッドシート」などで起動。
When & Why to Use This Skill
The sheets-list skill enables users to efficiently retrieve and browse a comprehensive list of Google Sheets within their workspace. By providing essential metadata such as spreadsheet IDs, names, last modified timestamps, and direct web links, it simplifies document discovery and management, serving as a foundational tool for data-driven workflows and AI-assisted automation.
Use Cases
- Quickly locating a specific Google Spreadsheet by name or modification date without leaving the chat interface.
- Retrieving unique spreadsheet IDs required for subsequent data processing, reading, or writing operations in automated workflows.
- Auditing recent changes to collaborative workbooks by viewing the latest modified times across all available sheets.
- Streamlining document management by getting direct access links to relevant spreadsheets for immediate review.
| name | sheets-list |
|---|---|
| description | Google Sheets の一覧を取得する。「スプレッドシート一覧」「Sheets 一覧」「Google Sheets 一覧」「Sheets を見たい」「スプレッドシート」などで起動。 |
| allowed-tools | [Read, Bash] |
Sheets List
Google Sheets の一覧を取得します。
実行方法
基本的な一覧取得
python plugins/shiiman-google/skills/drive-list/scripts/google_drive.py search --query "mimeType='application/vnd.google-apps.spreadsheet'"
最大件数を指定
python plugins/shiiman-google/skills/drive-list/scripts/google_drive.py search --query "mimeType='application/vnd.google-apps.spreadsheet'" --max 50
JSON 形式で出力
python plugins/shiiman-google/skills/drive-list/scripts/google_drive.py --format json search --query "mimeType='application/vnd.google-apps.spreadsheet'"
出力項目
- id: スプレッドシートID
- name: スプレッドシート名
- modifiedTime: 更新日時
- webViewLink: 閲覧URL
関連操作
- 検索:
drive-searchコマンドでキーワード検索 - 作成:
sheets-createスキルで新規スプレッドシート作成