██FR█████ █INTELL███████████

I Was Tired of Manually Tracking My GitHub Repos


This content originally appeared on DEV Community and was authored by Minh-Phuc Bui

Picture this: You’re maintaining 20+ GitHub repositories. You want to check which ones are getting stars, which have open issues that need attention, and maybe see how your overall portfolio is performing.

So you open GitHub… click on repo 1… check stars… back button… repo 2… check issues… back button…

Yeah, that was my Friday night routine. Terrible.

The “Aha!” Moment (And My AI Pair Programming Session)

I was staring at a Google Sheet for work when it hit me: What if I could just pull all my GitHub data directly into a spreadsheet?

Perfect time for some vibe coding. I fired up Claude AI and we started brainstorming. Google Sheets has Apps Script (basically JavaScript), GitHub has an API, and I had a Friday night free. Perfect storm.

What started as a simple idea quickly evolved into something way more powerful thanks to Claude’s suggestions – rate limiting, error handling, beautiful formatting, even a roadmap for future features.

What I Built: GitSheet

gitsheet results

GitSheet automatically fetches ALL your public repositories and displays:

  • ⭐ Stars, forks, watchers
  • 🐛 Open issues (separate from PRs!)
  • 🔄 Open pull requests
  • 📋 License info, language, size
  • 📅 Creation and update dates
  • 🍴 Fork detection
  • 🔗 Direct links to each repo

The best part? One button click updates everything.

The Technical Approach

Here’s the basic flow:

  1. Apps Script calls GitHub API to get user repositories
  2. Parse and clean the data (GitHub mixes issues with PRs, so I separate them)
  3. Populate Google Sheets with beautiful formatting
  4. Add progress indicators because waiting is less painful with feedback 
// Simplified version of the core function
function getGitHubStats(username) {
  const url = `https://api.github.com/users/${username}/repos`;
  const response = UrlFetchApp.fetch(url);
  const repos = JSON.parse(response.getContentText());

  // Process and format data
  return repos.map(repo => [
    repo.name,
    repo.stargazers_count,
    repo.forks_count,
    // ... more fields
  ]);
}

The Cool Technical Bits

Smart Rate Limiting: GitHub API has limits, so I added delays between requests and batch processing.

Issue vs PR Separation: GitHub’s API counts PRs as issues. I make separate calls to get accurate counts.

Error Handling: If one repo fails, the script continues with the others. No total failures.

Beautiful Formatting: Auto-sizing columns, number formatting, alternating row colors. It looks professional.

Why Google Sheets Though?

I considered building a web app, but Google Sheets has some serious advantages:

  • Zero hosting costs 💰
  • Familiar interface – everyone knows spreadsheets
  • Built-in features – sorting, filtering, charts, export
  • Sharing capabilities – send read-only copies to team members
  • Mobile access – works on phones automatically

Plus, you can create pivot tables, charts, and do analysis without writing more code.

The “Template Effect”

Here’s where it gets interesting. I can share this as a Google Sheets template. Anyone can:

  1. Copy my template
  2. Change the username to theirs
  3. Hit “update”
  4. Boom – instant GitHub analytics

No installation, no signup, no configuration. Just copy and go.

setup process

What’s Next?

Version 1.0 is read-only, but I’m already thinking about v2.0:

  • Write operations – edit repo descriptions directly in the sheet
  • Bulk tag management – update topics across multiple repos
  • Historical tracking – see how your repos grow over time
  • Team features – track organization repositories

Try It Yourself

If you want to give GitSheet a shot:

  1. View the template (you can see my actual data)
  2. File → Make a copy
  3. Follow the simple setup instructions
  4. Watch your GitHub stats populate automatically

The whole setup takes about 30 seconds.

Lessons Learned

Vibe coding with AI is incredibly productive. Having Claude as a coding partner meant I could focus on the vision while getting help with implementation details, error handling, and even product strategy.

Google Sheets is more powerful than you think. Apps Script turns it into a legitimate development platform.

APIs + Spreadsheets = Magic. This combination unlocks so many possibilities.

Simple solutions win. I could have built a complex web app, but a spreadsheet does everything I need.

Templates are viral. Making something easily copyable dramatically increases adoption.

The Real Win

The real satisfaction isn’t the stars or the technical achievement. It’s opening one tab, seeing all my repositories at a glance, and immediately knowing which ones need attention.

No more tab switching. No more manual checking. Just data, beautifully organized, updating with one click.

Sometimes the best solutions are the simplest ones.

What do you think? Have you built anything similar? What’s your favorite “simple solution to an annoying problem” project?

P.S. – The code is open source if you want to peek under the hood or contribute features!


This content originally appeared on DEV Community and was authored by Minh-Phuc Bui