google-sheets-tracker

Community

Track project data in Google Sheets.

Authorgonzalezpazmonica
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill provides a lightweight, visual alternative for managing project tasks and metrics, enabling non-technical roles like Product Owners and stakeholders to interact with project data without needing direct access to complex tools like Azure DevOps.

Core Features & Use Cases

  • Visual Task Tracking: Monitor task status, assignees, and estimates in a familiar spreadsheet format.
  • Real-time Metrics: View sprint velocity, burndown progress, and completion percentages updated automatically.
  • Risk Management: Track identified risks, their impact, mitigation plans, and current status.
  • Bidirectional Synchronization: Changes made in Google Sheets (e.g., status updates) are reflected in Azure DevOps, and vice-versa.
  • Use Case: A Product Owner can easily check the status of all user stories for the current sprint and update their status directly in Google Sheets, which then syncs with the main project board in Azure DevOps.

Quick Start

Use the google-sheets-tracker skill to update the status of task with ID 'TASK-123' to 'Done'.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: google-sheets-tracker
Download link: https://github.com/gonzalezpazmonica/pm-workspace/archive/main.zip#google-sheets-tracker

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.