I have designed and developed google sheet system in the work place, being used by some 50 people on daily basis.
If you want to delete rows more than 24 hours old, it can be done easily. You can do it once a day at a fixed time. You need a date/time column. The script will run daily (automatically) and delete old rows. Optionally, you can copy the deleted rows in another sheet for backup.
I have the same logic running in one of my sheets, working perfectly for the last two years.