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:

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 |

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"