changeAWTColumns.js

// Step 1: Place this in your <script> area of your template
// Step 2: Change 'columns' variable to reflect on line 19 to your desires
//         e.g. columns = {'b': 'Column B!', 'c': 'Column C!'}
//
// NOTE: Does NOT refer to the columns in the data source sheet
//       Column A here is the first column that appears on the awesometable, 
//       B the second

var convertColToN = function(val) {
  var base = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', i, j, result = 0;
  val = val.toUpperCase();
  for (i = 0, j = val.length - 1; i < val.length; i += 1, j -= 1) {
    result += Math.pow(base.length, j) * (base.indexOf(val[i]) + 1);
  }
  return result;
};

function main() {
    columns = {
       'a': 'Change',
    };
    $.each(columns, function (col, colName) {
           var n = convertColToN(col);
           $('.google-visualization-table-th:nth-child(' + n.toString() + ')').text(colName);
    });
}

(function() {
    
    [
      'https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js',
    ].forEach(function(src, index, arr) {
      var tag = undefined;
      if (src.endsWith('.js')) {
        tag = document.createElement('script');
        tag.src = src;
        tag.async = false;
      } else if (src.endsWith('.css')) {
        tag = document.createElement('link');
        tag.rel = "stylesheet";
        tag.href = src;
      }
      if (index === (arr.length-1)) {
          tag.onload = function () {
              $(function () {
                  main();
              });
          };
      }

      document.head.appendChild(tag);

    });

})();