GAPPS base64 Encoder

appscript

function encodeEmail() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  
  var range = sheet.getDataRange();
  var lastRow = range.getLastRow();
  var values = range.getValues();
  var col = values[0].indexOf('Email');
  
  var colValues = sheet.getRange(2, col + 1, lastRow - 1).getValues();
  
  sheet.insertColumnAfter(col + 1);
  sheet.getRange(1, col + 2).setValue('Encrypted Email');
  
  for (var row in colValues) {    
    if(colValues[row] !== '') {
      Logger.log('row: ' + (parseInt(row) + 1) + ' and col: ' + (parseInt(col) + 2) + ' ' + colValues[row]);
    
      var blob = Utilities.newBlob(colValues[row].toString());
      var encoded = Utilities.base64Encode(blob.getBytes());
      sheet.getRange((parseInt(row) + 2), (parseInt(col) + 2)).setValue(encoded);
    }
  }
}

function encodeLocale() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  
  var range = sheet.getDataRange();
  var lastRow = range.getLastRow();
  var values = range.getValues();
  var col = values[0].indexOf('Locale');
  
  var colValues = sheet.getRange(2, col + 1, lastRow - 1).getValues();
  
  sheet.insertColumnAfter(col + 1);
  sheet.getRange(1, col + 2).setValue('Encrypted Locale');
  
  for (var row in colValues) {    
    if(colValues[row] !== '') {
      Logger.log('row: ' + (parseInt(row) + 1) + ' and col: ' + (parseInt(col) + 2) + ' ' + colValues[row]);
    
      var blob = Utilities.newBlob(colValues[row].toString());
      var encoded = Utilities.base64Encode(blob.getBytes());
      sheet.getRange((parseInt(row) + 2), (parseInt(col) + 2)).setValue(encoded);
    }
  }
}

function ENCODE(input) {
  var blob = Utilities.newBlob(input);
  var encoded = Utilities.base64Encode(blob.getBytes());
  return encoded;
}