Send Email When Drive Sheet is Reaching Cap

googlesheets.js

//*****************************************************//
//                    HOW TO USE                       //
//*****************************************************//
//1) GOTO TOOLS > SCRIPT EDITOR
//2) PASTE THIS SCRIPT INTO THE EDITOR
//3) CHANGE MAXNUM & EMAILS TO SUIT YOUR NEEDS
//4) SAVE THE SCRIPT AND NAME IT
//5) CLICK THE CLOCK ICON TO SETUP TRIGGERS
//6) ADD A TRIGGER TO SUIT YOUR NEEDS
//7) MAKE SURE YOU AUTHORIZE THE FUNCTION
//7) IF AUTHORIZATION DOESNT HAPPEN CLICK 'PLAY'


//****************************************//
// COPY THIS SCRIPT INTO THE EVENT EDITOR //
//****************************************//
function sendEmail() {
  try{
    var sheet = SpreadsheetApp.getActiveSheet();
    Logger.log(sheet);
    var numRows = sheet.getLastRow();
    var message = "Your contest sheet is at " + numRows + " rows.";
    var emailAddress = "dan@trendsettermarketing.net, danielvassallo87@gmail.com";
    var subject = "WARNING: You are about to exceed the entry limit!";
    var maxRows = 60000;
    if (numRows > maxRows){
      MailApp.sendEmail(emailAddress, subject, message);
    }
   }catch(err){
     Logger.log(err.lineNumber + ' - ' + err);
   }
}