Reply To: Creation of new sheets when size limit is reached

Home Forums Feature request Creation of new sheets when size limit is reached Reply To: Creation of new sheets when size limit is reached

#1073

mhawksey
Keymaster

For a workaround in your each Google Sheet you want to monitor open Tools > Script Editor… and add the following code at the top changing the email address:

function checkSize(){
  var doc = SpreadsheetApp.getActiveSpreadsheet()
  var rows = doc.getSheetByName("Archive").getLastRow();
  if (rows > 30000){
    MailApp.sendEmail("[email protected]", doc.getName()+" -size warning", "Check "+ doc.getUrl());
  }
}

then in the script editor select Edit > Current project triggers and add a new trigger for checkSize to run daily. You should now get a warning when the sheet reaches 30,000 rows. To stop the warnings from the script editor navigate back to current project triggers and remove the trigger