function onOpen(e) {
  let ui = SpreadsheetApp.getUi();
  ui.createMenu('🤖 Automation Tools')
    .addItem('Move "Yes" to another sheet', 'moveRows')
    .addToUi();
};

function moveRows() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getActiveSheet();
  const targetSheet = SpreadsheetApp.openById('1s6B6OURQ7FFmP106mrE9laqZ3XLwiXtjway6iGyWsOk').getSheetByName('Sheet1');
  const targetLastRow = targetSheet.getLastRow();  // this grabs last row in any column
  let lastRow = sheet.getLastRow();
  let sortRange = sheet.getSheetValues(2,1,lastRow, 4);




  Logger.log(lastRow)
  // Logger.log(typeof(sortRange))
  // Logger.log(sortRange.length);


  let targetCounter = 1;

  for (var i = 1; i <= sortRange.length; i++) {
    let finalized = sheet.getRange(i,1).getValue();
    console.log(i + " - " + finalized);

    // Check if the data already exists in the target sheet
    let duplicateCheck = targetSheet.getRange(1, 1, targetLastRow, 4).getValues();
    let isDuplicate = false;

    for (var j = 0; j < duplicateCheck.length; j++) {
    if (JSON.stringify(duplicateCheck[j]) === JSON.stringify(sortRange[i - 1])) {
      isDuplicate = true;
      break;
      }
    }

      if (!isDuplicate && finalized == "Yes") {
        let rowValues = sheet.getRange(i, 1, 1, 4).getValues();
        targetSheet.getRange(targetLastRow+targetCounter, 1, 1, 4).setValues(rowValues);
        targetCounter++;
      }
  };
};