Pyrgos - addOOTW

function addOOTW() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var suggestionsSheet = spreadsheet.getSheetByName("Officer of the Week");
  var meetingSheet = spreadsheet.getSheetByName("Meeting Notes");
  var OOTW = suggestionsSheet.getRange('E5').getValue();
  var date = suggestionsSheet.getRange('E6').getValue();
  var lastRow = suggestionsSheet.getLastRow();
  var clearrange = suggestionsSheet.getRange("D" + lastRow + ":E" + lastRow);
  clearrange.setBorder(null, true, false, true, null, null);
  suggestionsSheet.insertRowAfter(lastRow);
  var targetRow1 = lastRow + 1;
  suggestionsSheet.getRange(targetRow1, 5).setValue(OOTW);
  suggestionsSheet.getRange(targetRow1, 4).setValue(date);
  var clearrange = suggestionsSheet.getRange("D" + targetRow1 + ":E" + targetRow1);
  clearrange.setBorder(true, null, null, null, true, true, null, SpreadsheetApp.BorderStyle.DASHED);
  clearrange.setBorder(null, true, true, true, null, null);
  var clearrange = suggestionsSheet.getRange('E5');
  clearrange.clearContent();
}