Is it possible to delete every week


I want to delete rows every week in sheets but shouldn’t empty.

Or else I could do the above thing in glide table?

you have to use google scripts with the time-driven triggers, there is no option in glide to do that.