원클릭으로
gws-sheets
Google Sheets 读写数据。不用于:本地 Excel/CSV(用 xlsx 技能)
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
메뉴
Google Sheets 读写数据。不用于:本地 Excel/CSV(用 xlsx 技能)
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Use when the user asks to create, edit, improve, redesign, beautify, inspect, or export PowerPoint decks, PPT files, slide decks, keynotes, or .pptx deliverables. Prefer this skill for presentation work that must produce a real PPTX file, especially when visual quality, editable text, brand assets, charts, or export verification matter. Do not use for Word documents or PDFs.
Markdown 转微信公众号排版并发布草稿。Use this whenever the user asks to convert Markdown to WeChat Official Account HTML, inspect publish readiness, preview local WeChat layout, or create a WeChat draft. 不用于:写文章内容、其他平台发布。
视频字幕提取、翻译、双语合并、烧录。不用于:纯音频转文字、翻译文本文件、视频剪辑
下载视频/音频(YouTube、B站、Twitter等)。不用于:网页抓取(用 web_fetch)、直播录制
AI图片生成(文生图、图生图、去背景、放大),需本地 ComfyUI。不用于:截图、网页抓图、非AI图片处理
创建自定义技能(SKILL.md)。不用于:执行已有技能、修改代码、一次性脚本
| name | gws-sheets |
| description | Google Sheets 读写数据。不用于:本地 Excel/CSV(用 xlsx 技能) |
Requires: gws CLI installed and authenticated (gws auth login).
gws sheets <resource> <method> --params '{"key":"val"}' --json '{"key":"val"}'
{"command": "gws sheets spreadsheets.values get --params '{\"spreadsheetId\":\"SPREADSHEET_ID\",\"range\":\"Sheet1!A1:D10\"}'", "timeout": 30000}
{"command": "gws sheets spreadsheets.values get --params '{\"spreadsheetId\":\"SPREADSHEET_ID\",\"range\":\"Sheet1\"}'", "timeout": 30000}
{"command": "gws sheets spreadsheets.values update --params '{\"spreadsheetId\":\"SPREADSHEET_ID\",\"range\":\"Sheet1!A1\",\"valueInputOption\":\"USER_ENTERED\"}' --json '{\"values\":[[\"Name\",\"Score\"],[\"Alice\",95],[\"Bob\",87]]}'", "timeout": 30000}
{"command": "gws sheets spreadsheets.values append --params '{\"spreadsheetId\":\"SPREADSHEET_ID\",\"range\":\"Sheet1!A:A\",\"valueInputOption\":\"USER_ENTERED\"}' --json '{\"values\":[[\"Charlie\",92]]}'", "timeout": 30000}
{"command": "gws sheets spreadsheets get --params '{\"spreadsheetId\":\"SPREADSHEET_ID\",\"fields\":\"sheets.properties\"}'", "timeout": 30000}
{"command": "gws sheets spreadsheets.values clear --params '{\"spreadsheetId\":\"SPREADSHEET_ID\",\"range\":\"Sheet1!A1:D10\"}'", "timeout": 30000}
{"command": "gws sheets spreadsheets.values batchGet --params '{\"spreadsheetId\":\"SPREADSHEET_ID\",\"ranges\":\"Sheet1!A1:B5\",\"ranges\":\"Sheet2!A1:C3\"}'", "timeout": 30000}
https://docs.google.com/spreadsheets/d/{SPREADSHEET_ID}/edit.valueInputOption: USER_ENTERED (parses formulas/dates) or RAW (literal text).Sheet1!A1:D10, Sheet1!A:A (whole column), Sheet1 (whole sheet).fields parameter on spreadsheets.get to limit metadata size.gws schema sheets.spreadsheets.values.update to discover all parameters.