Function de Google Spreadsheet que permite listar URLs por SKU.

productUrl

function testProductUrl() {
  var host = "www.domino.com.br";
  var username = "USER_API";
  var password = "SENHA_API"

  //productUrl('34241', host, username, password);
  productUrl('17345', host, username, password);
}

function productUrl(sku, host, username, password) {
  var url = "https://" + host + "/api/v2/variants/" + String(sku);

  var response = UrlFetchApp.fetch(url, { headers: { "Authorization": "Basic " + Utilities.base64Encode(username + ":" + password) }, muteHttpExceptions: true });
  var variant = JSON.parse(response);
  if(variant.error) {
    return variant.error;
  }
  else {
    return "https://" + host + "/produto/" + variant.slug + "-" + String(variant.product_id);
  }
}