Collect stats for a list of GitHub repositories
Stars, last release, last commit, license, issues and downloads for each repository, in your sheet.
- You start it: When you start it
What it does
The task
Open the sheet sheet url, and read the GitHub repository in column A of each row. For each repository, record the stars, the forks, the license, the date of the last release and of the last commit, the number of contributors, the open issues and the issues closed in the last 90 days. When it publishes a package on npm or PyPI, add the weekly downloads. Write the values in new columns with the date of the check. Mark the repositories that are archived or have no commit in 12 months.
- It works in GitHub, npm, PyPI and Google Sheets, in the workspace you pick, and signs in with passwords from your Cuiar vault.
- It runs once, when you start it.
What you give it
| Blank | What to give | Example |
|---|---|---|
| sheet url | The Google Sheet with repository links in column A | https://docs.google.com/spreadsheets/d/1Gh4rLm8Vn/edit |
What you get back
An example run with the example values above. Your run uses your own data.
Repositories checked: 34
| Repository | Stars | Last release | Last commit | License | Weekly downloads |
|---|---|---|---|---|---|
| quillset/tidy-csv | 8,410 | 2 October 2026 | 27 October 2026 | MIT | 212,000 (npm) |
| fernlab/pyreport | 1,920 | 11 January 2025 | 3 March 2025 | Apache-2.0 | 18,400 (PyPI) |
| northwind-labs/jsonfold | 640 | None | 14 August 2026 | None | None |
Archived: 2. No commit in 12 months: 5
No license: 3, so you cannot reuse the code safely
Sheet: new columns F to O, checked on 29 October 2026
Run it in Cuiar
- 01
Open it
Click Use in Cuiar on this page. The side panel opens with the task in the composer.
- 02
Fill in the blank
Type sheet url. Tab moves to the next blank.
- 03
Run it
Run sends it to the agent. Follow each step in the panel, and stop it at any time.
From the terminal
cuiar exec "Open the sheet https://docs.google.com/spreadsheets/d/1Gh4rLm8Vn/edit, and read the GitHub repository in column A of each row. For each repository, record the stars, the forks, the license, the date of the last release and of the last commit, the number of contributors, the open issues and the issues closed in the last 90 days. When it publishes a package on npm or PyPI, add the weekly downloads. Write the values in new columns with the date of the check. Mark the repositories that are archived or have no commit in 12 months."Run it from your AI agent
Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call run_task yourself.
1. Add Cuiar to Claude Code
claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp2. Ask your agent
Use the Cuiar tool run_task to run my "Collect stats for a list of GitHub repositories" template with sheet url = https://docs.google.com/spreadsheets/d/1Gh4rLm8Vn/edit.Setup for other agents: AI agents.
The tool call
{
"name": "run_task",
"arguments": {
"task": "Open the sheet https://docs.google.com/spreadsheets/d/1Gh4rLm8Vn/edit, and read the GitHub repository in column A of each row. For each repository, record the stars, the forks, the license, the date of the last release and of the last commit, the number of contributors, the open issues and the issues closed in the last 90 days. When it publishes a package on npm or PyPI, add the weekly downloads. Write the values in new columns with the date of the check. Mark the repositories that are archived or have no commit in 12 months."
}
}Related templates
All data templatesEngineering
Read the changelogs before you upgrade dependencies
Breaking changes, security fixes and upgrade steps for each outdated package, from its release notes.
You start it: When you start it- GitHub
- npm
- PyPI
Engineering
Compare open-source libraries before you pick one
Downloads, releases, open issues, license and size of each library, with a recommendation.
You start it: When you start it- GitHub
- npm
- PyPI
Engineering
Find flaky tests in your CI runs
Tests that fail and then pass on the same commit, with the count and the error, from your recent runs.
You start it: When you start it- GitHub
- Google Sheets
Monitoring
Watch security advisories for the software we use
New vulnerabilities in the products and versions that you run, with the severity and the fixed version.
On a schedule: Every weekday at 8:00- GitHub
- Any website
- Google Sheets
Data
Turn a list on a website into a sheet
Each item from each page, one row for each, with no duplicates.
You start it: When you start it- Any website
- Google Sheets
Data
List local businesses with their contacts
Name, address, phone, website, rating and e-mail for each business.
You start it: When you start it- Google Maps
- Google Sheets