Alta satir eklenince makronun calismasi

[esad45]

Merhaba altaki gibi Google Sheets de yaptigim bor makro var sadece her yeni ssatir eklendiginde belirtilen satirlarin alta kopyallanmasini nasil yapabilirim
k l m n o satirlarindaki hucreler her yeni satir eklenince alta da kopyalanmasini nasil saglayabilirim simdidien tesekkurler

function yeni() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('K4').activate();
spreadsheet.getRange('K3').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);
spreadsheet.getRange('L4').activate();
spreadsheet.getRange('L3').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);
spreadsheet.getRange('M4').activate();
spreadsheet.getRange('M3').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);
spreadsheet.getRange('N4').activate();
spreadsheet.getRange('N3').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);
spreadsheet.getRange('O4').activate();
spreadsheet.getRange('O3').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);
};