Hey @IFRC - thanks for using Dropbox and welcome to our Community!
While there's no such automation at the moment, perhaps you'd be interested in the data retention policies feature?
Note that this is available for to Dropbox team accounts that have purchased the Data Governance Add-On.
Otherwise, you might be able to find a third party solution that might help achieve what you had in mind.
I hope this helps!