Display Google Sheets Data on a Website

 

https://www.youtube.com/watch?v=lOPOmAhkL7I

https://www.bpwebs.com/how-to-display-google-sheets-data-on-a-website/

https://docs.google.com/spreadsheets/d/1xugnth1OaPXyKakgNwAcCeCDGO5r-G-K4qwhIMmzWJc/edit?gid=0#gid=0

https://script.google.com/u/0/home/projects/1QRBKABxJPoDd96XoPX0sjVtbqq-X0pZTp3wRzvYPXC7KcYgU7cB3Aeai/edit

Code.gs

function doGet() {

  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");

  var data = sheet.getDataRange().getValues();

  var jsonData = {};

 

  // Assume first row is headers

  var headers = data[0];

  jsonData['data'] = [];

  // Start from row 1 to skip headers

  for(var i = 1; i < data.length; i++) {

    var row = {};

    for(var j = 0; j < headers.length; j++) {

      row[headers[j]] = data[i][j];

    }

    jsonData['data'].push(row);

  }

 

  return ContentService.createTextOutput(JSON.stringify(jsonData))

    .setMimeType(ContentService.MimeType.JSON);

}