roster
par kleberbaum
Git & GitHubRésumé
Creates weekly shift rosters (KW-JSON) from CSV availability data and pushes them to GitHub.
Description
Ce que fait ce skill
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.
Quand l'utiliser
- 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
Exemple de 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
Prérequis
- 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/rosterExécute la commande CLI, ou colle l'instruction dans Claude Code, Cursor, Codex ou l'agent de code que tu utilises.