I have a situation where a script is taking input data and sending it to a spreadsheet. After a while, this spreadsheet becomes too big.

Right now we have to manually move the items from the the primary spreadsheet to a new one. The reason is that not everyone is familiar with the code and are willing to change the ID in the code.

I would like to know if there is a way to open the spreadsheet by name. If not, is there a better way of achieving what we need (described above)

Edit
Report