如何编写google脚本自动调用包含CSV文件的google文件夹驱动器中的数据到一个Google Sheets中

function importCSVFromDrive() {
  var folderId = "文件夹ID"; // 替换为包含CSV文件的Google文件夹驱动器的ID
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  
  var folder = DriveApp.getFolderById(folderId);
  var files = folder.getFilesByType(MimeType.CSV);
  
  while (files.hasNext()) {
    var file = files.next();
    var csvData = file.getBlob().getDataAsString();
    var csvArray = Utilities.parseCsv(csvData);
    
    for (var i = 0; i < csvArray.length; i++) {
      sheet.appendRow(csvArray[i]);
    }
  }
}