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

BlankWhat to giveExample
sheet urlThe Google Sheet with repository links in column Ahttps://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

RepositoryStarsLast releaseLast commitLicenseWeekly downloads
quillset/tidy-csv8,4102 October 202627 October 2026MIT212,000 (npm)
fernlab/pyreport1,92011 January 20253 March 2025Apache-2.018,400 (PyPI)
northwind-labs/jsonfold640None14 August 2026NoneNone

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

  1. 01

    Open it

    Click Use in Cuiar on this page. The side panel opens with the task in the composer.

  2. 02

    Fill in the blank

    Type sheet url. Tab moves to the next blank.

  3. 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/mcp

2. 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."
  }
}
All data templates