arjun-rao/apps-script-github

Codelab for Apps Script

apps-script-github

Codelab for Apps Script

Step 1

Get clasp!

npm i @google/clasp -g 

Step 2

Create a script and add a Code.js file.

clasp create
touch Code.js

Step 3

Paste in the following

var base_url = "https://api.github.com/repos/";
var commit_url = "/commits";

var sheetID = "INSERT HERE";
var sheet =   SpreadsheetApp.openById(sheetID).getSheetByName("Sheet1");
var db = PropertiesService.getScriptProperties();


function getCommits(repo) {
  var api_url = base_url + repo + commit_url; 
  var results = fetch(api_url);
  for each( var result in results) {	
     //TODO
  }
}


var USERNAME = db.getProperty("user");
var PASSWORD = db.getProperty("pass");
var headers = {
  "Authorization" : "Basic " + Utilities.base64Encode(USERNAME + ':' + PASSWORD)
};


var params = {
  "method":"GET",
  "headers":headers,
};


function fetch(url) {
  var response = UrlFetchApp.fetch(url, params);
  var parsed_response = JSON.parse(response);
  return parsed_response;
}

Step 4

Complete the TODOs