user_deletion.gs

function deleteUser() {
  var activeSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = activeSpreadsheet.getSheetByName('Main');
  var resultsheet = activeSpreadsheet.getSheetByName('Result');
  var userInputs = sheet.getRange("A3:B").getValues();
  var webPropertyId = String(userInputs[0][0]);
  var numClients = userInputs[0][1]
  
  for (var i = 0; i<numClients;i++){
    var typeOfId = String(userInputs[2+i][1]);
    var userId = String(userInputs[2+i][0]);
    try {
      var request = {
        "kind": "analytics#userDeletionRequest",
        "id": {
          "type": typeOfId,
          "userId": userId
        },
        "webPropertyId": webPropertyId
      };
    Analytics.UserDeletion.UserDeletionRequest.upsert(request);
    resultsheet.appendRow(["'" + userId, 'yes']); 
  }catch(error) {
    Browser.msgBox(error.message);
  }
}
}