Sample workflowMedium complexityGitHubGoogle Sheets

GitHub Commits → Hour Logger

Turn daily commit activity into time-log entries so developers don’t have to fill out timesheets manually.

Demo

Short walkthrough showing the workflow end-to-end.

Demo available on request

We can walk you through this workflow and how it would fit your tools and constraints.

What it helps with

Developers forget to log hours or spend time reconstructing what they worked on at the end of the week. Timesheets are inaccurate, project managers lack visibility, and billing suffers.

What it does

  • Collects commits from specified GitHub repos on a daily schedule
  • Groups commits by developer and project, then summarizes the work
  • Estimates time spent based on commit frequency, size, and context
  • Writes time-log entries to a shared Google Sheet for review

How it works (high level)

  1. 1Run on a daily schedule via cron or webhook trigger
  2. 2Pull commit data from the GitHub API for the past 24 hours
  3. 3Use an LLM to summarize commit messages into human-readable work descriptions
  4. 4Estimate hours and write rows to Google Sheets, flagging anything that needs manual review

Want this for your team?

We'll adapt the workflow to your rules, approvals, and systems—then harden it for production.

Have a similar workflow in mind?

We'll scope it, build a proof-of-concept, and get it running.

    GitHub Commits → Hour Logger | Sample workflow | Kwanso | Kwanso