Poll function: Trim lines

by jessekinsman

JavaScript

function trimLog(sheet) {
  maxHeight = 400;
  var range = sheet.getDataRange();
  Logger.log("sheet height " + range.getHeight());
  if (range.getHeight() > maxHeight) {
    var deleteRange = sheet.getRange(range.getHeight(), 1, 1, 3);
    deleteRange.clear();
  }
}