Sheets API – How to delete all rows hidden by user
Every end of the month I duplicate a tab with multiple hidden rows, then delete all those hidden rows from the duplicate tab. For that purpose I modified the following code of Tanaike, the code running without any error, but all hidden rows still there.