Uploading a csv to Google sheets automatically

Hello all,

I have seen the file upload tutorial (https://youtu.be/sCq3CQBhRWk) and tried recording the macro on google sheets.
The steps are File, Import, Upload, Select file from device and open it (I would also have to fix the delimiters of the csv but didn´t get to that point).
After recording the macro, I change my path (using Chrome on Mac) and tried running it.
It failed and not able to fix it after a lot of tries and changes.

If anyone knows how to fix this it would be of great help!

What error do you get?

A screencast of the issue would be helpful.