← All integrations
GitHub

GitHub → Google Sheets™

GitHub repository, issue, pull request, commit, and release data.

API Import for Google Sheets™ lets you connect GitHub with the most popular apps, so you can automate your work and have more time for what matters most — no code required.

GitHub App

GitHub is the largest code hosting platform, used by tens of millions of developers to manage repositories, track issues, review pull requests, and coordinate releases. Public repository data is available without authentication — useful for tracking open-source projects, contributor activity, or release history. For private repositories, connect via the API Import GitHub App or a fine-grained personal access token. Once connected, you can pull issues, PRs, commits, and release data into Google Sheets™ for engineering dashboards, sprint tracking, or cross-team reporting.

Example prompts
“Get the latest 50 open issues from octocat/hello-world”
“Show me a list of my repos”
“List open pull requests from octocat/hello-world”
“Get recent commits from octocat/hello-world”
“List releases from octocat/hello-world”
How to get credentials
Recommended: Public GitHub repository requests can run without credentials. To read private repositories or use installed-repository access, connect the API Import GitHub App from the sidebar.
Recommended — Connect the GitHub App
  1. Open API Import for Sheets from the Google Sheets™ Extensions menu.
  2. Select GitHub from the API selector.
  3. Under Authentication, click Connect GitHub App.
  4. Authorize GitHub in the popup. If GitHub asks you to install the app, choose the account and repositories the connector should read.
  5. Return to the sidebar. Wait for the GitHub credential to appear, or click Refresh Connection.
  6. Select the connected GitHub credential from the dropdown and run your prompt.
Set up a self-managed GitHub App

Use this only if you manage a private API Import Apps Script™ deployment. The production add-on uses the official API Import GitHub App.

  1. Open GitHub Settings, then Developer settings, then GitHub Apps.
  2. Create a GitHub App named API Import for Sheets.
  3. Set the Callback URL to the Apps Script deployment you are testing.

GitHub Apps allow one active user authorization callback URL for this setup. Use one GitHub App for staging:

https://script.google.com/macros/d/133aXIYKY_eNzCnt-2t_buoqXENQA2jSMRqhKxjly2OGqaZ-FvvVBgDKy/usercallback

Use a separate GitHub App for production:

https://script.google.com/macros/d/1MM5flAOQ3nGmBsxbaH1ceWyt8aVlsu9U4avHWFNaXbXUaI2xXYiAIluE/usercallback
  1. Enable Request user authorization (OAuth) during installation.
  2. Leave webhooks disabled for API Import v1.
  3. Grant read-only repository permissions for Metadata, Contents, Issues, and Pull requests.
  4. Copy the GitHub App Client ID and generate a Client secret.
  5. Add them to Apps Script Script Properties as AI_API_CONNECTOR_GITHUB_CLIENT_ID and AI_API_CONNECTOR_GITHUB_CLIENT_SECRET.
Use a fine-grained token instead

Personal access tokens are an advanced fallback when your GitHub App installation cannot reach the repositories you need.

  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 and repositories you want to query.
  4. For reading issues, pull requests, commits, branches, and repository metadata, use read-only repository permissions. GitHub requires Metadata: Read-only.
  5. Copy the token immediately.
  6. In the API Import sidebar, select GitHub, click Use a token instead, paste the token, and click Save Credential.
→ View in docs

Ready to connect GitHub to Google Sheets™?

Install the free add-on and start pulling data in minutes.

Install Free on Google Sheets™