You can schedule the link to the CSV export to be sent out via email.
You can find this functionality in the Scheduled Email Delivery section of the CSV Exporter automation's settings. Simply configure the Email Recipients (comma-separated) and click on Configure Schedule to choose from one of the scheduling options:
Run once per 15 minutes
Run once per hour
Run once per day
Run once per week
Here, you can also turn on the Email on Failure feature to be notified when the emails fail to send.