TYPESCRIPT

google sheets script save A RANGE to csv

function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var searchMenuEntries = [ {name: "Search in all files", functionName: "search"}];
  var csvMenuEntries = [{name: "Save as CSV file", functionName: "saveAsCSV"},
                      {name: "Load from CSV file", functionName: "importFromCSV"}];
  ss.addMenu("Search Google Drive", searchMenuEntries);
  ss.addMenu("CSV", csvMenuEntries);
}