this google app script is to build the redirection pie Uri

redirection pie google app

function httpredirectpie(url) {
  var options = {
    headers:{
    "Accept":"application/json",
    "X-Api-version":"2.0"
    },
    muteHttpExceptions: true,
    followRedirects: false
  };
  var responose = UrlFetchApp.fetch(url, options);
  var stored = responose.getHeaders();
  
  Logger.log(stored.toSource());
  
  return stored['Location'];
}