Is there a way to refresh the database automatically after a week of uploading? Could it be emptied after a week again so another set of data could be uploaded?

Is there a way for specific users to be redirected to the connected GSheets in order for them to input data? My idea here is that the user can click on a button on the app that will redirect them to the data source in GSheets where they can input the...