Is it possible to split a Google spreadsheet into pages by lines (each line is a separate page)?

Question

Google Sheets

Good afternoon! Please tell me if anyone knows a function / addition or a script that allows you to split one file in a Google spreadsheet into separate tables, or send the contents of a line to the mail.
I tried the option with IMPORTRANGE, but two minuses, you need to create about 60 pages manually each time and the final amount is shown in the cells, but you need to show the contents of how this amount turned out.
Does anyone have any thoughts on this?

Answer 1

To send a string to the mail, you can use the function GmailApp.sendEmail(recipient, subject, body)
recipient - recipient
subject - subject
body - message
To create a large number of pages, you can use SpreadsheetApp.getActiveSpreadsheet().insertSheet(). This function returns the newly created sheet, so you can work with it further, for example, change the contents of the cells.

function test(){
  for (var i=1;i<=5;i++){
    SpreadsheetApp.getActiveSpreadsheet().insertSheet("Лист №"+i).getRange("A1").setValue("Это новый лист № "+i);
  };
};