Hello, I don’t know if I’m the right person to present you with a solution, you’ll most certainly find it here.
I am also looking for something similar, what came to my mind was to create a script that erases the lines, and you schedule it to fire at 00hs.
This is the code, if you’re wrong, colleagues will correct it.
function dell() {
var spreadsheet = SpreadsheetApp.getActive().getSheetByName(“App: Comments”); //tab name to be deleted
spreadsheet.getRange(‘A:F’).activate(); //delete from column A: F
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
};