{"id":552,"date":"2024-03-16T01:05:52","date_gmt":"2024-03-15T23:05:52","guid":{"rendered":"https:\/\/portfooandreei.wordpress.com\/?p=552"},"modified":"2024-03-16T01:05:52","modified_gmt":"2024-03-15T23:05:52","slug":"google-scripts","status":"publish","type":"post","link":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/","title":{"rendered":"Google scripts"},"content":{"rendered":"\n<p>1.<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<pre class=\"wp-block-syntaxhighlighter-code\">\u0418\u0437\u043d\u0430\u0447\u0430\u043b\u044c\u043d\u044b\u0439 \u043a\u043e\u0434\n----------------------------------\nfunction myFunction10() {\n \n    \/\/ https:\/\/developers.google.com\/apps-script\/reference\/mail\/mail-app\n \n    \/\/ \u041e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u043c \u043f\u0440\u043e\u0441\u0442\u043e\u0435 \u043f\u0438\u0441\u044c\u043c\u043e\n    MailApp.sendEmail({\n        to: 'mymail@gmail.com', \/\/ Email \u043f\u043e\u043b\u0443\u0447\u0430\u0442\u0435\u043b\u044f \u043f\u0438\u0441\u044c\u043c\u0430\n        subject: '\u0422\u0435\u043c\u0430 \u043f\u0438\u0441\u044c\u043c\u0430',\n        body: \"Line 1\\r\\nLine 2\\r\\nLine 3\", \/\/ \u0421\u043e\u0434\u0435\u0440\u0436\u0438\u043c\u043e\u0435 \u043f\u0438\u0441\u044c\u043c\u0430\n    });\n \n    \/\/ \u041e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u043c \u043f\u0438\u0441\u044c\u043c\u043e \u0441 \u043f\u0440\u0438\u043a\u0440\u0435\u043f\u043b\u0435\u043d\u043d\u044b\u043c \u0444\u0430\u0439\u043b\u043e\u043c\n \n    \/\/ 1bPpy2Mm7sAffcZwSvuxOooPfrhfEWuE2 - ID Pdf \u0444\u0430\u0439\u043b\u0430, \u0445\u0440\u0430\u043d\u044f\u0449\u0435\u0433\u043e\u0441\u044f \u043d\u0430 \u0433\u0443\u0433\u043b \u0434\u0438\u0441\u043a\u0435\n    var pdfFileBlob = DriveApp.getFileById( '1bPpy2Mm7sAffcZwSvuxOooPfrhfEWuE2' ).getBlob();\n \n    MailApp.sendEmail({\n        to: 'mymail@gmail.com', \/\/ Email \u043f\u043e\u043b\u0443\u0447\u0430\u0442\u0435\u043b\u044f \u043f\u0438\u0441\u044c\u043c\u0430\n        subject: '\u0422\u0435\u043c\u0430 \u043f\u0438\u0441\u044c\u043c\u0430 2',\n        body: \"Line 1\\r\\nLine 2\\r\\nLine 3\", \/\/ \u0421\u043e\u0434\u0435\u0440\u0436\u0438\u043c\u043e\u0435 \u043f\u0438\u0441\u044c\u043c\u0430\n \n        \/\/ \u041f\u0440\u0438\u043a\u0440\u0435\u043f\u043b\u044f\u0435\u043c \u0444\u0430\u0439\u043b\n        attachments: [pdfFileBlob]\n    });\n \n}<\/pre>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<pre class=\"wp-block-syntaxhighlighter-code\">\u041c\u043e\u0439 \u043a\u043e\u0434\n------------------------------------\n\nfunction myFunction() {\n  let ss = SpreadsheetApp.getActiveSpreadsheet(); \/\/\u0430\u043a\u0442\u0438\u0432\u0430\u0446\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b\n  let sheet =  ss.getSheetByName('\u041b\u0438\u0441\u04421'); \/\/ \u043d\u0430\u0445\u043e\u0436\u0434\u0435\u043d\u0438\u0435 \u043d\u0443\u0434\u043d\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u043f\u043e \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u044e\n  let dataRange = sheet.getRange(2,1,4,3).getValues(); \/\/ \u043d\u0430\u0445\u043e\u0436\u0434\u0435\u043d\u0438\u0435 \u0434\u0438\u0430\u043f\u0430\u0437\u043e\u043d\u0430 \u044f\u0447\u0435\u0435\u043a(2 \u0441\u0442\u0440\u043e\u043a\u0430, 1 \u0441\u0442\u043e\u043b\u0431\u0435\u0446, 4 \u043a\u043e\u043b-\u0432\u043e \u0441\u0442\u0440\u043e\u043a, 3 \u043a\u043e\u043b-\u0432\u043e \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432)\n\n  for(let i = 0; i &lt; dataRange.length; i++){ \/\/ \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0446\u0438\u043a\u043b\u0430 \u043f\u0440\u043e\u0438\u0441\u0445\u043e\u0434\u0438\u0442 \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0430 \u043f\u0438\u0441\u0435\u043c, \u0437\u0430\u043a\u0430\u043d\u0447\u0438\u0432\u0430\u0435\u0442\u0441\u044f \u043d\u0430 4 (\u0434\u043b\u0438\u043d\u0430 \u0441\u0440\u043e\u043a)\n    let mail = dataRange[i][0];\n    let ru = dataRange[i][1];\n    let en = dataRange[i][2];\n    MailApp.sendEmail(mail, ru, en, \"Hello\"); \/\/ \u041e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u043c \u043f\u0438\u0441\u044c\u043c\u043e \u0432\u043d\u0443\u0442\u0440\u0438 \u0446\u0438\u043a\u043b\u0430\n  };\n\n\/\/ 1bPpy2Mm7sAffcZwSvuxOooPfrhfEWuE2 - ID Pdf \u0444\u0430\u0439\u043b\u0430, \u0445\u0440\u0430\u043d\u044f\u0449\u0435\u0433\u043e\u0441\u044f \u043d\u0430 \u0433\u0443\u0433\u043b \u0434\u0438\u0441\u043a\u0435\n    var pdfFileBlob = DriveApp.getFileById( '18JhxnP1XHskmcSkjKXlGljAlKdrsVPGvuOUTxvHwVtI' ).getBlob();\n\n    MailApp.sendEmail({\n        to: 'andrei.tupitsin@gmail.com', \/\/ Email \u043f\u043e\u043b\u0443\u0447\u0430\u0442\u0435\u043b\u044f \u043f\u0438\u0441\u044c\u043c\u0430\n        subject: '\u0422\u0435\u043c\u0430 \u043f\u0438\u0441\u044c\u043c\u0430 2',\n        body: \"Line 1\\r\\nLine 2\\r\\nLine 3\", \/\/ \u0421\u043e\u0434\u0435\u0440\u0436\u0438\u043c\u043e\u0435 \u043f\u0438\u0441\u044c\u043c\u0430\n\n        \/\/ \u041f\u0440\u0438\u043a\u0440\u0435\u043f\u043b\u044f\u0435\u043c \u0444\u0430\u0439\u043b\n        attachments: [pdfFileBlob]\n    });\n}<\/pre>\n<\/div>\n<\/div>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" data-id=\"556\" src=\"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-10.png?w=834\" alt=\"\" class=\"wp-image-556\" \/><\/figure>\n<\/figure>\n\n\n\n<p>2.<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<pre class=\"wp-block-syntaxhighlighter-code\">\u0418\u0441\u0445\u043e\u0434\u043d\u044b\u0439 \u043a\u043e\u0434\n-------------------------------\n\n\/\/ \u0424\u0443\u043d\u043a\u0446\u0438\u044f onOpen() \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u0442\u0441\u044f \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438 \u043f\u0440\u0438 \u043e\u0442\u043a\u0440\u044b\u0442\u0438\u0438 \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430\n\/\/ https:\/\/developers.google.com\/apps-script\/guides\/triggers\/#onopen\nfunction onOpen() {\n \n  \/\/ \u0421\u043e\u0437\u0434\u0430\u0451\u043c \u043d\u043e\u0432\u043e\u0435 \u043c\u0435\u043d\u044e\n  \/\/ https:\/\/developers.google.com\/apps-script\/reference\/base\/ui#createmenucaption\n  SpreadsheetApp.getUi()\n      .createMenu('Custom Menu')\n      .addItem('Show alert', 'showAlert')\n      .addItem('Show prompt', 'showPrompt')\n      .addToUi();\n}\n \nfunction showAlert() {\n  var ui = SpreadsheetApp.getUi();\n \n  \/\/ https:\/\/developers.google.com\/apps-script\/reference\/base\/ui#alerttitle-prompt-buttons\n  var result = ui.alert(\n     '\u041f\u043e\u0434\u0442\u0432\u0435\u0440\u0434\u0438\u0442\u0435 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0435', \/\/ \u0417\u0430\u0433\u043e\u043b\u043e\u0432\u043e\u043a \u043e\u043a\u043d\u0430\n     '\u0412\u044b \u0443\u0432\u0435\u0440\u0435\u043d\u044b, \u0447\u0442\u043e \u0445\u043e\u0442\u0438\u0442\u0435 \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0438\u0442\u044c?', \/\/ \u0421\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435\n      ui.ButtonSet.YES_NO \/\/ \u041a\u043d\u043e\u043f\u043a\u0438\n  );\n \n  if (result == ui.Button.YES) { \/\/ \u041f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043d\u0430\u0436\u0430\u043b \u043d\u0430 \"\u0414\u0430\"\n    \/\/ User clicked \"Yes\".\n    ui.alert('\u041f\u043e\u0434\u0442\u0432\u0435\u0440\u0436\u0434\u0435\u043d\u0438\u0435 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043e.');\n  } else { \/\/ \u041f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043d\u0430\u0436\u0430\u043b \u043d\u0430 \"\u041d\u0435\u0442\" \u0438\u043b\u0438 \u043d\u0430 X (\u0437\u0430\u043a\u0440\u044b\u043b \u043e\u043a\u043d\u043e)\n    ui.alert('\u0412 \u0440\u0430\u0437\u0440\u0435\u0448\u0435\u043d\u0438\u0438 \u043e\u0442\u043a\u0430\u0437\u0430\u043d\u043e.');\n  }\n}\n \nfunction showPrompt() {\n  var ui = SpreadsheetApp.getUi();\n \n  \/\/ https:\/\/developers.google.com\/apps-script\/reference\/base\/ui#prompttitle-prompt-buttons\n  var result = ui.prompt(\n      '\u0421\u043e\u043e\u0431\u0449\u0438\u0442\u0435 \u0447\u0442\u043e-\u043d\u0438\u0431\u0443\u0434\u044c \u043e \u0441\u0435\u0431\u0435!', \/\/ \u0417\u0430\u0433\u043e\u043b\u043e\u0432\u043e\u043a\n      '\u0412\u0432\u0435\u0434\u0438\u0442\u0435 \u0441\u0432\u043e\u0451 \u0438\u043c\u044f:', \/\/ \u0421\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435\n      ui.ButtonSet.OK_CANCEL \/\/ \u041a\u043d\u043e\u043f\u043a\u0438\n  );\n \n  var button = result.getSelectedButton(); \/\/ \u041a\u043d\u043e\u043f\u043a\u0430, \u043d\u0430 \u043a\u043e\u0442\u043e\u0440\u0443\u044e \u043d\u0430\u0436\u0430\u043b \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c\n  var text = result.getResponseText(); \/\/ \u0422\u0435\u043a\u0441\u0442, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0432\u0432\u0451\u043b \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c\n \n  if (button == ui.Button.OK) {\n    ui.alert('\u0412\u0430\u0448\u0435 \u0438\u043c\u044f: ' + text + '.');\n  } else if (button == ui.Button.CANCEL) {\n    ui.alert('\u0412\u044b \u043e\u0442\u043a\u0430\u0437\u0430\u043b\u0438\u0441\u044c \u0432\u0432\u043e\u0434\u0438\u0442\u044c \u0441\u0432\u043e\u0451 \u0438\u043c\u044f.');\n  } else if (button == ui.Button.CLOSE) {\n    ui.alert('\u0412\u044b \u0437\u0430\u043a\u0440\u044b\u043b\u0438 \u043e\u043a\u043d\u043e.');\n  }\n}<\/pre>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<pre class=\"wp-block-syntaxhighlighter-code\">\u041c\u043e\u0439 \u043a\u043e\u0434\n---------------------------------\n\n\/\/ \u0424\u0443\u043d\u043a\u0446\u0438\u044f onOpen() \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u0442\u0441\u044f \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438 \u043f\u0440\u0438 \u043e\u0442\u043a\u0440\u044b\u0442\u0438\u0438 \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430\n\/\/ https:\/\/developers.google.com\/apps-script\/guides\/triggers\/#onopen\nfunction onOpen() {\n \n  \/\/ \u0421\u043e\u0437\u0434\u0430\u0451\u043c \u043d\u043e\u0432\u043e\u0435 \u043c\u0435\u043d\u044e\n  \/\/ https:\/\/developers.google.com\/apps-script\/reference\/base\/ui#createmenucaption\n  SpreadsheetApp.getUi()\n      .createMenu('Custom Menu')\n      .addItem('Show alert', 'showAlert')\n      .addItem('Show prompt', 'showPrompt')\n      .addItem('Show prompt2', 'showPrompt2')\n      .addToUi();\n}\n \nfunction showAlert() {\n  var ui = SpreadsheetApp.getUi();\n \n  \/\/ https:\/\/developers.google.com\/apps-script\/reference\/base\/ui#alerttitle-prompt-buttons\n  var result = ui.alert(\n     '\u041f\u043e\u0434\u0442\u0432\u0435\u0440\u0434\u0438\u0442\u0435 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0435', \/\/ \u0417\u0430\u0433\u043e\u043b\u043e\u0432\u043e\u043a \u043e\u043a\u043d\u0430\n     '\u0412\u044b \u0443\u0432\u0435\u0440\u0435\u043d\u044b, \u0447\u0442\u043e \u0445\u043e\u0442\u0438\u0442\u0435 \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0438\u0442\u044c?', \/\/ \u0421\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435\n      ui.ButtonSet.YES_NO \/\/ \u041a\u043d\u043e\u043f\u043a\u0438\n  );\n \n  if (result == ui.Button.YES) { \/\/ \u041f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043d\u0430\u0436\u0430\u043b \u043d\u0430 \"\u0414\u0430\"\n    \/\/ User clicked \"Yes\".\n    ui.alert('\u041f\u043e\u0434\u0442\u0432\u0435\u0440\u0436\u0434\u0435\u043d\u0438\u0435 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043e.');\n  } else { \/\/ \u041f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043d\u0430\u0436\u0430\u043b \u043d\u0430 \"\u041d\u0435\u0442\" \u0438\u043b\u0438 \u043d\u0430 X (\u0437\u0430\u043a\u0440\u044b\u043b \u043e\u043a\u043d\u043e)\n    ui.alert('\u0412 \u0440\u0430\u0437\u0440\u0435\u0448\u0435\u043d\u0438\u0438 \u043e\u0442\u043a\u0430\u0437\u0430\u043d\u043e.');\n  }\n}\n \nfunction showPrompt() {\n  var ui = SpreadsheetApp.getUi();\n \n  \/\/ https:\/\/developers.google.com\/apps-script\/reference\/base\/ui#prompttitle-prompt-buttons\n  var result = ui.prompt(\n      '\u0421\u043e\u043e\u0431\u0449\u0438\u0442\u0435 \u0447\u0442\u043e-\u043d\u0438\u0431\u0443\u0434\u044c \u043e \u0441\u0435\u0431\u0435!', \/\/ \u0417\u0430\u0433\u043e\u043b\u043e\u0432\u043e\u043a\n      '\u0412\u0432\u0435\u0434\u0438\u0442\u0435 \u0441\u0432\u043e\u0451 \u0438\u043c\u044f:', \/\/ \u0421\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435\n      ui.ButtonSet.OK_CANCEL \/\/ \u041a\u043d\u043e\u043f\u043a\u0438\n  );\n \n  var button = result.getSelectedButton(); \/\/ \u041a\u043d\u043e\u043f\u043a\u0430, \u043d\u0430 \u043a\u043e\u0442\u043e\u0440\u0443\u044e \u043d\u0430\u0436\u0430\u043b \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c\n  var text = result.getResponseText(); \/\/ \u0422\u0435\u043a\u0441\u0442, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0432\u0432\u0451\u043b \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c\n \n  if (button == ui.Button.OK) {\n    ui.alert('\u0412\u0430\u0448\u0435 \u0438\u043c\u044f: ' + text + '.');\n  } else if (button == ui.Button.CANCEL) {\n    ui.alert('\u0412\u044b \u043e\u0442\u043a\u0430\u0437\u0430\u043b\u0438\u0441\u044c \u0432\u0432\u043e\u0434\u0438\u0442\u044c \u0441\u0432\u043e\u0451 \u0438\u043c\u044f.');\n  } else if (button == ui.Button.CLOSE) {\n    ui.alert('\u0412\u044b \u0437\u0430\u043a\u0440\u044b\u043b\u0438 \u043e\u043a\u043d\u043e.');\n  }\n}\n\nfunction showPrompt2() {\n  var ui = SpreadsheetApp.getUi();\n \n  \/\/ https:\/\/developers.google.com\/apps-script\/reference\/base\/ui#prompttitle-prompt-buttons\n  var result = ui.prompt(\n      '\u0421\u043a\u043e\u043b\u044c\u043a\u043e \u0432\u0430\u043c \u043b\u0435\u0442', \/\/ \u0417\u0430\u0433\u043e\u043b\u043e\u0432\u043e\u043a\n      '\u0412\u043e\u0437\u0440\u0430\u0441\u0442:', \/\/ \u0421\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435\n      ui.ButtonSet.OK_CANCEL \/\/ \u041a\u043d\u043e\u043f\u043a\u0438\n  );\n \n  var button = result.getSelectedButton(); \/\/ \u041a\u043d\u043e\u043f\u043a\u0430, \u043d\u0430 \u043a\u043e\u0442\u043e\u0440\u0443\u044e \u043d\u0430\u0436\u0430\u043b \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c\n  var text = result.getResponseText(); \/\/ \u0422\u0435\u043a\u0441\u0442, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0432\u0432\u0451\u043b \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c\n \n  if (button == ui.Button.OK) {\n    ui.alert('\u0412\u043e\u0437\u0440\u0430\u0441\u0442: ' + text + '.');\n  } else if (button == ui.Button.CANCEL) {\n    ui.alert('\u041e\u0442\u043a\u0430\u0437.');\n  } else if (button == ui.Button.CLOSE) {\n    ui.alert('\u0412\u044b \u0437\u0430\u043a\u0440\u044b\u043b\u0438 \u043e\u043a\u043d\u043e.');\n  }\n}<\/pre>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>1. 2.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-552","post","type-post","status-publish","format-standard","hentry","category-4","entry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Google scripts - \/ \u041f\u043e\u0440\u0442\u0444\u043e\u043b\u0438\u043e<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/\" \/>\n<meta property=\"og:locale\" content=\"ru_RU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google scripts - \/ \u041f\u043e\u0440\u0442\u0444\u043e\u043b\u0438\u043e\" \/>\n<meta property=\"og:description\" content=\"1. 2.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/\" \/>\n<meta property=\"og:site_name\" content=\"\/ \u041f\u043e\u0440\u0442\u0444\u043e\u043b\u0438\u043e\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T23:05:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-10.png?w=834\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0430\u0432\u0442\u043e\u0440\u043e\u043c\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u043c\u0438\u043d\u0443\u0442\u044b\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/2024\\\/03\\\/16\\\/google-scripts\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/2024\\\/03\\\/16\\\/google-scripts\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/#\\\/schema\\\/person\\\/450d3fec34682741b4b65a21dcace8c3\"},\"headline\":\"Google scripts\",\"datePublished\":\"2024-03-15T23:05:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/2024\\\/03\\\/16\\\/google-scripts\\\/\"},\"wordCount\":2,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/2024\\\/03\\\/16\\\/google-scripts\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/portfooandreei.files.wordpress.com\\\/2024\\\/03\\\/image-10.png?w=834\",\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/2024\\\/03\\\/16\\\/google-scripts\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/2024\\\/03\\\/16\\\/google-scripts\\\/\",\"url\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/2024\\\/03\\\/16\\\/google-scripts\\\/\",\"name\":\"Google scripts - \\\/ \u041f\u043e\u0440\u0442\u0444\u043e\u043b\u0438\u043e\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/2024\\\/03\\\/16\\\/google-scripts\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/2024\\\/03\\\/16\\\/google-scripts\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/portfooandreei.files.wordpress.com\\\/2024\\\/03\\\/image-10.png?w=834\",\"datePublished\":\"2024-03-15T23:05:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/2024\\\/03\\\/16\\\/google-scripts\\\/#breadcrumb\"},\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/2024\\\/03\\\/16\\\/google-scripts\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/2024\\\/03\\\/16\\\/google-scripts\\\/#primaryimage\",\"url\":\"https:\\\/\\\/portfooandreei.files.wordpress.com\\\/2024\\\/03\\\/image-10.png?w=834\",\"contentUrl\":\"https:\\\/\\\/portfooandreei.files.wordpress.com\\\/2024\\\/03\\\/image-10.png?w=834\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/2024\\\/03\\\/16\\\/google-scripts\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\",\"item\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google scripts\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/#website\",\"url\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/\",\"name\":\"\\\/ \u041f\u043e\u0440\u0442\u0444\u043e\u043b\u0438\u043e\",\"description\":\"\u0414\u043e\u0431\u0440\u043e \u043f\u043e\u0436\u0430\u043b\u043e\u0432\u0430\u0442\u044c \u043d\u0430 \u043c\u043e\u0439 \u0441\u0430\u0439\u0442!\",\"publisher\":{\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ru-RU\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/#organization\",\"name\":\"\\\/ \u041f\u043e\u0440\u0442\u0444\u043e\u043b\u0438\u043e\",\"url\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/04\\\/cropped-logo.png\",\"contentUrl\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/04\\\/cropped-logo.png\",\"width\":240,\"height\":240,\"caption\":\"\\\/ \u041f\u043e\u0440\u0442\u0444\u043e\u043b\u0438\u043e\"},\"image\":{\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/#\\\/schema\\\/person\\\/450d3fec34682741b4b65a21dcace8c3\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/76f3e9df53e4a24d9844001a0319ca379af1ce7b9919f8b54cf7c45ff1f214d1?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/76f3e9df53e4a24d9844001a0319ca379af1ce7b9919f8b54cf7c45ff1f214d1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/76f3e9df53e4a24d9844001a0319ca379af1ce7b9919f8b54cf7c45ff1f214d1?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\"],\"url\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/rus\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google scripts - \/ \u041f\u043e\u0440\u0442\u0444\u043e\u043b\u0438\u043e","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/","og_locale":"ru_RU","og_type":"article","og_title":"Google scripts - \/ \u041f\u043e\u0440\u0442\u0444\u043e\u043b\u0438\u043e","og_description":"1. 2.","og_url":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/","og_site_name":"\/ \u041f\u043e\u0440\u0442\u0444\u043e\u043b\u0438\u043e","article_published_time":"2024-03-15T23:05:52+00:00","og_image":[{"url":"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-10.png?w=834","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0430\u0432\u0442\u043e\u0440\u043e\u043c":"admin","\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f":"3 \u043c\u0438\u043d\u0443\u0442\u044b"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/#article","isPartOf":{"@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/"},"author":{"name":"admin","@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/#\/schema\/person\/450d3fec34682741b4b65a21dcace8c3"},"headline":"Google scripts","datePublished":"2024-03-15T23:05:52+00:00","mainEntityOfPage":{"@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/"},"wordCount":2,"commentCount":0,"publisher":{"@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/#organization"},"image":{"@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/#primaryimage"},"thumbnailUrl":"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-10.png?w=834","inLanguage":"ru-RU","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/","url":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/","name":"Google scripts - \/ \u041f\u043e\u0440\u0442\u0444\u043e\u043b\u0438\u043e","isPartOf":{"@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/#website"},"primaryImageOfPage":{"@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/#primaryimage"},"image":{"@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/#primaryimage"},"thumbnailUrl":"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-10.png?w=834","datePublished":"2024-03-15T23:05:52+00:00","breadcrumb":{"@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/#breadcrumb"},"inLanguage":"ru-RU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/"]}]},{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/#primaryimage","url":"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-10.png?w=834","contentUrl":"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-10.png?w=834"},{"@type":"BreadcrumbList","@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/2024\/03\/16\/google-scripts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/"},{"@type":"ListItem","position":2,"name":"Google scripts"}]},{"@type":"WebSite","@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/#website","url":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/","name":"\/ \u041f\u043e\u0440\u0442\u0444\u043e\u043b\u0438\u043e","description":"\u0414\u043e\u0431\u0440\u043e \u043f\u043e\u0436\u0430\u043b\u043e\u0432\u0430\u0442\u044c \u043d\u0430 \u043c\u043e\u0439 \u0441\u0430\u0439\u0442!","publisher":{"@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ru-RU"},{"@type":"Organization","@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/#organization","name":"\/ \u041f\u043e\u0440\u0442\u0444\u043e\u043b\u0438\u043e","url":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/","logo":{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/#\/schema\/logo\/image\/","url":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/wp-content\/uploads\/sites\/2\/2024\/04\/cropped-logo.png","contentUrl":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/wp-content\/uploads\/sites\/2\/2024\/04\/cropped-logo.png","width":240,"height":240,"caption":"\/ \u041f\u043e\u0440\u0442\u0444\u043e\u043b\u0438\u043e"},"image":{"@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/#\/schema\/person\/450d3fec34682741b4b65a21dcace8c3","name":"admin","image":{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/secure.gravatar.com\/avatar\/76f3e9df53e4a24d9844001a0319ca379af1ce7b9919f8b54cf7c45ff1f214d1?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/76f3e9df53e4a24d9844001a0319ca379af1ce7b9919f8b54cf7c45ff1f214d1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/76f3e9df53e4a24d9844001a0319ca379af1ce7b9919f8b54cf7c45ff1f214d1?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/andreitupits23.thkit.ee\/WP"],"url":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/wp-json\/wp\/v2\/posts\/552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/wp-json\/wp\/v2\/comments?post=552"}],"version-history":[{"count":0,"href":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/wp-json\/wp\/v2\/posts\/552\/revisions"}],"wp:attachment":[{"href":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/wp-json\/wp\/v2\/media?parent=552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/wp-json\/wp\/v2\/categories?post=552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andreitupits23.thkit.ee\/WP\/rus\/wp-json\/wp\/v2\/tags?post=552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}