Google Apps Sheet script for resizing a stupid calendar I made: https://docs.google.com/spreadsheets/d/1EqaaZnwspsCpvzI-U_pdzoqem2EeLbdqswN8zNdz6LA/edit?usp=sharing

CalendarAutoResize.gs

function onEdit(e) {
  var sheet = SpreadsheetApp.getActive().getActiveSheet();
  //Get the final potential rows
  var row = 10;
  
  var varA = SpreadsheetApp.getActiveSheet().getRange(row, 4).getValue();
  var varB = SpreadsheetApp.getActiveSheet().getRange(row, 5).getValue();
  var varC = SpreadsheetApp.getActiveSheet().getRange(row, 6).getValue();
  var varD = SpreadsheetApp.getActiveSheet().getRange(row, 7).getValue();
  var varE = SpreadsheetApp.getActiveSheet().getRange(row, 8).getValue();
  
  //resizing rows
  var startRow = 12;
  var endRow = 13;
  var numCols = 8;
  var numRows = endRow - startRow + 1; //Needs to be inclusive [x,y] not [x,y)
  var rowRanges = sheet.getRange(startRow, numCols, numRows)
  if (varA == "" || varB == "" 
      || varC == ""|| varD == ""
      || varE == "") {
    //hide the rows since they have nothing in them
    sheet.hideRow(rowRanges)
  } else {
    sheet.unhideRow(rowRanges)
  }

}