https://sheetswithmaxmakhrov.wordpress.com/2018/08/21/google-sheets-script-delete-rows-with-condition

Delete-Rows-Condition.gs

// SETTINGS
var C_VALS = ['ABC' , 'DEF' , 'GHI' , 'JKL' , 'MNO' , 'PQR' , 'STU' , 'VWX' , 'YZA'];
var C_SHEETS = ['Sheet1'];
var C_COLUMN = 'H';


function test_deleteSheetRowsWithSettings()
{
  var values = C_VALS;
  var sheets = C_SHEETS;
  
  deleteSheetRowsWithSettings_(false, sheets, C_COLUMN, values);
  
}


function deleteSheetRowsWithSettings_(file, sheetNames, strCol, values) {
  file = file || SpreadsheetApp.getActive();  
  var sheets = file.getSheets();
  
  // get column number
  var column = sheets[0].getRange(strCol + 1).getColumn();
  
  // loop sheets
  var sheet;
  for (var i = 0, l = sheets.length; i < l; i++)
  {
    sheet = sheets[i]; 
    if ( sheetNames.indexOf(sheet.getName()) > -1)
    { deleteSheetRows_(sheet, column, values) }    
  }
}


function deleteSheetRows_(sheet, column, values)
{
  var range = sheet.getDataRange();
  var data = range.getValues();
  
  // loop values
  var l = data.length - 1;
  for(var i = l; i >= 0; i--)
  {
    if (values.indexOf( data[i][column - 1] ) > -1) { sheet.deleteRow(i + 1); }        
  }
  
}