I am new to VBA and have some beginning knowledge of scripting but not good for now for what I want to do.
So I was hoping to find someone who can help.

so this the issue atm.

I wont to download a CSV file from a specific address:

I have for now hidden our site as we can not give out the CSV file to the public atm. anyway if you click it, you will get a CSV file with tables and data in it.
What I am trying to make atm is that google sheets will download this file every night to a specific google drive location. later I will try to get other scripts to get the data of that file and paste its data inside google sheets.

I want to do this so we do not have to manually update our stock from our warehouse.

Thank you all in advance.