{"id":505,"date":"2025-04-09T09:34:51","date_gmt":"2025-04-09T09:34:51","guid":{"rendered":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/?page_id=505"},"modified":"2025-04-09T11:54:06","modified_gmt":"2025-04-09T11:54:06","slug":"loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis","status":"publish","type":"page","link":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\/","title":{"rendered":"Loov\u00fclesanne: Skript loob uusi kaustu ja tekstifaile Google Drive’is."},"content":{"rendered":"\n

Teostamise sammud:<\/h3>\n\n\n\n

Scripti redaktori avamine:<\/strong><\/p>\n\n\n\n

Minge Google Apps Script<\/strong> ja looge uus projekt v\u00f5i avage see otse Google Drive’is<\/strong> men\u00fc\u00fcst “Laiendused”<\/strong> -> “Apps Script”<\/strong>.<\/p>\n\n\n\n

Scripti kirjutamine<\/strong><\/p>\n\n\n\n

Kleepige j\u00e4rgmine kood redaktorisse:
<\/p>\n\n\n

\nfunction createFolderAndFile() {\n  \/\/ Loome kausta nimega, mis vastab t\u00e4nase kuup\u00e4evaga\n  var today = new Date();\n  var folderName = Utilities.formatDate(today, Session.getScriptTimeZone(), 'yyyy-MM-dd');\n  var folder = DriveApp.createFolder(folderName);\n  Logger.log('Loodi kaust: ' + folderName);\n\n  \/\/ Loome tekstifaili selles kaustas\n  var fileName = folderName + '_report.txt';\n  var fileContent = 'See on aruanne kuup\u00e4evaga ' + folderName + '.\\nLoomise kuup\u00e4ev: ' + today.toLocaleString();\n  var file = folder.createFile(fileName, fileContent);\n  Logger.log('Loodi fail: ' + fileName);\n}\n\n<\/pre><\/div>\n\n\n
<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
Mida teeb see kood?<\/strong><\/p>\n\n\n\n
    \n
  1. Esiteks loob skript kausta, mille nimi vastab t\u00e4nasele kuup\u00e4evale (n\u00e4iteks “2025-03-20”).<\/li>\n\n\n\n
  2. Seej\u00e4rel loob skript selles kaustas tekstifaili nimega “2025-03-20_report.txt”, mis sisaldab tekstiaruannet koos t\u00e4nase kuup\u00e4evaga.<\/li>\n<\/ol>\n\n\n\n
    Scripti k\u00e4ivitamine:<\/strong><\/p>\n\n\n\n
    Skripti k\u00e4ivitamiseks vajutage redaktoris nuppu “K\u00e4ivita”<\/strong>. P\u00e4rast seda t\u00e4idab skript kausta ja faili loomise teie Google Drive’is<\/strong>.<\/p>\n\n\n\n
    Tulemuse vaatamine:<\/strong><\/p>\n\n\n\n
      \n
    1. Minge oma Google Drive’i<\/strong> ja leidke kaust, mille nimi vastab t\u00e4nasele kuup\u00e4evale.<\/li>\n\n\n\n
    2. Avage see kaust ja leiate tekstifaili aruandega.<\/li>\n<\/ol>\n\n\n\n
      <\/p>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      <\/p>\n\n\n\n
      <\/p>\n\n\n\n
      T\u00e4iendavad v\u00f5imalused:<\/strong><\/p>\n\n\n\n
      Mitme kausta loomine<\/strong><\/p>\n\n\n\n
       Kui on vaja luua kaustu erinevate eesm\u00e4rkide v\u00f5i erinevate kasutajate jaoks, saab funktsionaalsust laiendada, lisades mitme kausta loomise unikaalsete nimedega.<\/p>\n\n\n
      \nfunction createMultipleFolders() {\n  var folderNames = ['Projekt A', 'Projekt B', 'Projekt C'];\n  for (var i = 0; i < folderNames.length; i++) {\n    DriveApp.createFolder(folderNames[i]);\n    Logger.log('Looodi kaust: ' + folderNames[i]);\n  }\n}\n\n<\/pre><\/div>\n\n\n
      \"\"<\/figure>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      Andmete salvestamine CSV-faili<\/strong><\/p>\n\n\n\n
      Samuti saab luua CSV-faili (comma-separated values file) ja salvestada andmeid sellesse. See v\u00f5ib olla kasulik aruandluse v\u00f5i andmete logimise jaoks.<\/p>\n\n\n\n
      <\/p>\n\n\n\n
      CSV (Comma-Separated Values) fail on tekstifail, kus andmed on eraldatud komadega. Iga rida failis esindab \u00fcht andmeread (n\u00e4iteks tabeli \u00fche rida) ja iga v\u00e4\u00e4rtus on eraldatud komaga. CSV formaati kasutatakse sageli andmete salvestamiseks ja vahetamiseks, kuna seda saab lugeda ja t\u00f6\u00f6delda paljude erinevate programmidega, nagu n\u00e4iteks Microsoft Excel v\u00f5i Google Sheets.<\/p>\n\n\n\n
      Eesti keeles v\u00f5iks \u00f6elda, et CSV fail<\/strong> on “komaga eraldatud v\u00e4\u00e4rtuste fail”, mis on lihtne viis andmete salvestamiseks tekstina.<\/p>\n\n\n
      \nfunction createCSVFile() {\n  var data = [\n    ['Kuup\u00e4ev', 'Kulud', 'Tulu'],\n    ['2025-03-20', 500, 1500],\n    ['2025-03-21', 300, 2000]\n  ];\n\n  var csvContent = '';\n  data.forEach(function(row) {\n    csvContent += row.join(',') + '\\n';\n  });\n\n  var folder = DriveApp.createFolder('Aruanded');\n  var file = folder.createFile('finantsaruanne.csv', csvContent);\n  Logger.log('CSV fail loodi: ' + file.getName());\n}\n\n<\/pre><\/div>\n\n\n
      \"\"<\/figure>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      <\/p>\n\n\n\n
      K\u00e4ivitamise ajastamine (automaatse loomise jaoks)<\/strong><\/p>\n\n\n\n
      Kui soovite, et kaustad v\u00f5i failid loodi automaatselt vastavalt ajakavale, seadistage k\u00e4ivitamise ajastamine:<\/p>\n\n\n\n
        \n
      1. Google Apps Scripti redaktoris minge “K\u00e4ivitajad”<\/strong> (kellakujuline ikoon).<\/li>\n\n\n\n
      2. Kl\u00f5psake nuppu “Lisa k\u00e4ivitaja”<\/strong> ja valige sobiv funktsioon, n\u00e4iteks createFolderAndFile<\/strong>.<\/li>\n\n\n\n
      3. Seadistage k\u00e4ivitaja nii, et see t\u00e4idetaks n\u00e4iteks iga p\u00e4ev v\u00f5i iga n\u00e4dal.<\/li>\n<\/ol>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        Tulemus:<\/strong><\/p>\n\n\n\n
        Selle skripti abil saate automaatselt luua kaustu ja faile Google Drive’is<\/strong>, mis on kasulik erinevates automaatsetes protsessides, nagu aruandlus, failide korraldamine v\u00f5i andmet\u00f6\u00f6tlus.<\/p>\n\n\n\n
        See n\u00e4ide n\u00e4itab, kuidas Google Apps Scriptiga saab integreerida Google Drive’i<\/strong> teiste teenustega ja automatiseerida igap\u00e4evaseid \u00fclesandeid!<\/p>\n\n\n\n
        <\/p>\n\n\n\n
        <\/p>\n\n\n\n
        <\/p>\n\n\n\n
        Minu t\u00e4iustused skriptidele<\/strong>:<\/p>\n\n\n
        \nfunction createFolderAndFile() {\n  \/\/ \u0417\u0430\u043f\u0440\u043e\u0441\u0438\u0442\u044c \u0443 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0438\u043c\u044f \u043f\u0430\u043f\u043a\u0438 (folder name)\n  var folderName = Browser.inputBox('Enter folder name:', Browser.Buttons.OK_CANCEL);\n  if (folderName == 'cancel') return; \/\/ \u0415\u0441\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043e\u0442\u043c\u0435\u043d\u0438\u043b, \u043e\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438\n  \n  \/\/ \u0417\u0430\u043f\u0440\u043e\u0441\u0438\u0442\u044c \u0443 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0438\u043c\u044f \u0444\u0430\u0439\u043b\u0430 (file name) \u0438 \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u0435\n  var fileName = Browser.inputBox('Enter the file name (with extension, e.g., report.txt):', Browser.Buttons.OK_CANCEL);\n  if (fileName == 'cancel') return; \/\/ \u0415\u0441\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043e\u0442\u043c\u0435\u043d\u0438\u043b, \u043e\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438\n  \n  \/\/ \u0417\u0430\u043f\u0440\u043e\u0441\u0438\u0442\u044c \u0443 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u043c\u043e\u0435 \u0444\u0430\u0439\u043b\u0430 (file content)\n  var fileContent = Browser.inputBox('Enter the content of the file:', Browser.Buttons.OK_CANCEL);\n  if (fileContent == 'cancel') return; \/\/ \u0415\u0441\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043e\u0442\u043c\u0435\u043d\u0438\u043b, \u043e\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438\n\n  \/\/ \u0421\u043e\u0437\u0434\u0430\u0442\u044c \u043f\u0430\u043f\u043a\u0443 \u043d\u0430 Google Drive \u0441 \u0443\u043a\u0430\u0437\u0430\u043d\u043d\u044b\u043c \u0438\u043c\u0435\u043d\u0435\u043c (create folder)\n  var folder = DriveApp.createFolder(folderName);\n  Logger.log('Created folder: ' + folderName); \/\/ \u041b\u043e\u0433\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u043f\u0430\u043f\u043a\u0438\n\n  \/\/ \u0421\u043e\u0437\u0434\u0430\u0442\u044c \u0442\u0435\u043a\u0441\u0442\u043e\u0432\u044b\u0439 \u0444\u0430\u0439\u043b \u0432\u043d\u0443\u0442\u0440\u0438 \u043f\u0430\u043f\u043a\u0438 \u0441 \u0443\u043a\u0430\u0437\u0430\u043d\u043d\u044b\u043c \u0438\u043c\u0435\u043d\u0435\u043c \u0438 \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u043c\u044b\u043c\n  var file = folder.createFile(fileName, fileContent);\n  Logger.log('Created file: ' + fileName); \/\/ \u041b\u043e\u0433\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0444\u0430\u0439\u043b\u0430\n}\n\n<\/pre><\/div>\n\n\n
        Kood teeb j\u00e4rgmist:<\/strong><\/p>\n\n\n\n
          \n
        1. Kasutaja sisendi k\u00fcsimine<\/strong>:\n
            \n
          • Kood k\u00fcsib kasutajalt kolme erinevat sisendit:\n
              \n
            • Kausta nimi<\/strong>: Kasutaja peab sisestama nime, mille alusel kaust luuakse.<\/li>\n\n\n\n
            • Faili nimi<\/strong>: Kasutaja sisestab faili nime koos laiendiga (nt report.txt<\/code>).<\/li>\n\n\n\n
            • Faili sisu<\/strong>: Kasutaja sisestab, mis sisu failis peaks olema.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
            • Kausta loomine<\/strong>:\n
                \n
              • P\u00e4rast seda, kui kasutaja on kausta nime sisestanud, loob skript kausta Google Drive’i kasutades DriveApp.createFolder()<\/code> meetodit.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
              • Faili loomine<\/strong>:\n
                  \n
                • Fail luuakse valitud kausta sees, kasutades folder.createFile()<\/code> meetodit, kus fail saab sisuks kasutaja m\u00e4\u00e4ratud sisu.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
                • Logimine<\/strong>:\n
                    \n
                  • Kood kasutab Logger.log()<\/code> meetodit, et logida loodud kaustade ja failide nimed, et need oleksid n\u00e4htavad arendaja logis.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n
                    \"\"<\/figure>\n\n\n\n
                    \"\"<\/figure>\n\n\n\n
                    \"\"<\/figure>\n\n\n\n
                    Tulemus:<\/strong><\/p>\n\n\n\n
                    \"\"<\/figure>\n\n\n\n
                    \"\"<\/figure>\n\n\n
                    \nfunction createMultipleFolders() {\n  \/\/ \u0417\u0430\u043f\u0440\u0430\u0448\u0438\u0432\u0430\u0435\u043c \u0443 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f, \u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043f\u0430\u043f\u043e\u043a \u043e\u043d \u0445\u043e\u0447\u0435\u0442 \u0441\u043e\u0437\u0434\u0430\u0442\u044c\n  var numFolders = Browser.inputBox('\u0421\u043a\u043e\u043b\u044c\u043a\u043e \u043f\u0430\u043f\u043e\u043a \u0432\u044b \u0445\u043e\u0442\u0438\u0442\u0435 \u0441\u043e\u0437\u0434\u0430\u0442\u044c?', Browser.Buttons.OK_CANCEL);\n  if (numFolders == 'cancel' || isNaN(numFolders) || numFolders <= 0) {\n    Logger.log('\u041e\u0442\u043c\u0435\u043d\u0435\u043d\u043e \u0438\u043b\u0438 \u0432\u0432\u0435\u0434\u0435\u043d\u043e \u043d\u0435\u043f\u0440\u0430\u0432\u0438\u043b\u044c\u043d\u043e\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435.');\n    return; \/\/ \u0415\u0441\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043e\u0442\u043c\u0435\u043d\u0438\u043b \u0438\u043b\u0438 \u0432\u0432\u0435\u043b \u043d\u0435\u0432\u0435\u0440\u043d\u043e\u0435 \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e, \u0437\u0430\u0432\u0435\u0440\u0448\u0430\u0435\u043c \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438\n  }\n  \n  numFolders = parseInt(numFolders); \/\/ \u041f\u0440\u0435\u043e\u0431\u0440\u0430\u0437\u0443\u0435\u043c \u0432\u0432\u043e\u0434 \u0432 \u0446\u0435\u043b\u043e\u0435 \u0447\u0438\u0441\u043b\u043e\n\n  \/\/ \u0426\u0438\u043a\u043b \u0434\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u043f\u0430\u043f\u043e\u043a, \u0437\u0430\u043f\u0440\u0430\u0448\u0438\u0432\u0430\u0435\u043c \u0438\u043c\u044f \u043a\u0430\u0436\u0434\u043e\u0439 \u043f\u0430\u043f\u043a\u0438\n  for (var i = 0; i < numFolders; i++) {\n    var folderName = Browser.inputBox('\u0412\u0432\u0435\u0434\u0438\u0442\u0435 \u0438\u043c\u044f \u043f\u0430\u043f\u043a\u0438 (' + (i + 1) + '):', Browser.Buttons.OK_CANCEL);\n    if (folderName == 'cancel') {\n      Logger.log('\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043f\u0430\u043f\u043a\u0438 \u043e\u0442\u043c\u0435\u043d\u0435\u043d\u043e.');\n      return; \/\/ \u0415\u0441\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043e\u0442\u043c\u0435\u043d\u0438\u043b, \u0437\u0430\u0432\u0435\u0440\u0448\u0430\u0435\u043c \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438\n    }\n    \n    \/\/ \u0421\u043e\u0437\u0434\u0430\u0435\u043c \u043f\u0430\u043f\u043a\u0443 \u0432 Google Drive \u0441 \u0443\u043a\u0430\u0437\u0430\u043d\u043d\u044b\u043c \u0438\u043c\u0435\u043d\u0435\u043c\n    var folder = DriveApp.createFolder(folderName);\n    Logger.log('\u0421\u043e\u0437\u0434\u0430\u043d\u0430 \u043f\u0430\u043f\u043a\u0430: ' + folderName); \/\/ \u041b\u043e\u0433\u0438\u0440\u0443\u0435\u043c \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043f\u0430\u043f\u043a\u0438\n  }\n}\n\n<\/pre><\/div>\n\n\n
                    K\u00fcsimine, kui palju kaustu luua:<\/strong><\/p>\n\n\n\n
                      \n
                    • Esmalt k\u00fcsitakse kasutajalt, mitu kausta nad soovivad luua. Kasutaja sisestab arvu ja seej\u00e4rel j\u00e4tkab skript edasi.<\/li>\n<\/ul>\n\n\n\n
                      K\u00fcsimine iga kausta nime kohta:<\/strong><\/p>\n\n\n\n
                        \n
                      • J\u00e4rgmises ts\u00fcklis k\u00fcsib skript kasutajalt iga kausta nime, kasutades Browser.inputBox()<\/code>. Kui kasutaja t\u00fchistab (kl\u00f5psab “Cancel”), siis funktsioon l\u00f5petab t\u00f6\u00f6.<\/li>\n<\/ul>\n\n\n\n
                        Kaustade loomine:<\/strong><\/p>\n\n\n\n
                          \n
                        • Iga sisestatud nime p\u00f5hjal loob skript kausta Google Drive’is, kasutades DriveApp.createFolder()<\/code> meetodit. Iga loodud kaust logitakse.<\/li>\n<\/ul>\n\n\n\n
                          \"\"<\/figure>\n\n\n\n
                          \"\"<\/figure>\n\n\n\n
                          \"\"<\/figure>\n\n\n\n
                          Tulemus:<\/strong><\/p>\n\n\n\n
                          \"\"<\/figure>\n\n\n
                          \nfunction createCSVFile() {\n  \/\/ \u0417\u0430\u043f\u0440\u0430\u0448\u0438\u0432\u0430\u0435\u043c \u0443 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043f\u0430\u043f\u043a\u0438\n  var folderName = Browser.inputBox('\u0412\u0432\u0435\u0434\u0438\u0442\u0435 \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043f\u0430\u043f\u043a\u0438:', Browser.Buttons.OK_CANCEL);\n  if (folderName == 'cancel' || folderName == '') {\n    Logger.log('\u041e\u0442\u043c\u0435\u043d\u0435\u043d\u043e \u0438\u043b\u0438 \u043f\u0443\u0441\u0442\u043e\u0435 \u0438\u043c\u044f \u043f\u0430\u043f\u043a\u0438.');\n    return; \/\/ \u0415\u0441\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043e\u0442\u043c\u0435\u043d\u0438\u043b \u0438\u043b\u0438 \u0432\u0432\u0435\u043b \u043f\u0443\u0441\u0442\u043e\u0435 \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0435, \u043f\u0440\u0435\u043a\u0440\u0430\u0449\u0430\u0435\u043c \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435\n  }\n\n  \/\/ \u0417\u0430\u043f\u0440\u0430\u0448\u0438\u0432\u0430\u0435\u043c \u0443 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0438\u043c\u044f CSV \u0444\u0430\u0439\u043b\u0430\n  var fileName = Browser.inputBox('\u0412\u0432\u0435\u0434\u0438\u0442\u0435 \u0438\u043c\u044f CSV \u0444\u0430\u0439\u043b\u0430 (\u0441 \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u0435\u043c, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, report.csv):', Browser.Buttons.OK_CANCEL);\n  if (fileName == 'cancel' || fileName == '') {\n    Logger.log('\u041e\u0442\u043c\u0435\u043d\u0435\u043d\u043e \u0438\u043b\u0438 \u043f\u0443\u0441\u0442\u043e\u0435 \u0438\u043c\u044f \u0444\u0430\u0439\u043b\u0430.');\n    return; \/\/ \u0415\u0441\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043e\u0442\u043c\u0435\u043d\u0438\u043b \u0438\u043b\u0438 \u0432\u0432\u0435\u043b \u043f\u0443\u0441\u0442\u043e\u0435 \u0438\u043c\u044f, \u043f\u0440\u0435\u043a\u0440\u0430\u0449\u0430\u0435\u043c \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435\n  }\n\n  \/\/ \u0414\u0430\u043d\u043d\u044b\u0435 \u0434\u043b\u044f CSV \u0444\u0430\u0439\u043b\u0430\n  var data = [\n    ['Kuup\u00e4ev', 'Kulud', 'Tulu'], \/\/ \u0417\u0430\u0433\u043e\u043b\u043e\u0432\u043a\u0438\n    ['2025-03-20', 500, 1500],\n    ['2025-03-21', 300, 2000],\n    ['2025-03-22', 100, 2500]\n  ];\n\n  \/\/ \u041f\u0440\u0435\u043e\u0431\u0440\u0430\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 CSV \u0444\u043e\u0440\u043c\u0430\u0442\n  var csvContent = '';\n  data.forEach(function(row) {\n    csvContent += row.join(',') + '\\n';\n  });\n\n  \/\/ \u0421\u043e\u0437\u0434\u0430\u0435\u043c \u043f\u0430\u043f\u043a\u0443 \u0432 Google Drive \u0441 \u0432\u0432\u0435\u0434\u0435\u043d\u043d\u044b\u043c \u0438\u043c\u0435\u043d\u0435\u043c\n  var folder = DriveApp.createFolder(folderName);\n  Logger.log('\u041f\u0430\u043f\u043a\u0430 \u0441\u043e\u0437\u0434\u0430\u043d\u0430: ' + folderName);\n\n  \/\/ \u0421\u043e\u0437\u0434\u0430\u0435\u043c CSV \u0444\u0430\u0439\u043b \u0432 \u0443\u043a\u0430\u0437\u0430\u043d\u043d\u043e\u0439 \u043f\u0430\u043f\u043a\u0435\n  var file = folder.createFile(fileName, csvContent);\n  Logger.log('CSV \u0444\u0430\u0439\u043b \u0441\u043e\u0437\u0434\u0430\u043d: ' + file.getName());\n}\n\n<\/pre><\/div>\n\n\n
                          \"\"<\/figure>\n\n\n\n
                          \"\"<\/figure>\n\n\n\n
                          Tulemus:<\/strong><\/p>\n\n\n\n
                          \"\"<\/figure>\n\n\n\n
                          \"\"<\/figure>\n\n\n\n
                          \"\"<\/figure>\n\n\n\n
                          <\/p>\n\n\n\n
                          K\u00fcsimine kausta nime jaoks<\/strong>:<\/p>\n\n\n\n
                            \n
                          • Kasutaja sisestab kausta nime<\/strong>, kuhu CSV fail salvestatakse. Kui kasutaja t\u00fchistab v\u00f5i j\u00e4tab nime t\u00fchjaks, siis funktsioon l\u00f5petatakse.<\/li>\n<\/ul>\n\n\n\n
                            K\u00fcsimine faili nime jaoks<\/strong>:<\/p>\n\n\n\n
                              \n
                            • Kasutaja sisestab CSV faili nime (sh laiendiga, n\u00e4iteks report.csv<\/code>)<\/strong>. Kui kasutaja t\u00fchistab v\u00f5i ei sisesta nime, siis funktsioon l\u00f5petatakse.<\/li>\n<\/ul>\n\n\n\n
                              Andmete m\u00e4\u00e4ramine CSV jaoks<\/strong>:<\/p>\n\n\n\n
                                \n
                              • Skript m\u00e4\u00e4rab CSV faili sisu<\/strong>, kus on tabel kuup\u00e4evade, kulude ja tuludega. N\u00e4iteks:\n
                                  \n
                                • 2025-03-20, 500, 1500<\/li>\n\n\n\n
                                • 2025-03-21, 300, 2000<\/li>\n\n\n\n
                                • 2025-03-22, 100, 2500<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
                                  Andmete teisendamine CSV formaati<\/strong>:<\/p>\n\n\n\n
                                    \n
                                  • Andmed muudetakse CSV formaati<\/strong>, kus iga rida on eraldatud komadega ja iga rida l\u00f5peb reavahetusega.<\/li>\n<\/ul>\n\n\n\n
                                    Kausta loomine Google Drive’is<\/strong>:<\/p>\n\n\n\n
                                      \n
                                    • Kaust luuakse<\/strong> Google Drive\u2019is kasutaja m\u00e4\u00e4ratud nimega (n\u00e4iteks Aruanded<\/code>).<\/li>\n<\/ul>\n\n\n\n
                                      CSV faili loomine kausta sees<\/strong>:<\/p>\n\n\n\n
                                        \n
                                      • CSV fail luuakse<\/strong> m\u00e4\u00e4ratud kausta sees, mille nimi ja sisu p\u00f5hinevad kasutaja sisendil.<\/li>\n<\/ul>\n\n\n\n
                                        Logimine<\/strong>:<\/p>\n\n\n\n
                                          \n
                                        • Skript kasutab Logger.log()<\/code> meetodit, et logida kausta ja faili loomise kohta informatsiooni, et arendaja saaks kontrollida, et k\u00f5ik toimis \u00f5igesti.<\/li>\n<\/ul>\n\n\n\n
                                          <\/p>\n","protected":false},"excerpt":{"rendered":"
                                          Teostamise sammud: Scripti redaktori avamine: Minge Google Apps Script ja looge uus projekt v\u00f5i avage see otse Google Drive’is men\u00fc\u00fcst “Laiendused” -> “Apps Script”. Scripti kirjutamine Kleepige j\u00e4rgmine kood redaktorisse: Mida teeb see kood? Scripti k\u00e4ivitamine: Skripti k\u00e4ivitamiseks vajutage redaktoris nuppu “K\u00e4ivita”. P\u00e4rast seda t\u00e4idab skript kausta ja faili loomise teie Google Drive’is. Tulemuse vaatamine: T\u00e4iendavad v\u00f5imalused: Mitme kausta loomine Kui on vaja luua kaustu erinevate eesm\u00e4rkide v\u00f5i erinevate kasutajate jaoks, saab funktsionaalsust laiendada, lisades mitme kausta loomise unikaalsete nimedega. Andmete salvestamine CSV-faili Samuti saab luua CSV-faili (comma-separated values file) ja salvestada andmeid sellesse. See v\u00f5ib olla kasulik aruandluse v\u00f5i andmete logimise jaoks. CSV (Comma-Separated Values) fail on tekstifail, kus andmed on eraldatud komadega. Iga rida failis esindab \u00fcht andmeread (n\u00e4iteks tabeli \u00fche rida) ja iga v\u00e4\u00e4rtus on eraldatud komaga. CSV formaati kasutatakse sageli andmete salvestamiseks ja vahetamiseks, kuna seda saab lugeda ja t\u00f6\u00f6delda paljude erinevate programmidega, nagu n\u00e4iteks Microsoft Excel v\u00f5i Google Sheets. Eesti keeles v\u00f5iks \u00f6elda, et CSV fail on “komaga eraldatud v\u00e4\u00e4rtuste fail”, mis on lihtne viis andmete salvestamiseks tekstina. K\u00e4ivitamise ajastamine (automaatse loomise jaoks) Kui soovite, et kaustad v\u00f5i failid loodi automaatselt vastavalt ajakavale, seadistage k\u00e4ivitamise ajastamine: Tulemus: Selle skripti abil saate automaatselt luua kaustu ja faile Google Drive’is, mis on kasulik erinevates automaatsetes protsessides, nagu aruandlus, failide korraldamine v\u00f5i andmet\u00f6\u00f6tlus. See n\u00e4ide n\u00e4itab, kuidas Google Apps Scriptiga saab integreerida Google Drive’i teiste teenustega ja automatiseerida igap\u00e4evaseid \u00fclesandeid! Minu t\u00e4iustused skriptidele: Kood teeb j\u00e4rgmist: Tulemus: K\u00fcsimine, kui palju kaustu luua: K\u00fcsimine iga kausta nime kohta: Kaustade loomine: Tulemus: Tulemus: K\u00fcsimine kausta nime jaoks: K\u00fcsimine faili nime jaoks: Andmete m\u00e4\u00e4ramine CSV jaoks: Andmete teisendamine CSV formaati: Kausta loomine Google Drive’is: CSV faili loomine kausta sees: Logimine:<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-505","page","type-page","status-publish","hentry"],"yoast_head":"\nLoov\u00fclesanne: Skript loob uusi kaustu ja tekstifaile Google Drive'is. - Alex's Arsenal (Shop)<\/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:\/\/aleksanderbekasov24.thkit.ee\/wp\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Loov\u00fclesanne: Skript loob uusi kaustu ja tekstifaile Google Drive'is. - Alex's Arsenal (Shop)\" \/>\n<meta property=\"og:description\" content=\"Teostamise sammud: Scripti redaktori avamine: Minge Google Apps Script ja looge uus projekt v\u00f5i avage see otse Google Drive’is men\u00fc\u00fcst “Laiendused” -> “Apps Script”. Scripti kirjutamine Kleepige j\u00e4rgmine kood redaktorisse: Mida teeb see kood? Scripti k\u00e4ivitamine: Skripti k\u00e4ivitamiseks vajutage redaktoris nuppu “K\u00e4ivita”. P\u00e4rast seda t\u00e4idab skript kausta ja faili loomise teie Google Drive’is. Tulemuse vaatamine: T\u00e4iendavad v\u00f5imalused: Mitme kausta loomine Kui on vaja luua kaustu erinevate eesm\u00e4rkide v\u00f5i erinevate kasutajate jaoks, saab funktsionaalsust laiendada, lisades mitme kausta loomise unikaalsete nimedega. Andmete salvestamine CSV-faili Samuti saab luua CSV-faili (comma-separated values file) ja salvestada andmeid sellesse. See v\u00f5ib olla kasulik aruandluse v\u00f5i andmete logimise jaoks. CSV (Comma-Separated Values) fail on tekstifail, kus andmed on eraldatud komadega. Iga rida failis esindab \u00fcht andmeread (n\u00e4iteks tabeli \u00fche rida) ja iga v\u00e4\u00e4rtus on eraldatud komaga. CSV formaati kasutatakse sageli andmete salvestamiseks ja vahetamiseks, kuna seda saab lugeda ja t\u00f6\u00f6delda paljude erinevate programmidega, nagu n\u00e4iteks Microsoft Excel v\u00f5i Google Sheets. Eesti keeles v\u00f5iks \u00f6elda, et CSV fail on “komaga eraldatud v\u00e4\u00e4rtuste fail”, mis on lihtne viis andmete salvestamiseks tekstina. K\u00e4ivitamise ajastamine (automaatse loomise jaoks) Kui soovite, et kaustad v\u00f5i failid loodi automaatselt vastavalt ajakavale, seadistage k\u00e4ivitamise ajastamine: Tulemus: Selle skripti abil saate automaatselt luua kaustu ja faile Google Drive’is, mis on kasulik erinevates automaatsetes protsessides, nagu aruandlus, failide korraldamine v\u00f5i andmet\u00f6\u00f6tlus. See n\u00e4ide n\u00e4itab, kuidas Google Apps Scriptiga saab integreerida Google Drive’i teiste teenustega ja automatiseerida igap\u00e4evaseid \u00fclesandeid! Minu t\u00e4iustused skriptidele: Kood teeb j\u00e4rgmist: Tulemus: K\u00fcsimine, kui palju kaustu luua: K\u00fcsimine iga kausta nime kohta: Kaustade loomine: Tulemus: Tulemus: K\u00fcsimine kausta nime jaoks: K\u00fcsimine faili nime jaoks: Andmete m\u00e4\u00e4ramine CSV jaoks: Andmete teisendamine CSV formaati: Kausta loomine Google Drive’is: CSV faili loomine kausta sees: Logimine:\" \/>\n<meta property=\"og:url\" content=\"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\/\" \/>\n<meta property=\"og:site_name\" content=\"Alex's Arsenal (Shop)\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-09T11:54:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/file-created-1.1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1452\" \/>\n\t<meta property=\"og:image:height\" content=\"797\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\\\/\",\"url\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\\\/\",\"name\":\"Loov\u00fclesanne: Skript loob uusi kaustu ja tekstifaile Google Drive'is. - Alex's Arsenal (Shop)\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/file-created-1.1-1024x562.png\",\"datePublished\":\"2025-04-09T09:34:51+00:00\",\"dateModified\":\"2025-04-09T11:54:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\\\/#primaryimage\",\"url\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/file-created-1.1.png\",\"contentUrl\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/file-created-1.1.png\",\"width\":1452,\"height\":797},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Loov\u00fclesanne: Skript loob uusi kaustu ja tekstifaile Google Drive’is.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/\",\"name\":\"Alex's Arsenal (Shop) \u00a9 2025 All rights reserved.\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/#\\\/schema\\\/person\\\/3b5a2663a9eba24938a504553bfddac8\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/#\\\/schema\\\/person\\\/3b5a2663a9eba24938a504553bfddac8\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/89ec08a71657132fe138df1f49857196ebc20c1d30c12bddb082e6bc8abb224d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/89ec08a71657132fe138df1f49857196ebc20c1d30c12bddb082e6bc8abb224d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/89ec08a71657132fe138df1f49857196ebc20c1d30c12bddb082e6bc8abb224d?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/89ec08a71657132fe138df1f49857196ebc20c1d30c12bddb082e6bc8abb224d?s=96&d=mm&r=g\"},\"sameAs\":[\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Loov\u00fclesanne: Skript loob uusi kaustu ja tekstifaile Google Drive'is. - Alex's Arsenal (Shop)","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:\/\/aleksanderbekasov24.thkit.ee\/wp\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\/","og_locale":"en_US","og_type":"article","og_title":"Loov\u00fclesanne: Skript loob uusi kaustu ja tekstifaile Google Drive'is. - Alex's Arsenal (Shop)","og_description":"Teostamise sammud: Scripti redaktori avamine: Minge Google Apps Script ja looge uus projekt v\u00f5i avage see otse Google Drive’is men\u00fc\u00fcst “Laiendused” -> “Apps Script”. Scripti kirjutamine Kleepige j\u00e4rgmine kood redaktorisse: Mida teeb see kood? Scripti k\u00e4ivitamine: Skripti k\u00e4ivitamiseks vajutage redaktoris nuppu “K\u00e4ivita”. P\u00e4rast seda t\u00e4idab skript kausta ja faili loomise teie Google Drive’is. Tulemuse vaatamine: T\u00e4iendavad v\u00f5imalused: Mitme kausta loomine Kui on vaja luua kaustu erinevate eesm\u00e4rkide v\u00f5i erinevate kasutajate jaoks, saab funktsionaalsust laiendada, lisades mitme kausta loomise unikaalsete nimedega. Andmete salvestamine CSV-faili Samuti saab luua CSV-faili (comma-separated values file) ja salvestada andmeid sellesse. See v\u00f5ib olla kasulik aruandluse v\u00f5i andmete logimise jaoks. CSV (Comma-Separated Values) fail on tekstifail, kus andmed on eraldatud komadega. Iga rida failis esindab \u00fcht andmeread (n\u00e4iteks tabeli \u00fche rida) ja iga v\u00e4\u00e4rtus on eraldatud komaga. CSV formaati kasutatakse sageli andmete salvestamiseks ja vahetamiseks, kuna seda saab lugeda ja t\u00f6\u00f6delda paljude erinevate programmidega, nagu n\u00e4iteks Microsoft Excel v\u00f5i Google Sheets. Eesti keeles v\u00f5iks \u00f6elda, et CSV fail on “komaga eraldatud v\u00e4\u00e4rtuste fail”, mis on lihtne viis andmete salvestamiseks tekstina. K\u00e4ivitamise ajastamine (automaatse loomise jaoks) Kui soovite, et kaustad v\u00f5i failid loodi automaatselt vastavalt ajakavale, seadistage k\u00e4ivitamise ajastamine: Tulemus: Selle skripti abil saate automaatselt luua kaustu ja faile Google Drive’is, mis on kasulik erinevates automaatsetes protsessides, nagu aruandlus, failide korraldamine v\u00f5i andmet\u00f6\u00f6tlus. See n\u00e4ide n\u00e4itab, kuidas Google Apps Scriptiga saab integreerida Google Drive’i teiste teenustega ja automatiseerida igap\u00e4evaseid \u00fclesandeid! Minu t\u00e4iustused skriptidele: Kood teeb j\u00e4rgmist: Tulemus: K\u00fcsimine, kui palju kaustu luua: K\u00fcsimine iga kausta nime kohta: Kaustade loomine: Tulemus: Tulemus: K\u00fcsimine kausta nime jaoks: K\u00fcsimine faili nime jaoks: Andmete m\u00e4\u00e4ramine CSV jaoks: Andmete teisendamine CSV formaati: Kausta loomine Google Drive’is: CSV faili loomine kausta sees: Logimine:","og_url":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\/","og_site_name":"Alex's Arsenal (Shop)","article_modified_time":"2025-04-09T11:54:06+00:00","og_image":[{"width":1452,"height":797,"url":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/file-created-1.1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\/","url":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\/","name":"Loov\u00fclesanne: Skript loob uusi kaustu ja tekstifaile Google Drive'is. - Alex's Arsenal (Shop)","isPartOf":{"@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\/#primaryimage"},"image":{"@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\/#primaryimage"},"thumbnailUrl":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/file-created-1.1-1024x562.png","datePublished":"2025-04-09T09:34:51+00:00","dateModified":"2025-04-09T11:54:06+00:00","breadcrumb":{"@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/aleksanderbekasov24.thkit.ee\/wp\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\/#primaryimage","url":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/file-created-1.1.png","contentUrl":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/file-created-1.1.png","width":1452,"height":797},{"@type":"BreadcrumbList","@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/loovulesanne-skript-loob-uusi-kaustu-ja-tekstifaile-google-driveis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"Loov\u00fclesanne: Skript loob uusi kaustu ja tekstifaile Google Drive’is."}]},{"@type":"WebSite","@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/#website","url":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/","name":"Alex's Arsenal (Shop) \u00a9 2025 All rights reserved.","description":"","publisher":{"@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/#\/schema\/person\/3b5a2663a9eba24938a504553bfddac8"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/#\/schema\/person\/3b5a2663a9eba24938a504553bfddac8","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/89ec08a71657132fe138df1f49857196ebc20c1d30c12bddb082e6bc8abb224d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/89ec08a71657132fe138df1f49857196ebc20c1d30c12bddb082e6bc8abb224d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/89ec08a71657132fe138df1f49857196ebc20c1d30c12bddb082e6bc8abb224d?s=96&d=mm&r=g","caption":"admin"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/89ec08a71657132fe138df1f49857196ebc20c1d30c12bddb082e6bc8abb224d?s=96&d=mm&r=g"},"sameAs":["https:\/\/aleksanderbekasov24.thkit.ee\/wp"]}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/505","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-json\/wp\/v2\/comments?post=505"}],"version-history":[{"count":36,"href":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/505\/revisions"}],"predecessor-version":[{"id":583,"href":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/505\/revisions\/583"}],"wp:attachment":[{"href":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-json\/wp\/v2\/media?parent=505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}