google app script example

script.js

function columnStart() {
  return 3;
}

function replaceHyperlink(str){
  var splitStr = str.split('\"');;
  return {
    url: splitStr[1],
    name: splitStr[3],
  };
}

function sheetArrayTemplate(count) {
  var ary = [];
  for (var index = columnStart(); index <= count; index++) {
    ary.push(index);
  }
  return ary;
}

function getData(sheetName) {
  const sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
  const range = sheet.getDataRange();
  return sheetArrayTemplate(range.getLastRow()).map(function(index){
    const cell = sheet.getRange('A' + index);
    
    return {
      name: cell.getValue(),
      link: replaceHyperlink(cell.getFormula())
    };
  });
}

function doGet(e) {
  // https://xxxxxx/exec?year=2019
  // var year = e.parameter.year | '';
  var data = getData('Contributers');
  return ContentService.createTextOutput(JSON.stringify(data))
  .setMimeType(ContentService.MimeType.JSON);
}

dashboard url:
https://script.google.com/home