{"id":17053,"date":"2025-01-06T11:06:52","date_gmt":"2025-01-06T02:06:52","guid":{"rendered":"https:\/\/84office.jp\/?p=17053"},"modified":"2025-01-08T21:33:35","modified_gmt":"2025-01-08T12:33:35","slug":"gmail-draft-duplicate","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/gmail-draft-duplicate\/","title":{"rendered":"Effortlessly Duplicate Gmail Drafts: Boost Productivity with Google Sheets and Apps Script"},"content":{"rendered":"<div class=\"codoc-evacuations\" style=\"display:none;\" data-shortcode=\"\"><\/div>\n<p class=\"wp-block-paragraph\">&#8220;Have you ever wished for a feature to duplicate drafts created in Gmail, to manage your emails more efficiently?&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Unfortunately, Gmail doesn\u2019t offer a built-in function to duplicate drafts, so you have to create a new draft each time and manually copy and paste the content.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This process is time-consuming and reduces productivity.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">As a solution, you can automate the duplication of drafts by using Google Apps Script.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this article, we\u2019ll show you how to use Apps Script and Google Sheets to easily duplicate drafts as many times as needed.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\">This allows you to reuse drafts as templates, streamlining your daily workflow and boosting efficiency.<\/p>\n\n\n<div class=\"swell-block-postLink u-mb-ctrl u-mb-60\">\t\t\t<div class=\"p-blogCard -internal\" data-type=\"type1\" data-onclick=\"clickLink\">\n\t\t\t\t<div class=\"p-blogCard__inner\">\n\t\t\t\t\t<span class=\"p-blogCard__caption\">\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t<div class=\"p-blogCard__thumb c-postThumb\"><figure class=\"c-postThumb__figure\"><img decoding=\"async\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/1d36b191b935e2fb6a033cb4e78d867a-300x158.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" width=\"320\" height=\"180\"><\/figure><\/div>\t\t\t\t\t<div class=\"p-blogCard__body\">\n\t\t\t\t\t\t<a class=\"p-blogCard__title\" href=\"https:\/\/84office.jp\/en\/gas%ef%bd%b0send-email\/\">Boost Productivity: Automate Gmail to Multiple Recipients with Google Sheets and Apps Script<\/a>\n\t\t\t\t\t\t<span class=\"p-blogCard__excerpt\">Recommended for For those who find sending Gmail each time to be cumbersome For those who want to send emails to multiple recipients by only changing part of&#8230;<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n<h2 class=\"wp-block-heading\">Example Output<\/h2>\n\n\n\n<p class=\"u-mb-ctrl u-mb-0 wp-block-paragraph\"><strong>Spreadsheet<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"203\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-18-1024x203.png\" alt=\"\" class=\"wp-image-17057\" style=\"width:730px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-18-1024x203.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-18-300x59.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-18-768x152.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-18.png 1046w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-0 wp-block-paragraph\"><strong><strong>Gmail Draft Screen<\/strong><\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"2234\" height=\"609\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/59ae9dbd1cd93c5f5ded3aa7a10ef89d.png\" alt=\"\" class=\"wp-image-17063\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/59ae9dbd1cd93c5f5ded3aa7a10ef89d.png 2234w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/59ae9dbd1cd93c5f5ded3aa7a10ef89d-300x82.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/59ae9dbd1cd93c5f5ded3aa7a10ef89d-1024x279.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/59ae9dbd1cd93c5f5ded3aa7a10ef89d-768x209.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/59ae9dbd1cd93c5f5ded3aa7a10ef89d-1536x419.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/59ae9dbd1cd93c5f5ded3aa7a10ef89d-2048x558.png 2048w\" sizes=\"(max-width: 2234px) 100vw, 2234px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list has-border -border02 u-mb-ctrl u-mb-40 has-swl-pale-03-background-color has-background\">\n<li>Specify Draft Emails to Duplicate in Google Sheets\n<ul class=\"wp-block-list\">\n<li><strong>Column A:<\/strong> Subject (Keyword to identify the draft)<\/li>\n\n\n\n<li><strong>Column B:<\/strong> Number of copies to duplicate<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Run the script to duplicate the draft emails.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">When you run the script, the drafts saved in Gmail are automatically duplicated the specified number of times.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60 wp-block-paragraph\">This is especially useful when you need to copy frequently used templates.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Steps<\/h2>\n\n\n\n<div class=\"swell-block-step u-mb-ctrl u-mb-60\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Create a Draft in Gmail<\/div><div class=\"swell-block-step__body\">\n<p class=\"wp-block-paragraph\">Create the draft email that you want to duplicate.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Recipients (To, Cc, Bcc)<\/li>\n\n\n\n<li>Subject<\/li>\n\n\n\n<li class=\"u-mb-ctrl u-mb-30\">Body<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">(The email can be duplicated regardless of whether it is in HTML or plain text format.)<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Prepare the Spreadsheet<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"203\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-19-1024x203.png\" alt=\"\" class=\"wp-image-17058\" style=\"width:566px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-19-1024x203.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-19-300x59.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-19-768x152.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-19.png 1046w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>Column A:<\/strong> Subject keyword to identify the draft (partial match)<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\"><strong>Column B:<\/strong> Number of copies to duplicate<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Enter the subject of the email drafts and the number of copies you want to duplicate into the spreadsheet.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The script references a sheet named <strong>&#8220;Email Draft Duplication&#8221;<\/strong> during execution.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Feel free to rename the sheet if needed, but ensure the script reflects the updated sheet name.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Open Apps Script Editor<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"933\" height=\"591\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/98efceb7a335447039dff05eb8d70d3d.png\" alt=\"\" class=\"wp-image-16537\" style=\"width:447px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/98efceb7a335447039dff05eb8d70d3d.png 933w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/98efceb7a335447039dff05eb8d70d3d-300x190.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/98efceb7a335447039dff05eb8d70d3d-768x486.png 768w\" sizes=\"(max-width: 933px) 100vw, 933px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Open a Google Spreadsheet and click on \u201c<strong>Extensions<\/strong>\u201d in the menu, then \u201c<strong>Apps Script<\/strong>\u201d to open the Apps Script editor.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Create the Script<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"472\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662-1024x472.png\" alt=\"\" class=\"wp-image-16191\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662-1024x472.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662-300x138.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662-768x354.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/e5e524d3405a7a1c3cfaaf3f2b1cc662.png 1387w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\">Since the default <code>function myFunction() {}<\/code> is present, delete it and replace it with the script below.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"function duplicateDraft() {\n  const sheetName = &quot;DraftDup&quot;; \/\/ Shortened sheet name\n  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);\n\n  if (!sheet) {\n    Logger.log(`The specified sheet &quot;${sheetName}&quot; was not found.`);\n    return;\n  }\n\n  const data = sheet.getDataRange().getValues(); \/\/ Retrieve the data from the sheet\n\n  for (let i = 1; i &lt; data.length; i++) { \/\/ Skip the first row (header)\n    const subjectKeyword = data[i][0]; \/\/ Subject keyword\n    const duplicateCount = data[i][1]; \/\/ Number of duplicates\n    if (!subjectKeyword || !duplicateCount) continue; \/\/ Skip if data is missing\n\n    \/\/ Search drafts by subject keyword\n    const templateQuery = `subject:&quot;${subjectKeyword}&quot; in:drafts`; \/\/ Search query for drafts\n    const threads = GmailApp.search(templateQuery);\n\n    if (threads.length &gt; 0) {\n      const message = threads[0].getMessages()[0]; \/\/ Get the first message in the thread\n      const subject = message.getSubject();\n      const htmlBody = message.getBody(); \/\/ Get the HTML body\n      const plainBody = message.getPlainBody(); \/\/ Get the plain text body\n      const to = message.getTo(); \/\/ Recipients\n      const cc = message.getCc(); \/\/ CC\n      const bcc = message.getBcc(); \/\/ BCC\n\n      const bodyToUse = htmlBody || plainBody;\n\n      for (let j = 0; j &lt; duplicateCount; j++) {\n        if (htmlBody) {\n          GmailApp.createDraft(to, subject, '', { htmlBody: bodyToUse, cc: cc, bcc: bcc });\n        } else {\n          GmailApp.createDraft(to, subject, bodyToUse, { cc: cc, bcc: bcc });\n        }\n      }\n      Logger.log(`Draft duplicated: ${subject} \u00d7 ${duplicateCount} times`);\n    } else {\n      Logger.log(`No drafts found matching the subject: &quot;${subjectKeyword}&quot;`);\n    }\n  }\n}\n\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #66D9EF; font-style: italic\">function<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">duplicateDraft<\/span><span style=\"color: #F8F8F2\">() {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> sheetName <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">&quot;DraftDup&quot;<\/span><span style=\"color: #F8F8F2\">; <\/span><span style=\"color: #88846F\">\/\/ Shortened sheet name<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> sheet <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> SpreadsheetApp.<\/span><span style=\"color: #A6E22E\">getActiveSpreadsheet<\/span><span style=\"color: #F8F8F2\">().<\/span><span style=\"color: #A6E22E\">getSheetByName<\/span><span style=\"color: #F8F8F2\">(sheetName);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #F92672\">if<\/span><span style=\"color: #F8F8F2\"> (<\/span><span style=\"color: #F92672\">!<\/span><span style=\"color: #F8F8F2\">sheet) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    Logger.<\/span><span style=\"color: #A6E22E\">log<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #E6DB74\">`The specified sheet &quot;<\/span><span style=\"color: #F92672\">${<\/span><span style=\"color: #F8F8F2\">sheetName<\/span><span style=\"color: #F92672\">}<\/span><span style=\"color: #E6DB74\">&quot; was not found.`<\/span><span style=\"color: #F8F8F2\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    <\/span><span style=\"color: #F92672\">return<\/span><span style=\"color: #F8F8F2\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  }<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> data <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> sheet.<\/span><span style=\"color: #A6E22E\">getDataRange<\/span><span style=\"color: #F8F8F2\">().<\/span><span style=\"color: #A6E22E\">getValues<\/span><span style=\"color: #F8F8F2\">(); <\/span><span style=\"color: #88846F\">\/\/ Retrieve the data from the sheet<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  <\/span><span style=\"color: #F92672\">for<\/span><span style=\"color: #F8F8F2\"> (<\/span><span style=\"color: #66D9EF; font-style: italic\">let<\/span><span style=\"color: #F8F8F2\"> i <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #AE81FF\">1<\/span><span style=\"color: #F8F8F2\">; i <\/span><span style=\"color: #F92672\">&lt;<\/span><span style=\"color: #F8F8F2\"> data.length; i<\/span><span style=\"color: #F92672\">++<\/span><span style=\"color: #F8F8F2\">) { <\/span><span style=\"color: #88846F\">\/\/ Skip the first row (header)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> subjectKeyword <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> data[i][<\/span><span style=\"color: #AE81FF\">0<\/span><span style=\"color: #F8F8F2\">]; <\/span><span style=\"color: #88846F\">\/\/ Subject keyword<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> duplicateCount <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> data[i][<\/span><span style=\"color: #AE81FF\">1<\/span><span style=\"color: #F8F8F2\">]; <\/span><span style=\"color: #88846F\">\/\/ Number of duplicates<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    <\/span><span style=\"color: #F92672\">if<\/span><span style=\"color: #F8F8F2\"> (<\/span><span style=\"color: #F92672\">!<\/span><span style=\"color: #F8F8F2\">subjectKeyword <\/span><span style=\"color: #F92672\">||<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">!<\/span><span style=\"color: #F8F8F2\">duplicateCount) <\/span><span style=\"color: #F92672\">continue<\/span><span style=\"color: #F8F8F2\">; <\/span><span style=\"color: #88846F\">\/\/ Skip if data is missing<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    <\/span><span style=\"color: #88846F\">\/\/ Search drafts by subject keyword<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> templateQuery <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #E6DB74\">`subject:&quot;<\/span><span style=\"color: #F92672\">${<\/span><span style=\"color: #F8F8F2\">subjectKeyword<\/span><span style=\"color: #F92672\">}<\/span><span style=\"color: #E6DB74\">&quot; in:drafts`<\/span><span style=\"color: #F8F8F2\">; <\/span><span style=\"color: #88846F\">\/\/ Search query for drafts<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> threads <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> GmailApp.<\/span><span style=\"color: #A6E22E\">search<\/span><span style=\"color: #F8F8F2\">(templateQuery);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    <\/span><span style=\"color: #F92672\">if<\/span><span style=\"color: #F8F8F2\"> (threads.length <\/span><span style=\"color: #F92672\">&gt;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #AE81FF\">0<\/span><span style=\"color: #F8F8F2\">) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">      <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> message <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> threads[<\/span><span style=\"color: #AE81FF\">0<\/span><span style=\"color: #F8F8F2\">].<\/span><span style=\"color: #A6E22E\">getMessages<\/span><span style=\"color: #F8F8F2\">()[<\/span><span style=\"color: #AE81FF\">0<\/span><span style=\"color: #F8F8F2\">]; <\/span><span style=\"color: #88846F\">\/\/ Get the first message in the thread<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">      <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> subject <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> message.<\/span><span style=\"color: #A6E22E\">getSubject<\/span><span style=\"color: #F8F8F2\">();<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">      <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> htmlBody <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> message.<\/span><span style=\"color: #A6E22E\">getBody<\/span><span style=\"color: #F8F8F2\">(); <\/span><span style=\"color: #88846F\">\/\/ Get the HTML body<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">      <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> plainBody <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> message.<\/span><span style=\"color: #A6E22E\">getPlainBody<\/span><span style=\"color: #F8F8F2\">(); <\/span><span style=\"color: #88846F\">\/\/ Get the plain text body<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">      <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> to <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> message.<\/span><span style=\"color: #A6E22E\">getTo<\/span><span style=\"color: #F8F8F2\">(); <\/span><span style=\"color: #88846F\">\/\/ Recipients<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">      <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> cc <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> message.<\/span><span style=\"color: #A6E22E\">getCc<\/span><span style=\"color: #F8F8F2\">(); <\/span><span style=\"color: #88846F\">\/\/ CC<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">      <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> bcc <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> message.<\/span><span style=\"color: #A6E22E\">getBcc<\/span><span style=\"color: #F8F8F2\">(); <\/span><span style=\"color: #88846F\">\/\/ BCC<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">      <\/span><span style=\"color: #66D9EF; font-style: italic\">const<\/span><span style=\"color: #F8F8F2\"> bodyToUse <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> htmlBody <\/span><span style=\"color: #F92672\">||<\/span><span style=\"color: #F8F8F2\"> plainBody;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">      <\/span><span style=\"color: #F92672\">for<\/span><span style=\"color: #F8F8F2\"> (<\/span><span style=\"color: #66D9EF; font-style: italic\">let<\/span><span style=\"color: #F8F8F2\"> j <\/span><span style=\"color: #F92672\">=<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #AE81FF\">0<\/span><span style=\"color: #F8F8F2\">; j <\/span><span style=\"color: #F92672\">&lt;<\/span><span style=\"color: #F8F8F2\"> duplicateCount; j<\/span><span style=\"color: #F92672\">++<\/span><span style=\"color: #F8F8F2\">) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">        <\/span><span style=\"color: #F92672\">if<\/span><span style=\"color: #F8F8F2\"> (htmlBody) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">          GmailApp.<\/span><span style=\"color: #A6E22E\">createDraft<\/span><span style=\"color: #F8F8F2\">(to, subject, <\/span><span style=\"color: #E6DB74\">&#39;&#39;<\/span><span style=\"color: #F8F8F2\">, { htmlBody: bodyToUse, cc: cc, bcc: bcc });<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">        } <\/span><span style=\"color: #F92672\">else<\/span><span style=\"color: #F8F8F2\"> {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">          GmailApp.<\/span><span style=\"color: #A6E22E\">createDraft<\/span><span style=\"color: #F8F8F2\">(to, subject, bodyToUse, { cc: cc, bcc: bcc });<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">        }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">      }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">      Logger.<\/span><span style=\"color: #A6E22E\">log<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #E6DB74\">`Draft duplicated: <\/span><span style=\"color: #F92672\">${<\/span><span style=\"color: #F8F8F2\">subject<\/span><span style=\"color: #F92672\">}<\/span><span style=\"color: #E6DB74\"> \u00d7 <\/span><span style=\"color: #F92672\">${<\/span><span style=\"color: #F8F8F2\">duplicateCount<\/span><span style=\"color: #F92672\">}<\/span><span style=\"color: #E6DB74\"> times`<\/span><span style=\"color: #F8F8F2\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    } <\/span><span style=\"color: #F92672\">else<\/span><span style=\"color: #F8F8F2\"> {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">      Logger.<\/span><span style=\"color: #A6E22E\">log<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #E6DB74\">`No drafts found matching the subject: &quot;<\/span><span style=\"color: #F92672\">${<\/span><span style=\"color: #F8F8F2\">subjectKeyword<\/span><span style=\"color: #F92672\">}<\/span><span style=\"color: #E6DB74\">&quot;`<\/span><span style=\"color: #F8F8F2\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">    }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">  }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F8F8F2\">}<\/span><\/span>\n<span class=\"line\"><\/span><\/code><\/pre><\/div>\n\n\n\n<div class=\"swell-block-accordion\">\n<details class=\"swell-block-accordion__item\" data-swl-acc=\"wrapper\"><summary class=\"swell-block-accordion__title\" data-swl-acc=\"header\"><span class=\"swell-block-accordion__label\"><\/span><span class=\"swell-block-accordion__icon c-switchIconBtn\" data-swl-acc=\"icon\" aria-hidden=\"true\" data-opened=\"false\"><i class=\"__icon--closed icon-caret-down\"><\/i><i class=\"__icon--opened icon-caret-up\"><\/i><\/span><\/summary><div class=\"swell-block-accordion__body\" data-swl-acc=\"body\">\n<p class=\"wp-block-paragraph\"><\/p>\n<\/div><\/details>\n<\/div>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Save the Script<\/strong><\/div><div class=\"swell-block-step__body\">\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"409\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/e98105455940fb9f62e047f3e33d881f-1024x409.png\" alt=\"\" class=\"wp-image-17054\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/e98105455940fb9f62e047f3e33d881f-1024x409.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/e98105455940fb9f62e047f3e33d881f-300x120.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/e98105455940fb9f62e047f3e33d881f-768x307.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/e98105455940fb9f62e047f3e33d881f-1536x613.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/e98105455940fb9f62e047f3e33d881f.png 1680w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">After writing the script, name and save it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">(e.g., \u201cDraft Duplication\u201d)<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Run the Script<\/div><div class=\"swell-block-step__body\">\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"421\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/7df227fffc430dabd8dcca5574c9f64e-1024x421.png\" alt=\"\" class=\"wp-image-17055\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/7df227fffc430dabd8dcca5574c9f64e-1024x421.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/7df227fffc430dabd8dcca5574c9f64e-300x123.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/7df227fffc430dabd8dcca5574c9f64e-768x316.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/7df227fffc430dabd8dcca5574c9f64e-1536x631.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/7df227fffc430dabd8dcca5574c9f64e.png 1671w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\">Run the script to duplicate the draft emails.<\/p>\n\n\n\n<div class=\"wp-block-group is-style-big_icon_memo u-mb-ctrl u-mb-60\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\">If you&#8217;re running the script for the first time, you need to authorize it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Therefore, press &#8220;<strong>Review Permissions.<\/strong>&#8220;<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-50\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"882\" height=\"345\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-79.png\" alt=\"\" class=\"wp-image-15938\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-79.png 882w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-79-300x117.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-79-768x300.png 768w\" sizes=\"(max-width: 882px) 100vw, 882px\" \/><\/figure>\n<\/div>\n\n\n<div class=\"swell-block-accordion\">\n<details class=\"swell-block-accordion__item\" data-swl-acc=\"wrapper\"><summary class=\"swell-block-accordion__title\" data-swl-acc=\"header\"><span class=\"swell-block-accordion__label\">Detailed Authorization Steps<\/span><span class=\"swell-block-accordion__icon c-switchIconBtn\" data-swl-acc=\"icon\" aria-hidden=\"true\" data-opened=\"false\"><i class=\"__icon--closed icon-caret-down\"><\/i><i class=\"__icon--opened icon-caret-up\"><\/i><\/span><\/summary><div class=\"swell-block-accordion__body\" data-swl-acc=\"body\">\n<p class=\"wp-block-paragraph\"><strong>Press &#8220;Advanced.&#8221;<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full u-mb-ctrl u-mb-50\"><img decoding=\"async\" width=\"1272\" height=\"688\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d.jpg\" alt=\"\" class=\"wp-image-15939\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d.jpg 1272w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d-300x162.jpg 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d-1024x554.jpg 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/188993dfac23ed4b35c326d75de2796d-768x415.jpg 768w\" sizes=\"(max-width: 1272px) 100vw, 1272px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Press &#8220;Go to Untitled project (Unsafe).&#8221;<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-50\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"1305\" height=\"893\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9.jpg\" alt=\"\" class=\"wp-image-15940\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9.jpg 1305w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9-300x205.jpg 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9-1024x701.jpg 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/b7775751f92380510b389302eaafe1b9-768x526.jpg 768w\" sizes=\"(max-width: 1305px) 100vw, 1305px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>After that, press &#8220;Allow.&#8221;<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"955\" height=\"543\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/7ebb34b4d2c42fa532ad1c35c1ec1049.jpg\" alt=\"\" class=\"wp-image-15941\" style=\"width:566px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/7ebb34b4d2c42fa532ad1c35c1ec1049.jpg 955w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/7ebb34b4d2c42fa532ad1c35c1ec1049-300x171.jpg 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/7ebb34b4d2c42fa532ad1c35c1ec1049-768x437.jpg 768w\" sizes=\"(max-width: 955px) 100vw, 955px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<\/div><\/details>\n<\/div>\n<\/div><\/div>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Draft Emails are Duplicated<\/strong><\/div><div class=\"swell-block-step__body\">\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"257\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-21-1024x257.png\" alt=\"\" class=\"wp-image-17061\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-21-1024x257.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-21-300x75.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-21-768x192.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-21-1536x385.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-21.png 1576w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"279\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/59ae9dbd1cd93c5f5ded3aa7a10ef89d-1024x279.png\" alt=\"\" class=\"wp-image-17063\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/59ae9dbd1cd93c5f5ded3aa7a10ef89d-1024x279.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/59ae9dbd1cd93c5f5ded3aa7a10ef89d-300x82.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/59ae9dbd1cd93c5f5ded3aa7a10ef89d-768x209.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/59ae9dbd1cd93c5f5ded3aa7a10ef89d-1536x419.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/59ae9dbd1cd93c5f5ded3aa7a10ef89d-2048x558.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"1008\" height=\"1024\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/632ab82135a36c0bbdb15c9cf7cf5546-1008x1024.png\" alt=\"\" class=\"wp-image-17064\" style=\"width:491px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/632ab82135a36c0bbdb15c9cf7cf5546-1008x1024.png 1008w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/632ab82135a36c0bbdb15c9cf7cf5546-295x300.png 295w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/632ab82135a36c0bbdb15c9cf7cf5546-768x780.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/632ab82135a36c0bbdb15c9cf7cf5546.png 1106w\" sizes=\"(max-width: 1008px) 100vw, 1008px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">If the draft includes recipients (including Cc and Bcc), they will be duplicated exactly as in the original draft.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-30\"><strong>Notes<\/strong><\/h2>\n\n\n\n<dl class=\"swell-block-dl u-mb-ctrl u-mb-60\">\n<dt class=\"swell-block-dl__dt\">Multiple Drafts with the Same Subject<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<p class=\"wp-block-paragraph\">If there are multiple drafts with the same subject, only the first draft found will be duplicated.<\/p>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><strong>Gmail Limitations<\/strong><\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<p class=\"wp-block-paragraph\">Duplicating a large number of drafts may trigger Gmail\u2019s API limits. (Be cautious if exceeding 50 drafts at a time.)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For more information on Gmail limitations, please refer to <a href=\"https:\/\/support.google.com\/a\/answer\/166852?hl=en&amp;sjid=4982202412751746840-AP#zippy=%2C%E7%84%A1%E6%96%99%E8%A9%A6%E7%94%A8%E3%82%A2%E3%82%AB%E3%82%A6%E3%83%B3%E3%83%88%E3%81%AB%E9%96%A2%E3%81%99%E3%82%8B%E5%88%B6%E9%99%90\" target=\"_blank\" rel=\"noreferrer noopener\">Gmail&#8217;s API limits documentation<\/a>.<\/p>\n<\/dd>\n<\/dl>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-40\"><strong>Conclusion<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">We\u2019ve introduced a step-by-step method for efficiently duplicating Gmail drafts using Google Sheets and Google Apps Script.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Additionally, with Apps Script, you can dynamically modify parts of the email body and automate sending personalized emails to multiple recipients.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\">For detailed instructions on how to achieve this, please refer to the article below.<\/p>\n\n\n<div class=\"swell-block-postLink u-mb-ctrl u-mb-40\">\t\t\t<div class=\"p-blogCard -internal\" data-type=\"type1\" data-onclick=\"clickLink\">\n\t\t\t\t<div class=\"p-blogCard__inner\">\n\t\t\t\t\t<span class=\"p-blogCard__caption\">\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t<div class=\"p-blogCard__thumb c-postThumb\"><figure class=\"c-postThumb__figure\"><img decoding=\"async\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/1d36b191b935e2fb6a033cb4e78d867a-300x158.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" width=\"320\" height=\"180\"><\/figure><\/div>\t\t\t\t\t<div class=\"p-blogCard__body\">\n\t\t\t\t\t\t<a class=\"p-blogCard__title\" href=\"https:\/\/84office.jp\/en\/gas%ef%bd%b0send-email\/\">Boost Productivity: Automate Gmail to Multiple Recipients with Google Sheets and Apps Script<\/a>\n\t\t\t\t\t\t<span class=\"p-blogCard__excerpt\">Recommended for For those who find sending Gmail each time to be cumbersome For those who want to send emails to multiple recipients by only changing part of&#8230;<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n<div class=\"p-postListWrap u-mb-ctrl u-mb-40\"><ul class=\"p-postList -type-simple\"><li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/gmail-draft-duplicate\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__body\">\n\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-01-06\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e741\u67086\u65e5<\/time><\/div>\n\t\t<span class=\"p-postList__cat u-thin icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t\t\t\t<\/div>\n\t\t\t<h2 class=\"p-postList__title\">Effortlessly Duplicate Gmail Drafts: Boost Productivity with Google Sheets and Apps Script<\/h2>\t\t<\/div>\n\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/https-84office-jp-file-access-rights-change-batch\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__body\">\n\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-01-13\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e741\u670813\u65e5<\/time><\/div>\n\t\t<span class=\"p-postList__cat u-thin icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t\t\t\t<\/div>\n\t\t\t<h2 class=\"p-postList__title\">Manage and Modify Spreadsheet Permissions in Bulk with Google Apps Script: The Update Guide<\/h2>\t\t<\/div>\n\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/spreadsheet-tab-move\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__body\">\n\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2024-11-14\" aria-label=\"\u516c\u958b\u65e5\">2024\u5e7411\u670814\u65e5<\/time><\/div>\n\t\t<span class=\"p-postList__cat u-thin icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t\t\t\t<\/div>\n\t\t\t<h2 class=\"p-postList__title\">Enhance Productivity with Google Apps Script: Instantly Rearrange Google Sheets Tabs Right to Left<\/h2>\t\t<\/div>\n\t<\/a>\n<\/li>\n<\/ul><\/div>\n\n\n<p class=\"is-style-emboss_box has-swl-pale-02-background-color has-background wp-block-paragraph\">Our company offers support for improving work efficiency through the use of Google Apps Script. <br>If you need assistance with Google Apps Script customization or error resolution, please feel free to contact us. <br>We are fully committed to supporting your business improvements.<br><br><a href=\"https:\/\/84office.jp\/contact\/\">Contact us here<br><\/a><\/p>\n\n\n\n<script src=\"https:\/\/codoc.jp\/js\/cms.js\" data-css=\"rainbow\" data-usercode=\"pQLZofrBiA\" charset=\"UTF-8\" defer><\/script>\n <div id=\"codoc-entry-9lNr9PuMXQ\" class=\"codoc-entries\" data-without-body=\"1\" data-support-button-text=\"Support with a Tip\" data-support-message=\"We will keep offering tools and information to boost work efficiency. Your support helps us provide even better content.\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;Have you ever wished for a feature to duplicate drafts created in Gmail, to manage your emails more eff [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17065,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","_locale":"en_US","_original_post":"https:\/\/84office.jp\/?p=16818","footnotes":""},"categories":[12],"tags":[],"class_list":["post-17053","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-12","en-US"],"_links":{"self":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/17053","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/comments?post=17053"}],"version-history":[{"count":5,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/17053\/revisions"}],"predecessor-version":[{"id":22473,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/17053\/revisions\/22473"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media\/17065"}],"wp:attachment":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media?parent=17053"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/categories?post=17053"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/tags?post=17053"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}