Remove Extra Columns in Google Spreadsheet

skip.gs

function removeExtraColumns() {// Formats all spreadsheets
  var ss = SpreadsheetApp.getActive();
  for(var n in ss.getSheets()){// loop over all tabs in the spreadsheet
    var sheet = ss.getSheets()[n];// look at every sheet in spreadsheet
    var name = sheet.getName();//get name
    var maxColumns = sheet.getMaxColumns();
    var lastColumn = sheet.getLastColumn();
    var subtract = maxColumns - lastColumn;
    var lastNew = lastColumn + 1;
    if(name != "*test"&& subtract > 0){
      Logger.log("Name: "+name+", Max Columns: "+maxColumns+", Last Column: "+lastColumn+", Number to Subtract: "+subtract+", The new Last Column: "+lastNew);
      sheet.deleteColumns(lastNew, subtract);
    }
    SpreadsheetApp.flush();
  }
}