Using google drive as source for csv

[CptOrange16]

Hello
Has anyone tried to use google drive to host the csv files?

I tried using the url given when enabling public link sharing but what I get is a table with a bad request:

My datasource page:

I used a link that takes you to a direct download:
https://drive.google.com/uc?id=<MY_FILE_ID>

The link works well when using the browser

Maybe there is a different type of link that works or a configuration that I need to add.

How to reproduce:
1 - Upload small basic .csv file to your google drive.
2 - Share that file with a public link that allows anyone to view
3 - Use as datasource for a table (for example)
4 - Table with bad request as shown in the first image