loop-through-gsheets

var ss = SpreadsheetApp.getActiveSpreadsheet()

function getSheets() {
  var column_headers = []
  var sheets = ss.getSheets();
  for (i = 0; i < sheets.length; i++){
    var sheet = sheets[i]
    var name = sheet.getName()
    if (name != 'setup'&& name != 'guide'){
      var firstRow = 1;
      var firstColumn = 2;
      var lastColumn = sheet.getLastColumn();
      var numRows = 2;
      var numColumns = lastColumn-1;
      
      var column_header = sheet.getRange(firstRow,firstColumn,numRows,numColumns).getValues() 

      var clean = column_header[0]        
      var original = column_header[1]
   
      for (j = 0; j < clean.length; j++){
        var row = [name,clean[j],original[j]]
        column_headers.push(row)
      }          
    }
  }
  return column_headers
}

var setup_sheet = ss.getSheetByName('setup')
var startCol = 5;
var startRow = 2;

function deleteRange(){
    var sheet = setup_sheet.getRange(startRow,startCol,1000,3).setValue('')

}

function writeSheet(){
  deleteRange()
  var data = getSheets()
  Logger.log(data)

  var numCols = data[0].length;
  var numRows = data.length
  var sheet = setup_sheet.getRange(startRow,startCol,numRows,numCols).setValues(data)

}