Google codelabs tool App script

google_codelabs_appscript.gs

function doGet(request) {
  var sheet = SpreadsheetApp.openById("1bzuFEiI9Sh3fT_nY84b2JdTqzhpVHkU00VKsVhKOr4U");
  var values = sheet.getActiveSheet().getDataRange().getValues();
  var data = [];
  for (var i = 1; i < values.length; i++) {
    var row = values[i];
    var datas = {};
    datas['Timestamp'] = row[0];
    datas['Your email'] = row[1];
    datas['Joined codelab'] = row[2];
    datas['How to get a certificate'] = row[3];
    datas['Link public profile'] = row[4];
    data.push(datas);
  }
  return ContentService.createTextOutput(JSON.stringify(data)).setMimeType(ContentService.MimeType.JSON);
}