PMS Task
by @tarasinghrajput
Create PMS tasks (bugs or features) on GitHub and sync to Google Sheets. Use when user says 'PMS Bug addition' for bugs or 'PMS Feature addition' for feature...
clawhub install pms-taskπ About This Skill
name: pms-task description: "Create PMS tasks (bugs or features) on GitHub and sync to Google Sheets. Use when user says 'PMS Bug addition' for bugs or 'PMS Feature addition' for features. Creates GitHub issue with appropriate labels, assigns to roshanasingh4, updates PMS Task Tracker sheet and Team Daily Update sheet."
PMS Task Addition (Bug & Feature)
Streamlined workflow for logging PMS bugs AND features to GitHub and Google Sheets.
Trigger
User message contains:Workflow
1. Determine Task Type
Based on trigger phrase: | Trigger | Type | GitHub Label | Sheet Task Type | |---------|------|--------------|-----------------| | "PMS Bug addition" | Bug |bug | Issue |
| "PMS Feature addition" | Feature | enhancement | Feature |2. Collect Task Information
Ask the user for (if not provided):3. Create GitHub Issue
#### For BUGS:
gh issue create --repo roshanasingh4/apni-pathshala-pms \
--title "" \
--body "$(cat <Description
Steps to Reproduce
1.
2.
3. Expected Outcome
Actual Outcome
EOF
)" \
--label "bug," \
--assignee roshanasingh4
#### For FEATURES:
gh issue create --repo roshanasingh4/apni-pathshala-pms \
--title "" \
--body "$(cat <Feature Request
Expected Behavior
Use Case
Why is this feature needed?
EOF
)" \
--label "enhancement," \
--assignee roshanasingh4
Capture the issue URL from output for the sheet.
4. Update PMS Task Tracker Sheet
Sheet ID:1O07SzGzQa2FwpkBE7h2SUDWZlxsUpz8DxCpyxKjRi8U
Tab: Production#### Column Mapping (A-K)
| Col | Name | Value |
|-----|------|-------|
| A | Task ID | PMS-TSKXXX (increment from last entry) |
| B | Description | Issue title |
| C | Reporter | Tara Singh Kharwad |
| D | Date Submitted | DD/MM/YYYY (issue creation date) |
| E | Status | New |
| F | Task type | Issue (bug) / Feature (enhancement) / Testing |
| G | Priority | Critical (P0) / High (P1) / Medium (P2) / Low (P3) |
| H | Assigned To | tarasinghrajput7261@gmail.com |
| I | Resolution Notes | GitHub issue URL |
| J | Resolution Date | (empty until closed) |
| K | Took Help from Roshan | (leave empty - Tara fills manually) |
#### Label to Sheet Mapping
| GitHub Label | Task Type | Priority | |--------------|-----------|----------| | bug | Issue | - | | enhancement | Feature | - | | P0 | - | Critical | | P1 | - | High | | P2 | - | Medium | | P3 | - | Low |
#### Get Next Task ID
gog sheets get 1O07SzGzQa2FwpkBE7h2SUDWZlxsUpz8DxCpyxKjRi8U "Production!A:A" --json | jq '.values | .[-1][0]'
Then increment the number.#### Append to Sheet (BUG)
gog sheets append 1O07SzGzQa2FwpkBE7h2SUDWZlxsUpz8DxCpyxKjRi8U "Production!A:K" \
--values-json '[["PMS-TSK-XXX","","Tara Singh Kharwad","DD/MM/YYYY","New","Issue","Low","tarasinghrajput7261@gmail.com","","",""]]' \
--insert INSERT_ROWS
#### Append to Sheet (FEATURE)
gog sheets append 1O07SzGzQa2FwpkBE7h2SUDWZlxsUpz8DxCpyxKjRi8U "Production!A:K" \
--values-json '[["PMS-TSK-XXX","","Tara Singh Kharwad","DD/MM/YYYY","New","Feature","Low","tarasinghrajput7261@gmail.com","","",""]]' \
--insert INSERT_ROWS
5. Update Team Daily Update Sheet
Sheet ID:1GgRgfVBrF-ReGPRmntT6Cm2BjiLzJ3JiBaC4lMfrMQsFind row with today's date, append to Column B with format:
- PMS - -
#### Format for Daily Tasks Each day's tasks are in a single cell with headings and bullet points:
- PMS - Fixed login button issue - https://github.com/...
PMS - Added export feature - https://github.com/...
#### Get Today's Row
# Find row with today's date
gog sheets get 1GgRgfVBrF-ReGPRmntT6Cm2BjiLzJ3JiBaC4lMfrMQs "Sheet1!A:B" --json
Look for today's date (DD/MM/YYYY) in Column A
#### Update Cell
# Append to existing content in Column B
gog sheets update 1GgRgfVBrF-ReGPRmntT6Cm2BjiLzJ3JiBaC4lMfrMQs "Sheet1!B" \
--values-json '[["\n- PMS - - "]]'
Priority Guide
| Priority | Label | When to Use | |----------|-------|-------------| | P0 | Critical | System down, data loss, security issue | | P1 | High | Major feature broken/needed, many users affected | | P2 | Medium | Feature partially working/needed, workaround exists | | P3 | Low | Minor issue, cosmetic, low impact |
Example Usage
Bug Example
User: "PMS Bug addition - Login page crashes on mobile"Response:
1. Detect: BUG β GitHub label: bug, Sheet type: Issue
2. Ask for details (steps, expected outcome, priority)
3. Create GitHub issue with bug template β get URL
4. Get next Task ID from sheet
5. Append to PMS Task Tracker with Task type = "Issue"
6. Update Team Daily Update sheet with new entry
Feature Example
User: "PMS Feature addition - Add dark mode support"Response:
1. Detect: FEATURE β GitHub label: enhancement, Sheet type: Feature
2. Ask for details (description, expected behavior, use case, priority)
3. Create GitHub issue with feature template β get URL
4. Get next Task ID from sheet
5. Append to PMS Task Tracker with Task type = "Feature"
6. Update Team Daily Update sheet with new entry
Quick Reference
| Trigger | GitHub Label | Sheet Task Type | Issue Template |
|---------|--------------|-----------------|----------------|
| PMS Bug addition | bug | Issue | Bug report with reproduction steps |
| PMS Feature addition | enhancement | Feature | Feature request with use case |