The answer from "tesltrader" is good but I had troubles with the CSV-file since there are many different kinds. Therefore I changed to an excel-file.

Step 1 and 2 as above

Step 3 extract the file id right of the gotten link and add '/export?format=xlsx'

Step 4 as above

The script will then be as follows.

import pandas as pd 
import openpyxl 

file _url = ... 
df_xlsx = pd.read_excel(file_url, engine='openpyxl') 
df_xlsx

Thanks again "teslatrader"!