似乎是这个网站( https://ctrlq.org/code/20279-import-csv-into-google-spreadsheet )确实提供了几种将CSV导入Google电子表格的方法.

It seems like this site (https://ctrlq.org/code/20279-import-csv-into-google-spreadsheet) does include several ways to import a CSV into a google spreadsheet.

例如，要从Google云端硬盘导入，您可以执行以下操作:

For instance for importing from google drive you can do:

function importCSVFromGoogleDrive() {

  var file = DriveApp.getFilesByName("data.csv").next();
  var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
  var sheet = SpreadsheetApp.getActiveSheet();
  sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData);

}

此后，您将需要过滤所需的数据，但是我想一旦从csv导入数据，这样做会更容易.

After that you will need to filter the data you want, but i guess it is easier to do that once you have imported the data from the csv.