GitHub → Google Sheets

For GitHub, create a fine-grained personal access token. Fine-grained tokens can be limited to specific repositories, have an expiration date, and use only the permissions your request needs.

1. Open GitHub's Personal access tokens page and click Generate new token, then choose Fine-grained token.
2. Give the token a clear name, such as API Import for Sheets, and choose an expiration date.
3. Choose the Resource owner that owns the repositories you want to query.
4. Under Repository access, choose Only select repositories when you only need specific private repositories. For public-only data, Public repositories is enough.
5. Under Permissions, keep access minimal. For reading issues, pull requests, commits, branches, and repository metadata, use Contents: Read-only; Metadata: Read-only is required by GitHub.
6. Click Generate token and copy the token immediately.
7. Open API Import for Sheets from the Google Sheets Extensions menu.
8. Select GitHub from the API selector.
9. Under Credentials, click Add another credential.
10. Paste the token and click Save Credential.
11. Select the saved credential from the dropdown and run your prompt.