starghaze

README

stargaze

Save information about starred GitHub repos to a CSV or JSON file, and upload CSVs to Google Sheets!

Click here to see My GitHub Stars Google Sheet

Thanks to https://github.com/yks0000/starred-repo-toc for the inspiration!

GraphQL and Google Sheets auth notes at ./dev_notes.md

Install

• Homebrew: brew install bbkane/tap/starghaze
• Download Mac/Linux/Windows executable: GitHub releases
• Go: go install github.com/bbkane/starghaze@latest
• Build with goreleaser after cloning: goreleaser --snapshot --skip-publish --rm-dist

Save Stars to Google Sheets

Download Star Info

GITHUB_TOKEN=my_github_token starghaze download \
	--include-readmes true \
	--output stars.jsonl

Format Downloaded Stars as CSV

starghaze format \
	--input stars.jsonl \
	--format csv \
	--include-readmes false \
	--output stars.csv

Upload CSV to Google Sheets

GOOGLE_APPLICATION_CREDENTIALS=/path/to/keys.json starghaze gsheets upload \
    --csv-path stars.csv \
    --sheet-id 0 \
    --spreadsheet-id 15AXUtql31P62zxvEnqxNnb8ZcCWnBUYpROAsrtAhOV0 \
    --timeout 30s

Save Stars to Zinc

Download Star Info

GITHUB_TOKEN=my_github_token starghaze download \
	--include-readmes true \
	--output stars.jsonl

Format Downloaded Stars as Zinc

starghaze format \
	--include-readmes true \
	--input stars.jsonl \
	--format zinc \
	--output stars.zinc

Upload to Zinc

Using default settings - See Zinc repo for more details.

curl http://localhost:4080/api/_bulk -i -u admin:Complexpass#123 --data-binary "@stars.zinc"