Score leads directly in Google Sheets

madkudu_google_sheet_fit_score.gs

function mk_score_person(email, api_key, use_beta) {
  url = 'https://api.madkudu.com/v1/persons?email=' + email;
  var params = {
    "method":"GET",
    "contentType": "application/json",
    "headers": {"Authorization" : "Basic " + Utilities.base64Encode(api_key + ':')}
  };
  var response = UrlFetchApp.fetch(url, params);    
  var json_data = JSON.parse(response.getContentText());
  return format_api_response(json_data); 
}

function format_api_response(json_data) {
  return [[
    json_data.properties.customer_fit.segment,
    json_data.properties.customer_fit.score
  ]];
}