Setup & Installation
Or with the ClawHub CLI, for registry-managed skill folders outside a full OpenClaw workspace:
Version History
Refactor: use separate timeStart/timeEnd fields instead of combined time with -- separator in KW JSON format.
What This Skill Does
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.
When to use it
- 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
Example Workflow
Here's how your AI assistant might use this skill in practice.
User asks: uploads a Google Forms CSV with employee availability for the upcoming week
- 1Load current employee data from GitHub via get-employees.sh
- 2Parse CSV column headers to detect calendar week and per-employee time windows
- 3Build roster JSON respecting car capacity, trainer priority, departure times, and hour limits
- 4Validate every shift slot against time window, trainer assignment, and capacity rules
- 5Show 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
Requirements
Accounts, API keys, or tools you or your AI assistant may need to set up while using this skill.