gsheets

Repo-local Google Sheets skill: inspect tabs and ranges, search rows, update values, and append structured rows.

安装方式

默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。

用 Codex 或 Claude 帮你安装复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。

直接命令不会经过审查 Prompt；运行前请先检查来源。

npx skills add https://github.com/Kesua/agentic-vault --skill gsheets

命令会保持在同一行。复制前请横向滚动并检查完整内容。

想先保存到本地？可下载 SkillsMP 当前能够提供的文件。

决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。

SKILL.md

来源说明 · 只读预览

Regular Fireflies sync: fetch transcript summaries in a date window and upsert them into matching meeting notes.

Regular Google Calendar sync: update upcoming meeting notes (today + 14 days, two accounts) and refresh the meeting index.

Ad-hoc Google Drive assistant: search Drive and inspect Docs, Sheets, and Slides across `private` and `personal` accounts.

name	gsheets
description	Repo-local Google Sheets skill: inspect tabs and ranges, search rows, update values, and append structured rows.

This is a repo-local Google Sheets skill backed by 90_System/Skills/google_drive_assistant/google_drive_assistant.py.

Inspect metadata:
- .\.venv\Scripts\python.exe 90_System\Skills\google_drive_assistant\google_drive_assistant.py get-sheet-metadata --account both --spreadsheet-id <sheet_id_or_url>
Read values:
- .\.venv\Scripts\python.exe 90_System\Skills\google_drive_assistant\google_drive_assistant.py get-sheet-values --account both --spreadsheet-id <sheet_id_or_url> --sheet-name "Sheet1" --range "A1:D20"
Find rows:
- .\.venv\Scripts\python.exe 90_System\Skills\google_drive_assistant\google_drive_assistant.py find-sheet-rows --account both --spreadsheet-id <sheet_id_or_url> --sheet-name "Sheet1" --range "A1:Z200" --query "Jan"
Update a range:
- .\.venv\Scripts\python.exe 90_System\Skills\google_drive_assistant\google_drive_assistant.py update-sheet-values --account both --spreadsheet-id <sheet_id_or_url> --range "Sheet1!A2:C2" --values-json '[["Jan","Open","=TODAY()"]]'
Append rows:
- .\.venv\Scripts\python.exe 90_System\Skills\google_drive_assistant\google_drive_assistant.py append-sheet-rows --account both --spreadsheet-id <sheet_id_or_url> --sheet-name "Sheet1" --rows-json '[["Jan","Review","Pending"]]'
Full docs:
- 90_System/Skills/google_drive_assistant/SKILL.md