Googlesheet Script that returns Mobile Speed & Optimization and Desktop Speed & Optimization values in six adjacent columns

mobile-friendly.gs

/**
 * Returns Mobile Pagespeed, Mobile Usability, and Desktop Pagespeed values in three adjacent columns
 * Details about how to use this script on a Google Sheets spreadsheet can be found at:
 * https://cagrisarigoz.com/2015/07/10/create-your-own-google-pagespeed-and-mobile-usability-tracking-googlesheet-in-5-steps/
 */

function checkAll(Url) {
  
  //CHANGE YOUR API KEY WITH YOUR_API_KEY BELOW
  var key = "YOUR_API_KEY";
  var serviceUrlMobile = "https://www.googleapis.com/pagespeedonline/v2/runPagespeed?url="+Url+"&strategy=mobile&key="+key;
  var serviceUrlDesktop = "https://www.googleapis.com/pagespeedonline/v2/runPagespeed?url="+Url+"&strategy=desktop&key="+key;
  var array = [];
  
  if (key == "YOUR_API_KEY")
    return "Please enter your API key to the script";  
  
  var responseMobile = UrlFetchApp.fetch(serviceUrlMobile);

  if(responseMobile.getResponseCode() == 200) {
    var contentMobile = JSON.parse(responseMobile.getContentText());
    
    if ( (contentMobile != null) && (contentMobile["ruleGroups"] != null) )
    {
      if (contentMobile["responseCode"] == 200)
              {
        var speedScoreMobile = contentMobile["ruleGroups"]["SPEED"]["score"];
        var usabilityScoreMobile = contentMobile["ruleGroups"]["USABILITY"]["score"];
      }
      else
      {
          array.push(["Not Found!", "Not Found!", "Not Found!"]);
          return array;
      }
    }
  }
  
  var responseDesktop = UrlFetchApp.fetch(serviceUrlDesktop);
  
  if(responseDesktop.getResponseCode() == 200) {
    var contentDesktop = JSON.parse(responseDesktop.getContentText());
    
    if ( (contentDesktop != null) && (contentDesktop["ruleGroups"] != null) )
      var speedScoreDesktop = contentDesktop["ruleGroups"]["SPEED"]["score"];  
  }
  array.push([speedScoreMobile, usabilityScoreMobile, speedScoreDesktop]);
  return array;
  
}

Do you have any plans to update this to use the v5 API (released in June 2018)? See https://developers.google.com/speed/docs/insights/v5/reference/

Do you have any plans to update this to use the v5 API (released in June 2018)? See https://developers.google.com/speed/docs/insights/v5/reference/

Hello there,
It seems that the v4 will be deprecated about April-May 2019 (details here). I will try to update the script before that.
Thanks for the heads up.

Great!

Hi @csarigoz,
Are you planning to update the script with the v5 of the API by any chance? That would be super helpful!
Thanks in advance.