function getPageSpeedData (url) {

  var url = url;

  var pageSpeedApi = "https://www.googleapis.com/pagespeedonline/v5/runPagespeed?url=" + url + "&strategy=desktop&key=AIzaSyC62fdejPrYL5CKmoVO3rL_ARWMk505f&prettyPrint=true";

  var source = UrlFetchApp.fetch(pageSpeedApi, {muteHttpExceptions: true}).getContentText();

  var data = JSON.parse(source);

  var metrics = data.loadingExperience.metrics;

  var lighthouse = data.lighthouseResult.audits;

  var categories = data.lighthouseResult.categories;