A dual-integration skill that synchronizes GitHub issue creation with Google Sheets task tracking for streamlined project management.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install pms-task
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install pms-task using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is PMS Task Sync & Tracker?
The PMS Task Sync skill is a specialized automation tool designed for developers and project managers using Openclaw Skills. It bridges the gap between technical issue tracking on GitHub and administrative record-keeping in Google Sheets. By using simple triggers like "PMS Bug addition" or "PMS Feature addition," the agent handles the heavy lifting of issue labeling, assignee management, and multi-sheet data entry.
This skill ensures that every bug or feature request is documented consistently across both platforms, reducing manual data entry errors and keeping team members aligned. It is particularly useful for teams maintaining a centralized task tracker alongside their source code repository, providing a single source of truth for project status.
PMS Task Sync & Tracker Use Cases
- Log technical bugs directly to GitHub while automatically updating a project management spreadsheet.
- Request new features and have them instantly reflected in a team's daily update log for stakeholder visibility.
- Maintain a synchronized Task Tracker for stakeholders who prefer Google Sheets over GitHub interfaces.
- Automate the generation of incremental Task IDs for internal project accounting and referencing.
How PMS Task Sync & Tracker Works
- The user triggers the workflow by saying "PMS Bug addition" or "PMS Feature addition" within an environment supported by Openclaw Skills.
- The agent identifies the task type and prompts for missing details such as title, description, priority (P0-P3), and reproduction steps (for bugs).
- A GitHub issue is created using the gh CLI with specific labels and assigned to the project lead.
- The agent retrieves the latest Task ID from the Production tab of the PMS Task Tracker Google Sheet to determine the next increment.
- It appends a new row to the spreadsheet with metadata, including the generated GitHub URL and formatted date.
- Finally, it updates the Team Daily Update sheet, appending the new task to the log for the current date.
PMS Task Sync & Tracker Setup
To use this skill within the Openclaw Skills framework, ensure you have the GitHub CLI and the Google Sheets CLI (gog) installed and authenticated.
# Log in to GitHub
gh auth login
# Configure Google Sheets access
gog auth login
The skill is pre-configured to target specific Sheet IDs for the Task Tracker and Daily Update logs. Ensure your environment has the necessary permissions to write to these documents.
PMS Task Sync & Tracker Data Schema & Taxonomy
The skill organizes data using a structured taxonomy across GitHub and Google Sheets:
GitHub Labels & Priority
| Label | Purpose | Priority Level |
|---|---|---|
| bug | Software errors | P0 (Critical) |
| enhancement | New features | P1 (High) |
| P2/P3 | Lower impact | P2 (Med)/P3 (Low) |
Google Sheets Column Mapping (A-K)
| Column | Field | Description |
|---|---|---|
| A | Task ID | Unique ID (PMS-TSKXXX) |
| B | Description | Brief summary of the task |
| E | Status | Initialized as New |
| F | Task Type | Issue or Feature |
| I | Resolution Notes | Direct link to the GitHub Issue |
PMS Task Sync & Tracker Advanced Features
- Intelligent Task ID incrementing logic that reads the last entry in Google Sheets to prevent ID collisions.
- Context-aware issue templates that toggle between reproduction steps for bugs and use-case justifications for features.
- Multi-destination synchronization that updates both a master project tracker and a daily team activity log simultaneously.
- Automated assignee and reporter management to maintain consistent ownership records within Openclaw Skills.
SKILL.md
Loading
Related Openclaw Skills
AI Curriculum Generator
An intelligent educational curriculum generation system featuring automated resource discovery and strict human-in-the-loop escalation policies.
Social Draft
A dual-platform content automation tool that transforms technical updates into high-engagement Twitter and LinkedIn posts simultaneously.
mac-node-snapshot
A robust macOS screen capture utility that uses short video recordings to extract high-quality PNG snapshots, bypassing traditional permission hurdles.
ABIXUS Deterministic Oracle
A high-performance validation layer ensuring consistency and state verification for autonomous agents on the Polygon PoS network.
Financial Calculator
A powerful financial engine for calculating investment growth, loan values, and pricing strategies via CLI or an interactive web interface.
A2A Market Skill
A marketplace integration enabling AI agents to autonomously buy, sell, and monetize skills using USDC on Base and a credits-based reward system.
Featured*
