Google Apps script function to delete rows based on value in cell.

find-cell-value-and-delete-row.js

function deleteRows() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var rows = sheet.getDataRange();
  var numRows = rows.getNumRows();
  var values = rows.getValues();

  var rowsDeleted = 0;
  for (var i = 0; i <= numRows - 1; i++) {
    var row = values[i];
    if (row[0] == 'delete' || row[0] == '') { // This searches all cells in columns A (change to row[1] for columns B and so on) and deletes row if cell is empty or has value 'delete'.
      sheet.deleteRow((parseInt(i)+1) - rowsDeleted);
      rowsDeleted++;
    }
  }
};

This is exactly what I was looking for. Had to finagle it for my own purposes, but I got it to work. I deleted a selection of columns within the target row based on whether the value of a certain cell was less than or equal to a certain number.

const deleteRows = async () => {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  const rows = sheet.getDataRange();
  const numRows = rows.getNumRows();
  const values = rows.getValues();

  let rowsCleared = 0; // This should be declared with 'let' to avoid a global variable

  for (let i = 1; i < numRows; i++) {
    // Start from index 1 to skip the header row
    let row = values[i];

    // Check if the value in column E (index 4) is <= 5
    if (row[4] <= 5) {
      // Wrap delete cells in a promise to make it async
      await new Promise((resolve) => {
        // Delete cells from columns A-J in the specific row
        sheet
          .getRange(i + 1, 1, 1, 10)
          .deleteCells(SpreadsheetApp.Dimension.ROWS); // i + 1 to convert index to row number
        resolve();
      });
    }
  }
};