Код макроса

function Add5() {

  var spreadsheet = SpreadsheetApp.getActive();

  spreadsheet.getRange('A2:F2').activate();

  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Все операции'), true);

  spreadsheet.getRange('2:2').activate();

  spreadsheet.getActiveSheet().insertRowsBefore(spreadsheet.getActiveRange().getRow(), 1);

  spreadsheet.getActiveRange().offset(0, 0, 1, spreadsheet.getActiveRange().getNumColumns()).activate();

  spreadsheet.getRange('A2').activate();

  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Ввод данных'), true);

  spreadsheet.getRange('D2').activate();

  spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});

};