Better Garbage

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Scripts')
    .addItem('Update Roster', 'updateRoster')
    .addToUi()
}

function updateRoster() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var report = ss.getSheetByName("Paste Report");
  var roster = ss.getSheetByName("Roster");

  var rosterDataRange = roster.getDataRange();
  var rosterLastRow = rosterDataRange.getLastRow()
  var rosterEmailValues = roster.getRange(1, 2, rosterLastRow, 1).getValues();
  var reportDataRange = report.getDataRange();

  reportDataRange.getValues().forEach(function (row) {
    if (!(rosterEmailValues.flat().includes(row[1]))) {
      var rosterDataRange = roster.getDataRange();
      var rosterLastRow = rosterDataRange.getLastRow() + 1;
      var newRosterRow = [[row[0], row[1], row[3]]];
      roster.getRange(rosterLastRow, 1, 1, 3).setValues(newRosterRow);
    }
  })
}