{"id":3337,"date":"2021-01-20T14:32:55","date_gmt":"2021-01-20T05:32:55","guid":{"rendered":"http:\/\/autooffice.co.kr\/?p=3337"},"modified":"2025-09-15T18:11:15","modified_gmt":"2025-09-15T09:11:15","slug":"google-apps-script-bulk-pdf","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2021\/01\/20\/google-apps-script-bulk-pdf\/","title":{"rendered":"Google Apps Script: \uae09\uc5ec\/\uac70\ub798\uba85\uc138\uc11c \uad6c\uae00 \ubb38\uc11c \ud15c\ud50c\ub9bf\uc5d0 \ub9de\ucdb0 PDF \ud30c\uc77c \ub9cc\ub4dc\ub294 \ubc29\ubc95"},"content":{"rendered":"\n

<\/path><\/svg><\/span>\uc124\uba85<\/span><\/h4>\n\n\n\n

\uad6c\uae00\uc2dc\ud2b8\ub85c \ub370\uc774\ud130\ub97c \uad00\ub9ac\ud558\ub2e4\ubcf4\uba74, \uac70\ub798\uba85\uc138\uc11c\ub098 \uae09\uc5ec\uba85\uc138\uc11c\ucc98\ub7fc \uc785\ub825\ud558\ub294 \uc5c5\uccb4\ub098 \uc774\ub984\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ub97c \uac00\uacf5\ud574\uc11c \ucd9c\ub825\ud574\uc57c\ud560 \ub54c\uac00 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n

\uc5c5\uccb4\/\uc774\ub984\/\ud574\ub2f9\uc6d4\uc744 \uc785\ub825\ud558\uace0 \ucc38\uc870\ud574\uc11c \ub370\uc774\ud130\ub97c \uad6c\uae00 \uc2dc\ud2b8\uc5d0\uc11c \ubcf4\uc5ec\uc8fc\ub294 \uac83\uc740 FILTER<\/a>, QUERY<\/a> \ub4f1\uc744 \uc0ac\uc6a9\ud574\uc11c \uc27d\uac8c \uac00\ub2a5\ud558\uc9c0\ub9cc, \ucd9c\ub825\uc744 \ud558\ub824\uba74 \ud558\ub098\ud558\ub098 \uc785\ub825\uac12\uc744 \ubc14\uafd4\uc8fc\ub294\ub370 \uc218\uace0\uac00 \ub9ce\uc774 \ub4ed\ub2c8\ub2e4. <\/p>\n\n\n\n

\uc774\ubc88 \ud3ec\uc2a4\ud305\uc5d0\uc11c\ub294 \uad6c\uae00 \ubb38\uc11c\uc5d0 \ud15c\ud50c\ub9bf\uc744 \ub9cc\ub4e4\uc5b4 \ub193\uace0, \ub370\uc774\ud130\ub97c \ubc18\ubcf5\uc801\uc73c\ub85c \ubc14\uafb8\uba74\uc11c PDF\ub85c \uc800\uc7a5\ud558\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4. <\/strong><\/p>\n\n\n\n

\n\n\n\n

\uae30\ubcf8\uc801\uc778 \ud504\ub85c\uc138\uc2a4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n

    \n
  1. \uad6c\uae00 \ubb38\uc11c\uc5d0 \ud15c\ud50c\ub9bf\uc744 \uc791\uc131\ud558\uace0 \ub370\uc774\ud130\ub97c \ub123\uc744 \uacf3\uc5d0 \uce58\ud658\ubb38\uc790\ub97c \uc785\ub825 (<<\uc131\uba85>>, {\uc131\uba85} \uacfc \uac19\uc740 \ubb38\uc790)<\/strong><\/li>\n\n\n\n
  2. \uad6c\uae00 \uc2dc\ud2b8\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud615\ud0dc\ub85c \uc790\ub8cc\ub97c \uc900\ube44 (\uccab \ud589\uc740 \ub77c\ubca8\uc774\uace0 \uc5f4 \ub2e8\uc704\ub85c \ub3d9\uc77c\ud55c \ub370\uc774\ud130\ub97c \uc900\ube44)<\/strong><\/li>\n\n\n\n
  3. \uad6c\uae00 \ub4dc\ub77c\uc774\ube0c\uc5d0 \uc791\uc5c5 \ud3f4\ub354\ub97c \uc0dd\uc131<\/strong><\/li>\n\n\n\n
  4. \uad6c\uae00 \uc2dc\ud2b8\uc5d0\uc11c \uc2a4\ud06c\ub9bd\ud2b8 \uc2e4\ud589<\/strong>\n
      \n
    1. \ud15c\ud50c\ub9bf\uc5d0\uc11c \uce58\ud658\ubb38\uc790\uac00 \uc785\ub825\ub41c \ubd80\ubd84\uc744 \uc2e4\uc81c \ub370\uc774\ud130\ub85c \ubc14\uafd4\uc8fc\uace0, PDF\ub85c \uc800\uc7a5\ud558\ub294 \uc791\uc5c5\uc744 \ubc18\ubcf5<\/strong><\/li>\n\n\n\n
    2. \uad6c\uae00 \ub4dc\ub77c\uc774\ube0c\uc5d0 \uc800\uc7a5\ub41c PDF\ub97c ZIP\uc73c\ub85c \uc555\ucd95\ud574\uc11c \ub2e4\uc6b4\ub85c\ub4dc \ub9c1\ud06c\ub97c \ud45c\uc2dc <\/strong><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n\n\n\n
      \n\n\n\n

      \uc774\ubc88 \ud3ec\uc2a4\ud305\uc5d0\uc11c\ub294 1,2, 3-1 \ud504\ub85c\uc138\uc2a4\ub97c \ub2e4\ub8f9\ub2c8\ub2e4. <\/p>\n\n\n\n

      1. \uad6c\uae00 \ubb38\uc11c \ud15c\ud50c\ub9bf \uc900\ube44<\/h5>\n\n\n\n

      \uc0d8\ud50c\uacfc \uac19\uc774 \ud15c\ud50c\ub9bf\uc744 \uc900\ube44\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n\n\uae09\uc5ec\uba85\uc138\uc11c \uc0d8\ud50c<\/a>\n\n\n\n\n

      <\/div>\n\n\n
      \n
      \"\uae09\uc5ec\uba85\uc138\uc11c\"<\/figure>\n<\/div>\n\n\n

      \ub370\uc774\ud130\uac00 \ub4e4\uc5b4\uac00\uc57c \ud558\ub294 \ubd80\ubd84\uc5d0\ub294 \uce58\ud658\ubb38\uc790\ub97c \ub123\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n

      \uc5b4\ub5a4 \ud615\ud0dc\uc774\ub4e0 \uad1c\ucc2e\uc9c0\ub9cc, { }\uc640 \uac19\uc740 \uae30\ud638\ub97c \uc0ac\uc6a9\ud558\uc5ec\uc11c \ucc3e\uc544 \ubc14\uafb8\uae30\ub97c \ud560 \ub54c\uc5d0 \uc6d0\ud558\uc9c0 \uc54a\ub294 \ubb38\uc790\uac00 \ubc14\ub00c\uc9c0 \uc54a\ub3c4\ub85d \ud574\uc57c \ud569\ub2c8\ub2e4. <\/p>\n\n\n\n

      \n\n\n\n
      2. \uad6c\uae00 \uc2dc\ud2b8 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc900\ube44<\/h5>\n\n\n\n\n\uad6c\uae00\uc2dc\ud2b8 \uc0d8\ud50c<\/a>\n\n\n\n\n
      <\/div>\n\n\n
      \n
      \"\uad6c\uae00\uc2dc\ud2b8<\/figure>\n<\/div>\n\n\n

      \uc704\uc758 \uc774\ubbf8\uc9c0\uc640 \uc720\uc0ac\ud558\uac8c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc791\uc131\ud569\ub2c8\ub2e4. QUERY <\/a>\ub97c \uc0ac\uc6a9\ud55c\ub2e4\uba74, \uc120\ud0dd\ud55c \uc6d4\uc5d0 \ub530\ub77c\uc11c \ub370\uc774\ud130\ub97c \ubc14\uafc0 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n

      \n\n\n\n
      3. \uad6c\uae00 \ub4dc\ub77c\uc774\ube0c\uc5d0 \uc791\uc5c5 \ud3f4\ub354 \uc0dd\uc131<\/h5>\n\n\n\n

      \uc791\uc5c5\uc744 \uc9c4\ud589\ud560 \uc784\uc2dc \ud3f4\ub354\uc640 PDF\uac00 \uc800\uc7a5\ub420 \ud3f4\ub354\ub97c \ub9cc\ub4e4\uc5b4\ub461\ub2c8\ub2e4. <\/p>\n\n\n

      \n
      \"\ud3f4\ub354<\/figure>\n<\/div>\n\n\n

      \uac01 \ud3f4\ub354\uc5d0 \ub4e4\uc5b4\uac00\uc11c URL\uc744 \ubcf4\uba74 \ud3f4\ub354\uc758 \uace0\uc720 ID \uac12\uc744 \ucc3e\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c \uacfc\uc815\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc608\uc815\uc785\ub2c8\ub2e4. <\/p>\n\n\n

      \n
      \"\"<\/figure>\n<\/div>\n\n\n
      \n\n\n\n
      4. \uad6c\uae00 \uc2dc\ud2b8 \uc2a4\ud06c\ub9bd\ud2b8 \uc791\uc131<\/h5>\n\n\n\n

      \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ub4e4\uc5b4\uc788\ub294 \uad6c\uae00 \uc2dc\ud2b8\uc5d0\uc11c \uc2a4\ud06c\ub9bd\ud2b8 \ud3b8\uc9d1\uae30\ub97c \uc2e4\ud589\ud574\uc11c \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc791\uc131\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n

      \uc2a4\ud06c\ub9bd\ud2b8\ub294 \ucd1d 2\uac1c\uc758 \ud568\uc218\ub85c \uc791\uc131\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n

        \n
      1. PDF\ub97c \ub9cc\ub4dc\ub294 \ud568\uc218<\/li>\n\n\n\n
      2. PDF\ub97c \ub9cc\ub4dc\ub294 \uacfc\uc815\uc744 \ubc18\ubcf5\ud558\ub294 \ud568\uc218 <\/li>\n<\/ol>\n\n\n\n
        \n\n\n\n
        4-1. PDF\ub97c \ub9cc\ub4dc\ub294 \ud568\uc218<\/h5>\n\n\n\n
        function createPDF(date,name,joindate,prime,lunch,car,nightwork,longterm,etc,overtime,weekend,nightpay,incena,incenb,incenc,incend,salarysum,pension,health,work,longhealth,incometax, citytax,deductsum,total, pdfName, docFile, tempFolder, pdfFolder) {\n  const tempFile = docFile.makeCopy(tempFolder); \/\/ \ud15c\ud50c\ub9bf\uc744 \ubcf5\uc0ac\n  const tempDocFile = DocumentApp.openById(tempFile.getId()); \/\/\ubcf5\uc0ac\ud55c \ud30c\uc77c\uc744 \uc815\uc758\n  const body = tempDocFile.getBody(); \/\/\ubcf5\uc0ac\ud55c \ud30c\uc77c\uc758 \ub0b4\uc6a9\uc744 body\ub85c \uc815\uc758\n  \/\/ \ucc3e\uc544 \ubc14\uafb8\uae30 \uc9c4\ud589\ud558\uace0 \uc800\uc7a5\n  body.replaceText(\"<<\uadc0\uc18d\uc6d4>>\", date); \/\/row[0]\n  body.replaceText(\"<<\uc131\uba85>>\", name); \/\/row[1]\n  body.replaceText(\"<<\uc785\uc0ac\uc77c>>\", joindate); \/\/row[2]\n  body.replaceText(\"<<\uae30\ubcf8\uae09>>\", prime); \/\/row[3]\n  body.replaceText(\"<<\uc2dd\ub300>>\", lunch); \/\/row[4]\n  body.replaceText(\"<<\ucc28\ub7c9\uc720\uc9c0\ube44>>\", car); \/\/row[5]\n  body.replaceText(\"<<\uc57c\uac04\uadfc\ub85c\uc218\ub2f9>>\", nightwork); \/\/row[6]\n  body.replaceText(\"<<\uc7a5\uae30\uadfc\uc18d\uc218\ub2f9>>\", longterm); \/\/[row[7]\n  body.replaceText(\"<<\uae30\ud0c0\uc218\ub2f9>>\", etc); \/\/row[8]\n  body.replaceText(\"<<\uc5f0\uc7a5\uadfc\ub85c\uc218\ub2f9>>\", overtime); \/\/row[9]\n  body.replaceText(\"<<\ud734\uc77c\uadfc\ub85c\uc218\ub2f9>>\", weekend);\/\/row[10]\n  body.replaceText(\"<<\uc57c\uac04\uc218\ub2f9>>\", nightpay); \/\/row[11]\n  body.replaceText(\"<<A\uc218\ub2f9>>\", incena); \/\/row[12]\n  body.replaceText(\"<<B\uc218\ub2f9>>\", incenb); \/\/row[13]\n  body.replaceText(\"<<C\uc218\ub2f9>>\", incenc); \/\/row[14]\n  body.replaceText(\"<<D\uc218\ub2f9>>\", incend); \/\/row[15]\n  body.replaceText(\"<<\uc9c0\uae09\uc561\uacc4>>\", salarysum); \/\/row[16]\n  body.replaceText(\"<<\uad6d\ubbfc\uc5f0\uae08>>\", pension); \/\/row[17]\n  body.replaceText(\"<<\uac74\uac15\ubcf4\ud5d8>>\", health); \/\/row[18]\n  body.replaceText(\"<<\uace0\uc6a9\ubcf4\ud5d8>>\", work); \/\/ row[19]\n  body.replaceText(\"<<\uc7a5\uae30\uc694\uc591>>\", longhealth); \/\/ row[20]\n  body.replaceText(\"<<\uc18c\ub4dd\uc138>>\", incometax); \/\/row[21]\n  body.replaceText(\"<<\uc9c0\ubc29\uc18c\ub4dd\uc138>>\", citytax); \/\/row[22]\n  body.replaceText(\"<<\uacf5\uc81c\uc561\uacc4>>\", deductsum); \/\/row[23]\n  body.replaceText(\"<<\ucc28\uc778\uc9c0\uae09\uc561>>\", total); \/\/row[24]\n  tempDocFile.saveAndClose();\n  \/\/PDF \uc0dd\uc131 \ubd80\ubd84\n  const pdfContentBlob = tempFile.getAs(MimeType.PDF); \/\/tempfile\uc744 PDF\ub85c \uac00\uc838\uc640\uc11c \ubcc0\uc218\ub85c \uc815\uc758\n  pdfFolder.createFile(pdfContentBlob).setName(pdfName); \/\/PDF \ub97c \uc774\ub984 \uc9c0\uc815\ud574\uc11c pdfFolder\uc5d0 \uc800\uc7a5\n  tempFolder.removeFile(tempFile); \/\/ \uc784\uc2dc \ud30c\uc77c\uc740 \uc0ad\uc81c\n};<\/pre><\/div>\n\n\n\n
        \ucd5c\uc885\uc801\uc73c\ub85c\ub294 \ud55c\ubc88\uc5d0 \ubaa8\ub4e0 PDF\ub97c \ub9cc\ub4dc\ub294 \ud568\uc218\ub97c \uc2e4\ud589\ud558\uae30 \ub54c\ubb38\uc5d0, \ub2e8\uc77c PDF \ub97c \ub9cc\ub4dc\ub294 \uc2a4\ud06c\ub9bd\ud2b8\uc5d0 \ub4e4\uc5b4\uac00\ub294 \ubcc0\uc218\ub294 \ubaa8\ub4e0 PDF\ub97c \ub9cc\ub4dc\ub294 \ud568\uc218\uc5d0\uc11c \uac00\uc838\uc624\uac8c \uc815\uc758\ud569\ub2c8\ub2e4. 4-2 \ud568\uc218\uc5d0\ubcf4\uba74 const \ub85c \ubcc0\uc218\uac00 \uc815\uc758\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n
        function createPDF(date,name,joindate,prime,lunch,car,nightwork,longterm,etc,overtime,weekend,nightpay,incena,incenb,incenc,incend,salarysum,pension,health,work,longhealth,incometax, citytax,deductsum,total, pdfName, docFile, tempFolder, pdfFolder)\n <\/pre><\/div>\n\n\n\n
        \ud15c\ud50c\ub9bf\uc744 \ubcf5\uc0ac\ud574\uc11c tempFile\uc744 \ub9cc\ub4e4\uace0, \ud574\ub2f9 \ud30c\uc77c\uc5d0 \uce58\ud658\ubd80\ubd84\uc73c\ub85c \uc815\uc758\ub41c \uacf3\uc744 \ucc3e\uc544\uc11c \ub370\uc774\ud130\ub85c \ubcc0\uacbd\ud574\uc90d\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc800\uc7a5\ud558\uace0 \ubb38\uc11c\ub97c \ub2eb\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n
        const tempFile = docFile.makeCopy(tempFolder); \/\/ \ud15c\ud50c\ub9bf\uc744 \ubcf5\uc0ac\nconst tempDocFile = DocumentApp.openById(tempFile.getId()); \/\/\ubcf5\uc0ac\ud55c \ud30c\uc77c\uc744 \uc815\uc758\nconst body = tempDocFile.getBody(); \/\/\ubcf5\uc0ac\ud55c \ud30c\uc77c\uc758 \ub0b4\uc6a9\uc744 body\ub85c \uc815\uc758\n\/\/ \ucc3e\uc544 \ubc14\uafb8\uae30 \uc9c4\ud589\ud558\uace0 \uc800\uc7a5\nbody.replaceText(\"<<\uadc0\uc18d\uc6d4>>\", date); \/\/row[0]\ntempDocFile.saveAndClose();<\/pre><\/div>\n\n\n\n
        \ubb38\uc11c\ub97c PDF\ub85c \ubcc0\ud658\ud574\uc90d\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc784\uc2dc\ub85c \ub9cc\ub4e4\uc5c8\ub358 tempFile \uc740 \uc0ad\uc81c\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n
         const pdfContentBlob = tempFile.getAs(MimeType.PDF); \/\/tempfile\uc744 PDF\ub85c \uac00\uc838\uc640\uc11c \ubcc0\uc218\ub85c \uc815\uc758\n pdfFolder.createFile(pdfContentBlob).setName(pdfName); \/\/PDF \ub97c \uc774\ub984 \uc9c0\uc815\ud574\uc11c pdfFolder\uc5d0 \uc800\uc7a5\n tempFolder.removeFile(tempFile); \/\/ \uc784\uc2dc \ud30c\uc77c\uc740 \uc0ad\uc81c<\/pre><\/div>\n\n\n\n
        \uc5ec\uae30\uae4c\uc9c0\uac00 \ub2e8\uc77c PDF \uc0dd\uc131 \uc0ac\uc774\ud074\uc785\ub2c8\ub2e4. \uc774\uc5b4\uc9c0\ub294 \ubc8c\ud06c \ud568\uc218\uc5d0\uc11c \uc774 \uacfc\uc815\uc744 \ub370\uc774\ud130\uc5d0 \ub9de\uac8c \ubc18\ubcf5\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n
        \n\n\n\n
        4-2. PDF\ub97c \ub9cc\ub4dc\ub294 \uacfc\uc815\uc744 \ubc18\ubcf5\ud558\ub294 \ud568\uc218<\/h5>\n\n\n\n
        function createBulkPDFs() {\n  const docFile = DriveApp.getFileById(\"1f3DpK4j3hNqZwRSWFisPrQ4FuKvHgUBZjAWFWrYmEfQ\"); \/\/\uad6c\uae00 \ubb38\uc11c \ud15c\ud50c\ub9bf ID\n  const tempFolder = DriveApp.getFolderById(\"1Hy2bDVyX8o4WbuI8gOejf2jhnHDXBEY7\"); \/\/ \uad6c\uae00 \ubb38\uc11c\uc5d0 \ub370\uc774\ud130\ub97c \ubc14\uafd4 \ub123\uc740 \ub4a4\uc5d0 PDF\ub85c \ubcc0\ud658\ud558\uae30 \uc704\ud574 \uc800\uc7a5\ud558\ub294 \ud3f4\ub354\n  const pdfFolder = DriveApp.getFolderById(\"1LEoaZiwiBiioJJ3pjd_u2mxFtCwVkmHE\"); \/\/ PDF \uac00 \uc800\uc7a5\ub418\ub294 \ud3f4\ub354 \uc8fc\uc18c ID\n  const thisSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(\"\uae09\uc5ec\uba85\uc138\uc11c\"); \/\/ \ud604\uc7ac \ud30c\uc77c\uc5d0\uc11c \uc0ac\uc6a9\ud560 \ub370\uc774\ud130\uac00 \ub4e4\uc5b4 \uc788\ub294 \uc2dc\ud2b8\uc774\ub984\n  \n  const data = thisSheet.getRange(3, 1, thisSheet.getLastRow() - 2, 25).getDisplayValues(); \/\/\uc2dc\ud2b8\uc5d0\uc11c \ub370\uc774\ud130\uc758 \ubc94\uc704. \ud589\uc740 \ub3d9\uc801\uc73c\ub85c \uc124\uc815\ud568\n  \/\/\ud589\ub9c8\ub2e4 PDF \ub9cc\ub4dc\ub294 \ud568\uc218\ub97c \ubc18\ubcf5 \uc2e4\ud589\n  let errors =[];\n  data.forEach(row => {\n    try{\n    createPDF(row[0],row[1],row[2],row[3],row[4],row[5],row[6],row[7],row[8],row[9],row[10],row[11],row[12],row[13],row[14],row[15],row[16],row[17],row[18],row[19],row[20],row[21],row[22],row[23],row[24], row[0]+\"_\"+row[1], docFile, tempFolder, pdfFolder); \/\/\uc0dd\uc131\ub418\ub294 pdf \uc774\ub984\uc740 \"\uadc0\uc18d\uc6d4_\uc131\uba85\" row[0]+\"_\"+row[1]\n    errors.push([\"\"]);\n     } catch(err){\n      errors.push([\"\uc5d0\ub7ec\"]); \n     }   \n  }); \/\/forEach \ub2eb\ub294 \uc911\uad04\ud638\n  thisSheet.getRange(3, 26, thisSheet.getLastRow() - 2, 1).setValues(errors); \/\/ \uc5d0\ub7ec\uac00 \ub098\uba74 \ub9c8\uc9c0\ub9c9 \uc5f4\uc5d0 \uc5d0\ub7ec\ub77c\uace0 \ud45c\uc2dc\ud568\n};<\/pre><\/div>\n\n\n\n
        \uba3c\uc800 \ud15c\ud50c\ub9bf \ubb38\uc11c\uc758 ID, \uc784\uc2dc\ud3f4\ub354\uc758 ID, PDF \uc800\uc7a5\ud3f4\ub354\uc758 ID\ub97c \uc815\uc758\ud574\uc90d\ub2c8\ub2e4. <\/p>\n\n\n\n
        const docFile = DriveApp.getFileById(\"1f3DpK4j3hNqZwRSWFisPrQ4FuKvHgUBZjAWFWrYmEfQ\"); \/\/\uad6c\uae00 \ubb38\uc11c \ud15c\ud50c\ub9bf ID\nconst tempFolder = DriveApp.getFolderById(\"1Hy2bDVyX8o4WbuI8gOejf2jhnHDXBEY7\"); \/\/ \uad6c\uae00 \ubb38\uc11c\uc5d0 \ub370\uc774\ud130\ub97c \ubc14\uafd4 \ub123\uc740 \ub4a4\uc5d0 PDF\ub85c \ubcc0\ud658\ud558\uae30 \uc704\ud574 \uc800\uc7a5\ud558\ub294 \ud3f4\ub354\nconst pdfFolder = DriveApp.getFolderById(\"1LEoaZiwiBiioJJ3pjd_u2mxFtCwVkmHE\"); \/\/ PDF \uac00 \uc800\uc7a5\ub418\ub294 \ud3f4\ub354 \uc8fc\uc18c ID\nconst thisSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(\"\uae09\uc5ec\uba85\uc138\uc11c\"); \/\/ \ud604\uc7ac \ud30c\uc77c\uc5d0\uc11c \uc0ac\uc6a9\ud560 \ub370\uc774\ud130\uac00 \ub4e4\uc5b4 \uc788\ub294 \uc2dc\ud2b8\uc774\ub984\n  <\/pre><\/div>\n\n\n\n
        \uac00\uc838\uc62c \ub370\uc774\ud130\uc758 \ubc94\uc704\ub97c \uc124\uc815\ud569\ub2c8\ub2e4. \uc544\ub798\uc758 \ucf54\ub4dc\ub294 thisSheet\uc758 3\ud589 1\uc5f4\uc5d0\uc11c \uc2dc\uc791\ud574\uc11c \ub370\uc774\ud130\uac00 \uc788\ub294 \ub9c8\uc9c0\ub9c9\ud589, 25\uc5f4\uae4c\uc9c0\uc758 \ub370\uc774\ud130\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. thisSheet.getLastRow() – 2 \ub294 \uc2dc\ud2b8\uc758 \ub9e8 \uc704\uc5d0 2\uc5f4\uc740 \ub370\uc774\ud130\uc5d0 \ud3ec\ud568\ub418\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0 \ubcf4\uc815\ud574\uc8fc\ub294 \ud568\uc218\uc785\ub2c8\ub2e4. <\/p>\n\n\n\n
          const data = thisSheet.getRange(3, 1, thisSheet.getLastRow() - 2, 25).getDisplayValues(); \/\/\uc2dc\ud2b8\uc5d0\uc11c \ub370\uc774\ud130\uc758 \ubc94\uc704. \ud589\uc740 \ub3d9\uc801\uc73c\ub85c \uc124\uc815\ud568<\/pre><\/div>\n\n\n\n
        \uc774\uc81c \ud55c \ud589\uc529 PDF\ub97c \ub9cc\ub4dc\ub294 \uc791\uc5c5\uc744 \ubc18\ubcf5\ud569\ub2c8\ub2e4. \uc5d0\ub7ec\uac00 \ub098\uc11c \uc0dd\uc131\ub418\uc9c0 \uc54a\uc740 \uacbd\uc6b0\uc5d0\ub294 \ub9c8\uc9c0\ub9c9 \uc5f4\uc5d0 “\uc5d0\ub7ec” \ub77c\uace0 \ud45c\uc2dc\ud558\uac8c \ud574\ub450\uc5c8\uc2b5\ub2c8\ub2e4. createPDF()\uc5d0 \ub118\uae38 \ubcc0\uc218\ub4e4\uc744 \uc21c\uc11c\uc5d0 \ub9de\uac8c row[] \ud615\uc2dd\uc73c\ub85c \ub123\uc5b4\uc8fc\ub294\ub370, 0\uc774 \uccab\ubc88\uc9f8 \uc5f4\uc744 \uac00\ub9ac\ud0b5\ub2c8\ub2e4. <\/p>\n\n\n\n
          let errors =[];\n  data.forEach(row => {\n    try{\n    createPDF(row[0],row[1],row[2],row[3],row[4],row[5],row[6],row[7],row[8],row[9],row[10],row[11],row[12],row[13],row[14],row[15],row[16],row[17],row[18],row[19],row[20],row[21],row[22],row[23],row[24], row[0]+\"_\"+row[1], docFile, tempFolder, pdfFolder); \/\/\uc0dd\uc131\ub418\ub294 pdf \uc774\ub984\uc740 \"\uadc0\uc18d\uc6d4_\uc131\uba85\" row[0]+\"_\"+row[1]\n    errors.push([\"\"]);\n     } catch(err){\n      errors.push([\"\uc5d0\ub7ec\"]); \n     }   \n  }); \/\/forEach \ub2eb\ub294 \uc911\uad04\ud638\n  thisSheet.getRange(3, 26, thisSheet.getLastRow() - 2, 1).setValues(errors); \/\/ \uc5d0\ub7ec\uac00 \ub098\uba74 \ub9c8\uc9c0\ub9c9 \uc5f4\uc5d0 \uc5d0\ub7ec\ub77c\uace0 \ud45c\uc2dc\ud568\n<\/pre><\/div>\n\n\n\n
        \n\n\n\n
        \uc774\uc81c createBulkPDFs \ud568\uc218\ub97c \uc2e4\ud589\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \uc791\uc5c5\uacb0\uacfc\ub97c \uc5bb\uac8c \ub429\ub2c8\ub2e4. <\/p>\n\n\n
        \n
        \"\"<\/figure>\n<\/div>\n\n\n
        \n\n\n\n
        \ubcf8 \ud3ec\uc2a4\ud305\uc774 \ucc38\uace0\ud55c \ub3d9\uc601\uc0c1(\uc601\ubb38)<\/a><\/p>\n\n\n\n

        <\/p>\n\n\n\n
        \n\n\n\n

        <\/p>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        \uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<\/h2>\n\n\n\n
        \ud504\ub85c\uc81d\ud2b8 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/h2>\n\n\n\n
        <\/p>\n\n\n\n
        \uc624\ud1a0\uc624\ud53c\uc2a4 \ud504\ub85c\uc81d\ud2b8 \ubb38\uc758<\/a><\/p>\n\n\n\n

        <\/p>\n\n\n\n
        <\/p>\n","protected":false},"excerpt":{"rendered":"
        \uad6c\uae00\uc2dc\ud2b8\ub85c \ub370\uc774\ud130\ub97c \uad00\ub9ac\ud558\ub2e4\ubcf4\uba74, \uac70\ub798\uba85\uc138\uc11c\ub098 \uae09\uc5ec\uba85\uc138\uc11c\ucc98\ub7fc \uc785\ub825\ud558\ub294 \uc5c5\uccb4\ub098 \uc774\ub984\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ub97c \uac00\uacf5\ud574\uc11c \ucd9c\ub825\ud574\uc57c\ud560 \ub54c\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc5c5\uccb4\/\uc774\ub984\/\ud574\ub2f9\uc6d4\uc744 \uc785\ub825\ud558\uace0 \ucc38\uc870\ud574\uc11c \ub370\uc774\ud130\ub97c \uad6c\uae00 \uc2dc\ud2b8\uc5d0\uc11c \ubcf4\uc5ec\uc8fc\ub294 \uac83\uc740 FILTER, QUERY \ub4f1\uc744 \uc0ac\uc6a9\ud574\uc11c \uc27d\uac8c \uac00\ub2a5\ud558\uc9c0\ub9cc, \ucd9c\ub825\uc744 \ud558\ub824\uba74 \ud558\ub098\ud558\ub098 \uc785\ub825\uac12\uc744 \ubc14\uafd4\uc8fc\ub294\ub370 \uc218\uace0\uac00 \ub9ce\uc774 \ub4ed\ub2c8\ub2e4. \uc774\ubc88 \ud3ec\uc2a4\ud305\uc5d0\uc11c\ub294 \uad6c\uae00 \ubb38\uc11c\uc5d0 \ud15c\ud50c\ub9bf\uc744 \ub9cc\ub4e4\uc5b4 \ub193\uace0, \ub370\uc774\ud130\ub97c \ubc18\ubcf5\uc801\uc73c\ub85c \ubc14\uafb8\uba74\uc11c PDF\ub85c \uc800\uc7a5\ud558\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc778 \ud504\ub85c\uc138\uc2a4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \uc774\ubc88…<\/p>\n","protected":false},"author":1,"featured_media":3348,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[5],"tags":[73,78,77,37,75,74,76],"class_list":{"0":"post-3337","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-spreadsheet","8":"tag-pdf","10":"tag-zip","11":"tag-37","12":"tag-75","13":"tag-74","14":"tag-76"},"translation":{"provider":"WPGlobus","version":"3.0.2","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":false},"en":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/3337","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=3337"}],"version-history":[{"count":2,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/3337\/revisions"}],"predecessor-version":[{"id":17201,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/3337\/revisions\/17201"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/3348"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=3337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=3337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=3337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}