Cannot find method (class)(class)getRange(number,number) nor getRange(number,number,number,number)

Instead of just

  var sheet = SpreadsheetApp.getActiveSpreadsheet();

do this

  var spread = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spread.getSheets()[0];

’nuff said.