Sparrow Import for GitHub
Import GitHub issues and PRs into Google Sheets and keep them fresh.
What it imports
Pick an owner, a repository, issues or pull requests, and open, closed or all. Each one becomes a row in Google Sheets™: number, title, state, labels, assignees, author, milestone, comment count, dates, link and body. You need a personal access token with read access, for public and private repositories alike.
Connect your GitHub account
- Open https://github.com/settings/personal-access-tokens/new and create a fine-grained token with read access to Issues, Pull requests and Metadata. Copy it.
- In Google Sheets, open Extensions, then Sparrow Import for GitHub, then Open.
- In Connect, paste what you copied and press Test connection.
Free and Pro
| Free | Pro | |
|---|---|---|
| Saved imports | 1 | Unlimited |
| Rows per import | The first 500 | Every row, up to the Google Sheets limit of 10 million cells |
| Refresh | By hand, one click | By hand, or every hour or every day |
| Fields | The standard set, chosen for you | Pick any fields |
| Price | Free | USD 12 a month or USD 119 a year, per add-on and Google account, plus tax where it applies |
Price
After you buy, Freemius emails you a licence key. Paste it under "Have a licence key?" in the sidebar.
Questions
Where is my GitHub token stored?
A token is needed even for public repositories. In your own Google account, in the add-on's user storage (Apps Script user properties). It is never written into the sheet and never sent to us, so people you share the sheet with can't see it. Click Disconnect in the sidebar to remove it.
Does it change anything in GitHub?
No. The add-on only reads from GitHub. It never creates, edits or deletes anything there. It writes only to the sheet tab you pick in the spreadsheet you opened it in.
How often does it refresh?
Free imports refresh when you press Refresh in the sidebar or use Extensions, Sparrow Import for GitHub, Refresh all imports. Pro refreshes each import every hour or every day (hourly is the fastest Google allows for add-ons). If a scheduled run can't open the sheet, it refreshes the next time you open it. Big imports finish over several runs.
Can people I share the sheet with use it?
Yes. Saved imports live in the spreadsheet. Each person connects with their own GitHub token, and Pro is per Google account.
How do I cancel, and can I get a refund?
Cancel any time from the link in your Freemius emails, or write to us and we'll do it. Pro stays on until the end of the period you paid for. You can get a full refund within 14 days of a purchase: email sheets-help@sparrowplugins.com from the address you bought with.