weekly-sheet-skill v1.0.0

Auto-fill weekly Google Sheets from Git, Obsidian vault, and Gmail via gwx.

Install

# npm
npm install -g weekly-sheet-skill

# PyPI
pip install weekly-sheet-skill

# git clone
git clone https://github.com/redredchen01/weekly-sheet-skill.git ~/.claude/skills/weekly-sheet

Quick Start

# 1. Configure
weekly-sheet-init

# 2. Collect data
weekly-sheet

# 3. In Claude Code
/weekly-sheet

Prerequisites

• gwx — Google Workspace CLI (npm install -g gwx-cli)
• gwx authenticated: gwx auth login --services=sheets,gmail,calendar,drive
• Target Google Sheet must be native Google Sheet (not .xlsx)

Commands

| Command | Description | |---------|-------------| | weekly-sheet | Collect this week's data from Git/Obsidian/Gmail | | weekly-sheet-init | Setup wizard: configure Sheet IDs, paths | | weekly-sheet-status | Show current config and last fill status |

Claude Code Skill

Use /weekly-sheet in Claude Code. The skill:

1. Reads your config (~/.config/weekly-sheet/config.json)
2. Collects data from Git commits, Obsidian vault, Gmail daily reports
3. Auto-detects sheet type (weekly overview / workflow detail / warehouse)
4. Writes directly to Google Sheet via gwx sheets

Supported Sheet Types

| Header pattern | Sheet type | |---------------|-----------| | 周次, 本周产出工作流数量... | Weekly Overview | | 工作流编号, 使用场景, 本周使用次数... | Workflow Detail | | 工作流编号, 场景分类, 一句话说明... | Workflow Warehouse |

Config

Stored at ~/.config/weekly-sheet/config.json:

{
  "sheets": {
    "weekly_overview": "<SHEET_ID>",
    "workflow_warehouse": "<SHEET_ID>"
  },
  "owner": "Your Name",
  "team": "Your Team",
  "obsidian_path": "~/path/to/obsidian/",
  "git_root": "~/path/to/repos/"
}

License

MIT