skills.rest
mporenta
mporentaCOMMUNITY
Explore all skills by this author →
GitHub

ids-hours-tracking

Compute monthly work hours from merged GitHub PRs and post them to the IDS Tracking Google Sheet.

Updated Aug 27, 2026
Search Tags:#automation#google-sheets#data-integration#calculate#github-prs#hours#ids-tracking
One-click install
npx skills add https://github.com/mporenta/airflow --skill ids-hours-tracking
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ids-hours-tracking
Source: https://github.com/mporenta/airflow/tree/main/.claude/skills/ids-hours-tracking
Command: npx skills add https://github.com/mporenta/airflow --skill ids-hours-tracking

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires aiohttp.

What problem does it solve?

Calculates monthly working hours from merged GitHub PRs and posts them to the IDS Tracking Google Sheet. The workflow helps teams convert development activity into a shared timesheet, reducing manual tracking.

Core Features & Use Cases

  • Automated hours calculation: derives daily work hours from merged PRs across multiple repos and assigns them to MST dates.
  • IDS integration: filters PRs by IDS=Yes in the Data Engineering GitHub project and updates the sheet after posting.
  • Dry-run safety & posting: offers a dry run to preview results before actually writing to the sheet, and supports an option to post.

Quick Start

Run the dry run to preview the IDS hours per day for a given month, then confirm to post.

Frequently Asked Questions about ids-hours-tracking

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I calculate monthly work hours from merged GitHub PRs automatically?▼

The workflow filters merged PRs across multiple repositories by the IDS=Yes label in a Data Engineering GitHub project, derives daily MST work hours, and applies per-PR hour caps with overflow redistribution.

How do I post calculated work hours to a Google Sheets tracking sheet?▼

The workflow uses the aiohttp library to call a Google Apps Script endpoint, requiring the IDS_TRACKING_API_KEY environment variable to authenticate and update the IDS Tracking Google Sheet.

Do I need the gh CLI to track hours from GitHub pull requests?▼

Yes, the gh CLI is required to query merged pull requests across multiple repositories, alongside the IDS_TRACKING_API_KEY environment variable and the aiohttp library.

Can I preview hours calculation before posting to the Google Sheet?▼

Yes, you can run a dry-run preview to review the calculated IDS hours per day for a given month before confirming the final posting to the Google Sheet, ensuring data accuracy.

How does per-PR hour cap and overflow redistribution work for timesheet tracking?▼

Per-PR hour caps limit the maximum hours assigned to a single pull request, and overflow redistribution moves excess hours to other dates, ensuring accurate daily hour totals without exceeding individual PR limits.

What is the best way to automate timesheet updates from GitHub development activity?▼

The best way is using a workflow that calculates work hours from merged PRs across multiple repos and posts them directly to a shared Google Sheet via an Apps Script endpoint, reducing manual tracking.

Related Skills

Explore More Data & Analytics Skills→
AlexiosBluffMaraAlexiosBluffMara
2

github-auth

Authenticate the Hermes Agent with GitHub via git or the gh CLI.

Community
Intermediate
cellarwoodcellarwood

recipe-copy-sheet-for-new-month

Duplicate a Google Sheets template tab and rename it for a new month.

Official
Basic
Awannaphasch2016Awannaphasch2016

google-sheets

Read, write, and format Google Sheets using Python and gspread.

Community
Intermediate
AstravueOrgAstravueOrg
12

tracking-time

Track work hours on tasks with timers or manual entries in Astravue.

Official
Intermediate