Agent Skills › outworked/outworked › Google Sheets

Google Sheets

GitHub

用于读取、写入和管理 Google Sheets 电子表格。支持按范围读写数据、追加行、创建新表格及获取元数据，适用于数据处理与日志记录场景。

electron/skills/google-sheets/SKILL.md outworked/outworked

触发场景

需要读取或更新 Google Sheets 中的数据需要创建新的电子表格或追加日志数据

安装

npx skills add outworked/outworked --skill Google Sheets -g -y

更多选项

非标准路径

npx skills add https://github.com/outworked/outworked/tree/main/electron/skills/google-sheets -g -y

不安装直接使用

npx skills use outworked/outworked@Google Sheets

指定 Agent (Claude Code)

npx skills add outworked/outworked --skill Google Sheets -a claude-code -g -y

安装 repo 全部 skill

npx skills add outworked/outworked --all -g -y

预览 repo 内 skill

npx skills add outworked/outworked --list

SKILL.md

Frontmatter

{
    "auth": {
        "type": "oauth2",
        "scopes": [
            "https:\/\/www.googleapis.com\/auth\/spreadsheets"
        ],
        "provider": "google"
    },
    "name": "Google Sheets",
    "emoji": "📊",
    "tools": [
        "sheets:read",
        "sheets:write",
        "sheets:append",
        "sheets:create",
        "sheets:get_metadata"
    ],
    "runtime": "google-sheets",
    "description": "Read, write, and manage Google Sheets spreadsheets"
}

Google Sheets Skill

You can read, write, and manage Google Sheets spreadsheets.

Tools

sheets:read — Read a range of cells (e.g. Sheet1!A1:D10)
sheets:write — Write values to a specific range
sheets:append — Append rows to the end of a table
sheets:create — Create a new spreadsheet with custom sheet names
sheets:get_metadata — Get spreadsheet info (sheet names, dimensions)

Tips

The spreadsheetId is the long ID in the URL: docs.google.com/spreadsheets/d/{spreadsheetId}/edit
Ranges use A1 notation: Sheet1!A1:D10, Sheet1!A:A (whole column), Sheet1!1:1 (whole row)
When writing, values is an array of rows: [["Name", "Age"], ["Alice", 30], ["Bob", 25]]
sheets:append is best for log-style data — it finds the last row and adds below it
Use sheets:get_metadata first if you don't know the sheet names