Github API in Google Sheets

Knowledge Base

Importing Github API data to a spreadsheet doesn't have to be painful! In this guide, we'll walk you through the basics of importing Github API data to Google Sheets.

Before you begin

  1. Install API Importer for Google Sheets

The following guide is based on the Github Docs

Get an access token

Navigate to https://github.com/settings/tokens and click on "Generate new token"

Get an access token/

Give your token a memorable name

Give your token a memorable name/

Select your scopes

Pro-tip: It is always recommended to follow the Principle of least privilege

Select your scopes/

Click "Generate token"

Click "Generate token"/

Copy your access token

Copy your access token/

In Google Sheets, go to Add-ons -> API Importer -> My Requests

github



You can run this command with =api("github")