function myFunction(){ var spreadsheetId = 'some Id' var csvFileId = 'some Id' var sheet = SpreadsheetApp.openById(spreadsheetId).getSheetByName('Sheet1'); sheet.clear(); getCSVData(csvFileId, spreadsheetId); } function getCSVData(csvFileId, spreadsheetId){ var data = DriveApp.getFileById(csvFileId) .getBlob() .getDataAsString(); var sheetId = SpreadsheetApp.openById(spreadsheetId) .getSheets()[0] .getSheetId(); var resource = { requests: [ { pasteData: { data: data, coordinate: { sheetId: sheetId, rowIndex: 0, columnIndex: 0 }, type: 'PASTE_VALUES', delimiter: "," }, } ], includeSpreadsheetInResponse: true, }; Sheets.Spreadsheets.batchUpdate(resource, spreadsheetId); }