Metadata

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:

"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"