instertDataToSheet.gs

function instertDataToSheet(deviceInfo, deviceType){
  sheet.appendRow([
  // GMT+8:00 is for singapore 
  Utilities.formatDate(new Date(), "GMT+8:00", "yyyy-MM-dd'T'HH:mm:ss"),
  deviceType,
  deviceInfo.lighthouseResult.categories.performance.score * 100,
  deviceInfo.lighthouseResult.audits['first-contentful-paint'].numericValue,
  deviceInfo.lighthouseResult.audits['largest-contentful-paint'].numericValue,
  deviceInfo.lighthouseResult.audits['cumulative-layout-shift'].numericValue,
  deviceInfo.lighthouseResult.audits['interactive'].numericValue,
  deviceInfo.lighthouseResult.audits['total-blocking-time'].numericValue,
  deviceInfo.lighthouseResult.audits['speed-index'].numericValue,
 ]);  
}