Get filtered data (method 2)

PHOTO EMBED

Wed Mar 09 2022 13:32:29 GMT+0000 (Coordinated Universal Time)

Saved by @massa

  var filter = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("sheetName").getFilter();

    var criteriaValues = filter.getColumnFilterCriteria(columnPosition).getCriteriaValues();
    Logger.log("criteria Values length " + criteriaValues.length);
    Logger.log(criteriaValues);

    var visibleValues = filter.getColumnFilterCriteria(columnPosition).getVisibleValues();
    Logger.log("visible Values length " + visibleValues.length);
    Logger.log(visibleValues);

    var hiddenValues = filter.getColumnFilterCriteria(columnPosition).getHiddenValues();
    Logger.log("hidden Values length " + hiddenValues.length);
    Logger.log(hiddenValues);
content_copyCOPY

https://localcoder.org/how-to-copy-filtered-spreadsheet-data-with-apps-script