dvcrn PMS Task Addition (Bug & Feature)
Streamlined workflow for logging PMS bugs AND features to GitHub and Google Sheets.
Trigger
User message contains:
- "PMS Bug addition" → Creates a BUG report
- "PMS Feature addition" → Creates a FEATURE request
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):
- Title: Brief summary
- Description: What's happening (bug) or what's needed (feature)
- Reproduction Steps: (Bugs only) How to reproduce
- Expected Outcome: What should happen
- Priority: P0 (Critical) / P1 (High) / P2 (Medium) / P3 (Low)
3. Create GitHub Issue
For BUGS:
gh issue create --repo roshanasingh4/apni-pathshala-pms \
--title "<title>" \
--body "$(cat <<EOF
## Description
<description>
## Steps to Reproduce
1. <step 1>
2. <step 2>
3. <step 3>
## Expected Outcome
<expected outcome>
## Actual Outcome
<what actually happened>
EOF
)" \
--label "bug,<priority>" \
--assignee roshanasingh4
For FEATURES:
gh issue create --repo roshanasingh4/apni-pathshala-pms \
--title "<title>" \
--body "$(cat <<EOF
## Feature Request
<description>
## Expected Behavior
<expected outcome>
## Use Case
Why is this feature needed?
EOF
)" \
--label "enhancement,<priority>" \
--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","<title>","Tara Singh Kharwad","DD/MM/YYYY","New","Issue","Low","tarasinghrajput7261@gmail.com","<github_url>","",""]]' \
--insert INSERT_ROWS
Append to Sheet (FEATURE)
gog sheets append 1O07SzGzQa2FwpkBE7h2SUDWZlxsUpz8DxCpyxKjRi8U "Production!A:K" \
--values-json '[["PMS-TSK-XXX","<title>","Tara Singh Kharwad","DD/MM/YYYY","New","Feature","Low","tarasinghrajput7261@gmail.com","<github_url>","",""]]' \
--insert INSERT_ROWS
5. Update Team Daily Update Sheet
Sheet ID: 1GgRgfVBrF-ReGPRmntT6Cm2BjiLzJ3JiBaC4lMfrMQs
Find row with today's date, append to Column B with format:
- PMS - <title> - <github_url>
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<row>" \
--values-json '[["<existing_content>\n- PMS - <title> - <github_url>"]]'
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:
- Detect: BUG → GitHub label:
bug, Sheet type:Issue - Ask for details (steps, expected outcome, priority)
- Create GitHub issue with bug template → get URL
- Get next Task ID from sheet
- Append to PMS Task Tracker with Task type = "Issue"
- Update Team Daily Update sheet with new entry
Feature Example
User: "PMS Feature addition - Add dark mode support"
Response:
- Detect: FEATURE → GitHub label:
enhancement, Sheet type:Feature - Ask for details (description, expected behavior, use case, priority)
- Create GitHub issue with feature template → get URL
- Get next Task ID from sheet
- Append to PMS Task Tracker with Task type = "Feature"
- 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 |
Notes
- Reporter is ALWAYS "Tara Singh Kharwad"
- Assigned To is ALWAYS "tarasinghrajput7261@gmail.com"
- Resolution Notes = GitHub issue URL
- "Took Help from Roshan" is left empty (Tara fills manually)
- Date format: DD/MM/YYYY only
- Status starts as "New"