Import GitHub data to a google sheet using OAuth app - veracity-dev/github-xlsx GitHub Wiki

First install API connector.

Connect to the GitHub API

1)Open up Google Sheet and click Add-ons>API connector>Manage Connections.

2)Find GitHub and click 'connect' in the list of available connections.

3)Then you have to approve the connection by clicking Authorize

4)Then you'll be returned to your Google Sheet, and you can verify that your GitHub connection is active.

Create your API Request URL; (API root+ Endpoint+ Parameter)

https://api.github.com/search/repositories?q=google tag manager

Pull GitHub API data into sheets

* Open up Google sheets and click Add-ons>API connector>Open & Enter URL into API Connector as below.

* Select GitHub for OAuth2 Authentication and click Set current to use current tab as destination.

* Name your request and Run, then GitHub data populate your Google sheet.