Faster way to copy rows of data to different sheets by column value
Your for () loop is unnecessarily calling SpreadsheetApp.getActiveSpreadsheet() in every single iteration. You can define a varible outside of the loop for chaining:
const spreadsheet = SpreadsheetApp.getActiveSpreadsheet()
for (let i = 1; i &lt; columnRoom.length; i++) {
  // something...
  spreadsheet.insertSheet(&quot;No Room&quot;)
}