A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
Hello,
Good day!!
Per your description, I understand you need an automatic way to download the .csv file from SharePoint List from the Bot Account to a local drive or network drive.
As far as I know, I'm afraid there is no built-in feature in SharePoint to meet this requirement. Sorry for the inconvenience.
To check if any PowerShell method or any customized solution could meet your requirement, I sincerely recommend you post your concern to Microsoft Q&A Community with SharePoint tag https://learn.microsoft.com/en-us/answers/tags/235/office-sp
Members and engineers over there are proficient in the knowledge of PowerShell scripts and SharePoint customization queries. They will focus on the specific situation on your side and provide specific suggestions for you.
Thanks for your understanding and cooperation!
Sincerely,
Tina | Microsoft Community Moderator