Google App Scripts for gittip budgeting (for use in Google Spreadsheet "Tools > Script editor...")

README.md

Usage

• Create new spreadsheet.
• Click Tools > Script editor...
• Copy in code.js.
• Save with an arbitrary name, and then click the "Run" arrow.
• Go back to spreadsheet.
• Use custom functions like this in a cell: =getGittipReceivingIndividual("patcon")

code.js

function getGittipReceivingIndividual(username) {
  if (typeof username != "string") {
    throw "input must be a string";
  }

  var url = 'https://www.gittip.com/' + username + '/public.json';
  var response = UrlFetchApp.fetch(url);
  var json = response.getContentText();
  var data = JSON.parse(json);
  
  return parseFloat(data.receiving);
}

function getGittipReceivingTeam(team, username) {
  var url = 'https://www.gittip.com/' + team + '/members/index.json';
  var response = UrlFetchApp.fetch(url);
  var json = response.getContentText();
  var data = JSON.parse(json);
  
  var user_data = data.filter(function(u){
    return u.username === username
  });
  
  return parseFloat(user_data[0].take);
}