I got the below script which seems to work from time to time. It runs with no bugs reported, but it doesn't populate the sheet it is supposed to:
function importCSVFromWeb(url) {
// Provide the full URL of the CSV file.
var csvUrl = "Https...";
var csvContent = UrlFetchApp.fetch(csvUrl).getContentText();
var csvData = Utilities.parseCsv(csvContent);
var sheet = SpreadsheetApp.getActiveSpreadSheet().getSheetByName('Entradas');
if(sheet.getName()=='Entradas'){
sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);
}
}