Skip to content

Import GitHub data to a google sheet using OAuth app

Rashani Tharushika Wijerathna edited this page Jul 29, 2021 · 1 revision

First install API connector.

99

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.

123

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

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

1234

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.

8

* 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.

679