roster
kleberbaum 作
Git & GitHub概要
Creates weekly shift rosters (KW-JSON) from CSV availability data and pushes them to GitHub.
説明
このスキルでできること
Creates weekly shift rosters for field sales teams from Google Forms CSV availability data and pushes them to GitHub. Handles driver assignments, trainer-trainee groupings, minor employee protections, and weekly hour limits. Triggers PDF generation and email distribution via GitHub Actions workflows.
Automates the full roster pipeline from CSV parsing to PDF delivery, replacing manual spreadsheet work and separate distribution steps.
使いどころ
- Planning weekly field sales shifts from a Google Forms availability CSV
- Assigning trainers to untrained employees across each shift day
- Sending a PDF roster preview directly to a Telegram chat
- Emailing the finalized weekly shift plan to all employees
- Tracking hour limits for part-time and minor employees across the week
ワークフロー例
User asks: uploads a Google Forms CSV with employee availability for the upcoming week
- 1
Load current employee data from GitHub via get-employees.sh
- 2
Parse CSV column headers to detect calendar week and per-employee time windows
- 3
Build roster JSON respecting car capacity, trainer priority, departure times, and hour limits
- 4
Validate every shift slot against time window, trainer assignment, and capacity rules
- 5
Show Telegram-formatted preview, then push JSON to GitHub and trigger PDF build or email distribution on confirmation
Weekly shift roster uploaded as KW-XX-YYYY.json to the configured GitHub repository, with PDF delivered to Telegram or emails sent to all employees
要件
- GITHUB_TOKEN environment variable (fine-grained GitHub PAT with contents:write and actions:write scoped to the target repository)
- ROSTER_REPO environment variable (owner/repo of the target GitHub repository)
- GitHub repository configured with build-roster.yml and publish-roster.yml workflow files
インストール
clawhub install kleberbaum/rosterCLIコマンドを実行するか、Claude Code、Cursor、Codexなどお使いのコーディングエージェントにプロンプトを貼り付けてください。