I found some documentation on how to do this:
https://help.zoho.com/portal/en/community/topic/automatic-csv-export-from-zoho-survey-response
The aim is to use the Schedule report: it sends a mail with a summary in XLS, CSV or PDF format.
- Click Actions and select Schedule Report.
- Enter a name for your report in the Name box.
- Select the frequency to email reports: Daily, Weekly, or Monthly.
- Click the Select a report dropdown menu and choose the type of report you want to schedule.
- Click All data to receive all responses.
- Click Data acquired within frequency interval to receive responses for a specific time period.
- Click Select a filter to set a filter for reports.
- Click the drop-down arrow next to Language, to choose the language of the report, if you have multiple languages in your survey.
- In the Recipient's email addresses box, enter the email addresses of the recipients, separated by commas.
Click Save.