const files = FOLDER.getFiles(); const file = files.next(); const fileId = file.getId(); const blob = DriveApp.getFileById(fileId).getBlob(); const csv = blob.getDataAsString(); const values = Utilities.parseCsv(csv); SHEET.getRange(1, 1, values.length, values[0].length).setValues(values);