Skip to content
TakoAPI
Back to skills

roster

by kleberbaum

Git & GitHub
520Downloads reported by clawskills.sh
1Views
0 likesSign in to like this skill
—Not yet rated
Your rating

Brief

Creates weekly shift rosters (KW-JSON) from CSV availability data and pushes them to GitHub.

Description

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

INPUT

User asks: uploads a Google Forms CSV with employee availability for the upcoming week

AGENT
  1. 1

    Load current employee data from GitHub via get-employees.sh

  2. 2

    Parse CSV column headers to detect calendar week and per-employee time windows

  3. 3

    Build roster JSON respecting car capacity, trainer priority, departure times, and hour limits

  4. 4

    Validate every shift slot against time window, trainer assignment, and capacity rules

  5. 5

    Show Telegram-formatted preview, then push JSON to GitHub and trigger PDF build or email distribution on confirmation

OUTPUT

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

  • 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/roster

Run the CLI command, or paste the prompt into Claude Code, Cursor, Codex or whichever coding agent you use.

Links