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