Виктор Л

function exportSelectedCellsAndHeadersToDocument() {
   const ss = SpreadsheetApp.getActiveSpreadsheet();
   const sheet = ss.getActiveSheet();
   const range = sheet.getActiveRange();
   const data = range.getValues();
   const headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
   const doc = DocumentApp.create('Export');
   const body = doc.getBody();
   Logger.log(headers);
   for (let i = 0; i < data.length; i++) {
      for (let j = 0; j < data[i].length; j++) {
         body.appendParagraph(`${headers[j]} : ${data[i][j]}` + '\t');
      }
   }
}

function sheetnames() { 
  var out = new Array()
  var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
  for (var i=0 ; i<sheets.length ; i++) out.push( [ sheets[i].getName() ] )
  return out  
}


Logger.log(sheetnames())
Logger.log(...sheetnames()[1])

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName(sheetnames()[1]);

sheet.activate();

function functionClearRange() {
  const sheet = SpreadsheetApp.getActive();
  const rangesToClear = ['M:M','G:G'];
  for (var i=0; i<rangesToClear.length; i++) { 
    sheet.getRange(rangesToClear[i]).clearContent();
  }
}

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Моя навигация')
      .addItem('Ячейка A555', 'menuItem1')
      .addSeparator()
      .addSubMenu(ui.createMenu('Важно')
          .addItem('Ячейка H555', 'menuItem2'))
      .addToUi();
}

function menuItem1() {
  SpreadsheetApp.getUi() 
     SpreadsheetApp.getActiveSheet().getRange('A555').activate();
}

function menuItem2() {
  SpreadsheetApp.getUi() 
      SpreadsheetApp.getActiveSheet().getRange('h555').activate();
}

var list = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var counter = 6;
var logics = {
    "F10": "=IFERROR(VLOOKUP(B10;'Эта неделя'!$B$3:$E$120;3;FALSE);0)",
    "G10": "=IFERROR(VLOOKUP(B10;'Эта неделя'!$B$3:$E$120;4;FALSE);0)",
    "H10": "=IF(C10>=10;F10-70;(F10+G10)-70)+J10",
    "I10": "=H10+J10"
}

for (var key in logics) {
  formulaPaste (list, counter, key, logics[key]);
  counter++;
}

function formulaPaste (list, i, cell, formula){  
  list.getRange(cell).setFormula(formula);
  var row = list.getLastRow();
  var range = list.getRange(10, i, row-9);
  list.getRange(cell).copyTo(range);
}

function doGet(e){
  var list = e.parameter.list;

var values = SpreadsheetApp.getActiveSheet().getDataRange().getValues();
  values.forEach( function(row) {
    Logger.log(row[2] );
  });