roster
von kleberbaum
Git & GitHubKurzbeschreibung
Creates weekly shift rosters (KW-JSON) from CSV availability data and pushes them to GitHub.
Beschreibung
Was dieser Skill macht
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.
Wann du ihn einsetzt
- 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
Beispiel-Workflow
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
Voraussetzungen
- 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
Installation
clawhub install kleberbaum/rosterFühre den CLI-Befehl aus oder füge den Prompt in Claude Code, Cursor, Codex oder deinen Coding-Agenten ein.