Automate daily export


Is there a way to automatically export a sheet daily? With COVID, I have created a sheet for everyone to check off if they are remote or onsite. Currently, each day the data is written over. I manually export the sheet at the end of the day.