ExportCSV

// Source: https://gist.github.com/mderazon/9655893
// Modified for Changelog only


function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var csvMenuEntries = [{name: "Export to CSV", functionName: "saveAsCSV"}];
  ss.addMenu("Changelog", csvMenuEntries);
};

function logAnything(){
  var currentDate = Utilities.formatDate(new Date(), "GMT+8", "MM-dd-yy hh:mm aaa");
  Logger.log(currentDate);
}

function saveAsCSV() {
  var changelogSheetName = "Changelog";
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheets = ss.getSheets();

  var folder = DriveApp.getFolderById("0BxJv41IalMRUOHVrak1wSzJab0k");
  var changelogSheet = ss.getSheetByName(changelogSheetName);
  var currentDate = Utilities.formatDate(new Date(), "GMT+8", "MM-dd-yy hh:mm aaa");

  fileName = ss.getName() + "_Changelog_" + currentDate + ".csv";

  var csvFile = convertRangeToCsvFile_(fileName, changelogSheet);

  folder.createFile(fileName, csvFile);

  Browser.msgBox('Uploading file in ' + folder.getName());
}

function convertRangeToCsvFile_(csvFileName, sheet) {
  // get available data range in the spreadsheet
  var activeRange = sheet.getDataRange();
  try {
    var data = activeRange.getValues();
    var csvFile = undefined;

    // loop through the data in the range and build a string with the csv data
    if (data.length > 1) {
      var csv = "";
      for (var row = 0; row < data.length; row++) {
        for (var col = 0; col < data[row].length; col++) {
          if (data[row][col].toString().indexOf(",") != -1) {
            data[row][col] = "\"" + data[row][col] + "\"";
          }
        }

        // join each row's columns
        // add a carriage return to end of each row, except for the last one
        if (row < data.length-1) {
          csv += data[row].join(",") + "\r\n";
        }
        else {
          csv += data[row];
        }
      }
      csvFile = csv;
    }
    return csvFile;
  }
  catch(err) {
    Logger.log(err);
    Browser.msgBox(err);
  }
}