Get open github pull requests in Google Sheets - Google Script

github.gs

//generic function to get JSON from a github API endpoint
function getJSON(url) {
  // Your github username
  username = "<USERNAME>"   
  // Your access token (see https://github.com/settings/tokens)
  password = "<ACCESS_TOKEN>" 

  //basic auth using access token
  var options = {};
  options.headers = {"Authorization": "Basic " + Utilities.base64Encode(username + ":" + password)};
  
  //get the url provided
  var response = UrlFetchApp.fetch(url, options);
  
  //return the parsed jason
  return(JSON.parse(response.getContentText()));
}


//call this function from a cell in your google sheet (or slide deck, or wherever)
function getOpenPRCount(){    
  //return the number of nodes in the json object (that's our PR count)
  return(getJSON("https://api.github.com/repos/bbc/proteus/pulls").length);
}

// You could make other functions that grab more useful data from the github API, too! :)