google script

gistfile1.js

function createOrClearSheet2() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheets = ss.getSheets();
  if (sheets.length == 1) {
    ss.insertSheet('output');
  }
  var output_sheet = ss.getSheetByName('output');
  output_sheet.clear();
  
  copyContentToOutput(sheets[0], output_sheet);
  
}

function copyContentToOutput(src, dest) {
  var column_cnt = src.getLastColumn();
  var row_cnt = src.getLastRow();

  var src_range = src.getRange(1,1,row_cnt,column_cnt);
  var target_range = dest.getRange(1,2);
  src_range.copyTo(target_range);
  
  dest.getRange("A1").setValue('setHeader(\'');
  dest.getRange(2,1,row_cnt-1,1).setValue('addData(\'');
 
  dest.getRange(1, column_cnt + 2, row_cnt, 1).setValue(')');
}