Google sheets vba to download file and save it to google drive folder and use it's data

Hi,

I am new to VBA and have some beginning knowledge 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:
https://www.xxxxxxxxxxxxxxxxx.nl/fee...px?language=nl

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.

You cannot use VBA in Google Sheets. Also, there is a separate section for non-Excel related questions.

That's Javascript.