Format Your Google Spreadsheets & Youtube Reporting

format.js

function onOpen() {// Inserts a custom menu in the spreadsheet, lets you do neat stuff.
 var ss = SpreadsheetApp.getActiveSpreadsheet(),
     options = [
      {name:"Format The Current Sheet", functionName:"formatSheet"}
     ];
 ss.addMenu("Auto Formatter", options);
}

function formatSheet() {//Formats a single spreadsheet
  var sheet = SpreadsheetApp.getActiveSheet();
  var data = sheet.getDataRange().getValues();
  var newData = new Array();
  for(i in data){
       sheet.getRange('A:H').setFontFamily('Arial');
       sheet.getRange('A:H').setFontSize('13');
       sheet.getRange('E:E').setNumberFormat('$0.00');
       sheet.getRange('F:F').setNumberFormat('$0.00');
       sheet.getRange('G:H').setNumberFormat('0');
       sheet.getRange('A1').setValue('Campaign Name');
       sheet.getRange('C1').setValue('Views');
       sheet.getRange('D1').setValue('View Rate');
       sheet.getRange('E1').setValue('CPV');
       sheet.getRange('G1').setValue('Converted Clicks');
       sheet.getRange('H1').setValue('View Through Conversions');
       sheet.autoResizeColumn(1);
       sheet.setColumnWidth(2,200);
       sheet.setColumnWidth(3,200);
       sheet.setColumnWidth(4,200);
       sheet.setColumnWidth(5,200);
       sheet.setColumnWidth(6,200);
       sheet.setColumnWidth(7,200);
       sheet.setColumnWidth(8,220)
    }
     SpreadsheetApp.flush();
   }