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
October 31, 2017 at 4:30 pm
#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