var SPREADSHEET_URL  = "https://docs.google.com/spreadsheets/d/1nweIw1aPmaFswrXH92B-qSwDVwqPivkEkMapXEC_-dA/edit#gid=0"


function main() {
  var callouts = load_data(SPREADSHEET_URL);
  Logger.log(callouts)
}

function load_data(url){

  var reportSheet = SpreadsheetApp.openByUrl(url);
  var rows = reportSheet.getDataRange();

  var numRows = rows.getNumRows();
  var numCols = rows.getNumColumns();
  var values = rows.getValues(); // values[row_index][column_index]

  var row = values[0];
  var headerNames = new Array();

  for(var i = 0; i < numCols; i++){
    var columns_name = row[i];
    headerNames.push(columns_name);
  }

  var data = new Array();
  for(var row_index = 1; row_index < numRows; row_index++){
    var row_data = {};
    if(!values[row_index]) break;
    for(var col_index = 0; col_index < numCols; col_index++){
      var cell_data = values[row_index][col_index];
      if(!cell_data) continue;
      row_data[headerNames[col_index]] = values[row_index][col_index];
    }
    if(!size_dict(row_data)) continue;
    data.push(row_data);
  }

  for(var i = 0; i < data.length; i++){
    Logger.log(data[i]);
  }

  return headerNames;

}

function size_dict(d){
  c = 0;
  for (i in d) ++c;
  return c
}