Google script example with GET request to 3rd party URL and enter it on Google Sheets

Google Script Example.gs

var url = 'YOUR URL HERE';

function mainFunction() {
  getAllUseruid();
}


function getAllUseruid(){
  var sheet = SpreadsheetApp.getActiveSheet();
  var startRow = 2; 
  var numRows = sheet.getLastRow() - 1; 
  //var numRows = 20; 
  var dataRange = sheet.getRange(startRow, 3, numRows, 2) 
  var data = dataRange.getValues();
  //Logger.log(url+"Basil")
  for(i in data) {
     var row = data[i];
    Logger.log(url+row)
    try {
      response_data = getUid(row);
      //Logger.log(response_date);
      status = response_data.userUid;
    } catch(err) {
      Logger.log(err);
      status = "error";
    }
    sheet.getRange(startRow + Number(i), 4).setValue(status);
  }
}

function getUid(email) {
  //Logger.log(url+email)
  var emails = email.toString().replace(',', '');
  var dataUrl = url+emails
  var response = UrlFetchApp.fetch(dataUrl);
  //Logger.log(response.getContentText());
  if (response.getResponseCode() == 200) {
    
    var params = JSON.parse(response.getContentText());
    
    Logger.log(params.userUid);
     return params;
  } else {
    
   Logger.log("Error from getUid()")
   return "error"
  }
}