{"id":22446,"date":"2025-07-20T20:03:16","date_gmt":"2025-07-20T11:03:16","guid":{"rendered":"https:\/\/84office.jp\/?p=22446"},"modified":"2025-07-20T20:03:17","modified_gmt":"2025-07-20T11:03:17","slug":"gmail-bulk-send-template","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/gmail-bulk-send-template\/","title":{"rendered":"Gmail Bulk Sending Template | Easily Send to Multiple Recipients via Google Sheets"},"content":{"rendered":"<div class=\"codoc-evacuations\" style=\"display:none;\" data-shortcode=\"%5B%3Ca+href%3D%22https%3A%2F%2F84office.jp%2Fen%2Fcontact%2F%22+target%3D%22_blank%22+rel%3D%22noreferrer+noopener%22%3EContact+Us+Here%3C%2Fa%3E%5D\">[<a href=\"https:\/\/84office.jp\/en\/contact\/\" target=\"_blank\" rel=\"noreferrer noopener\">Contact Us Here<\/a>]<\/div>\n<p class=\"u-mb-ctrl u-mb-40 has-swl-pale-02-background-color has-background wp-block-paragraph\">The template introduced in this article is a paid product.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Have you ever wanted to send bulk emails with Gmail more easily?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In a previous article \u25b6\ufe0e <a href=\"https:\/\/84office.jp\/en\/gas\uff70send-email\/\" target=\"_blank\" rel=\"noreferrer noopener\">Boost Productivity: Automate Gmail to Multiple Recipients with Google Sheets and Apps Script<\/a>, I introduced a sample Google Apps Script (GAS) that lets you send emails in bulk directly from a Google Sheet.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">However, the previous method required some extra steps:<\/p>\n\n\n\n<ul class=\"wp-block-list has-swl-gray-background-color has-background\">\n<li>Copying and pasting the script, then setting it up<\/li>\n\n\n\n<li>Writing the email subject directly in the script<\/li>\n\n\n\n<li>Configuring the spreadsheet layout<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">These steps could be a bit of a hassle for some users.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">That\u2019s why I\u2019ve now created a more practical and easy-to-use \u201cGmail Bulk Sending Template.\u201d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With this template, you can:<\/p>\n\n\n\n<ul class=\"wp-block-list has-swl-pale-02-background-color has-background\">\n<li>Set email subjects directly from the sheet<\/li>\n\n\n\n<li>Easily select recipients using checkboxes<\/li>\n\n\n\n<li>Support HTML emails and drafts with attachments<\/li>\n\n\n\n<li>Send emails with a single click, with features to prevent duplicate sends<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">This makes managing bulk emails even more intuitive.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\">If you\u2019re looking to streamline your email workflow, give this template a try!<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60 wp-block-paragraph\">If you want to jump straight to the template download, you can skip ahead <a href=\"#download\">here<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Template Features<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large is-style-shadow u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"291\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-213-1024x291.png\" alt=\"\" class=\"wp-image-22451\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-213-1024x291.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-213-300x85.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-213-768x218.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-213-1536x436.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-213.png 1683w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list has-border -border02 u-mb-ctrl u-mb-60 has-swl-pale-03-background-color has-background\">\n<li><strong>Send Gmail messages in bulk to multiple recipients directly from your Google Sheet<\/strong><\/li>\n\n\n\n<li><strong>Set the draft email subject using cell C1<\/strong><\/li>\n\n\n\n<li><strong>Freely configure merge fields for Gmail (such as meeting date, meeting time, etc.)<\/strong><\/li>\n\n\n\n<li><strong>Manage recipients with checkboxes<\/strong><\/li>\n\n\n\n<li><strong>Record the email sent date and time in column G to prevent duplicate sending<\/strong><\/li>\n\n\n\n<li><strong>Includes data clear functions (reset only checkboxes or reset all data)<\/strong><\/li>\n\n\n\n<li><strong>Can be easily duplicated for different projects and reused<\/strong><\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Differences from the Free Script<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-table is-all-centered--va u-mb-ctrl u-mb-40 is-thead-centered\"><table class=\"has-fixed-layout\"><thead style=\"--thead-color--bg:var(--color_pale03);--thead-color--txt:var(--swl-text_color--black)\"><tr><th>Item<\/th><th class=\"has-text-align-center\" data-align=\"center\">Free Script Version<\/th><th class=\"has-text-align-center\" data-align=\"center\">Paid Template Version<\/th><\/tr><\/thead><tbody><tr><td>Email Subject Setting<\/td><td class=\"has-text-align-center\" data-align=\"center\"><span class=\"swl-inline-color has-swl-deep-04-color\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNNDMgNDNINWMtMS4yIDAtMi40LS43LTMtMS43LS42LTEuMS0uNi0yLjQgMC0zLjVsMTktMzNjLjYtMS4xIDEuOC0xLjggMy0xLjhzMi40LjcgMyAxLjhsMTkgMzNjLjYgMS4xLjYgMi40IDAgMy41UzQ0LjMgNDMgNDMgNDN6TTcuNiAzOGgzMi45TDI0IDkuNSA3LjYgMzh6TTI1LjMgNy4zeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsTriangle\" data-id=\"1\" aria-hidden=\"true\" class=\"swl-inline-icon\">\u2003<\/span><\/span><br>(Set directly in script)<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u2705<br>(Easily set via cell C1)<\/td><\/tr><tr><td>Placeholder (Body Merge Fields)<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u2705<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u2705<\/td><\/tr><tr><td>Data Clear Function<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u274c<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u2705<\/td><\/tr><tr><td>Sheet Reuse (Sheet Copy)<\/td><td class=\"has-text-align-center\" data-align=\"center\"><span class=\"swl-inline-color has-swl-deep-04-color\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNNDMgNDNINWMtMS4yIDAtMi40LS43LTMtMS43LS42LTEuMS0uNi0yLjQgMC0zLjVsMTktMzNjLjYtMS4xIDEuOC0xLjggMy0xLjhzMi40LjcgMyAxLjhsMTkgMzNjLjYgMS4xLjYgMi40IDAgMy41UzQ0LjMgNDMgNDMgNDN6TTcuNiAzOGgzMi45TDI0IDkuNSA3LjYgMzh6TTI1LjMgNy4zeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsTriangle\" data-id=\"1\" aria-hidden=\"true\" class=\"swl-inline-icon\">\u2003<\/span><\/span><br>(Script modification required)<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u2705<br>(Can be reused by copying the sheet)<\/td><\/tr><tr><td>Execute with Button<\/td><td class=\"has-text-align-center\" data-align=\"center\"><span class=\"swl-inline-color has-swl-deep-04-color\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNNDMgNDNINWMtMS4yIDAtMi40LS43LTMtMS43LS42LTEuMS0uNi0yLjQgMC0zLjVsMTktMzNjLjYtMS4xIDEuOC0xLjggMy0xLjhzMi40LjcgMyAxLjhsMTkgMzNjLjYgMS4xLjYgMi40IDAgMy41UzQ0LjMgNDMgNDMgNDN6TTcuNiAzOGgzMi45TDI0IDkuNSA3LjYgMzh6TTI1LjMgNy4zeiI+PC9wYXRoPjwvc3ZnPg==)\" data-icon=\"LsTriangle\" data-id=\"1\" aria-hidden=\"true\" class=\"swl-inline-icon\">\u2003<\/span><\/span><br>(Need to create your own)<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u2705<br>(Button pre-installed in template)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">In the previous article, the free script required you to directly edit the script to set the email subject and sheet name.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60 wp-block-paragraph\">With this new template version, you can change settings simply by entering them into cells\u2014no need to modify the script itself.<br>This makes it much easier and more flexible to use.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Use the Template<\/strong><\/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\">Before using the template, prepare a draft email in your Gmail account.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the draft, set up any information you plan to insert from the spreadsheet.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\">In the email body, include placeholders (keywords enclosed in curly braces, like <code>{}<\/code>) as shown below.<\/p>\n\n\n\n<div class=\"swell-block-capbox cap_box is-style-onborder_ttl u-mb-ctrl u-mb-40\"><div class=\"cap_box_ttl\"><span><span class=\"swl-fz u-fz-l\"><strong>Sample: Meeting Invitation Email Draft<\/strong><\/span><\/span><\/div><div class=\"cap_box_content\">\n<p class=\"wp-block-paragraph\">Subject: Regarding Your Meeting Schedule<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Body: <\/p>\n\n\n\n<pre class=\"wp-block-code u-mb-ctrl u-mb-50 has-swl-pale-02-background-color has-background\"><code>Dear {<strong>Last Name<\/strong>},\n\nWe are planning a meeting as follows:\n\nDate: {<strong>Meeting Date<\/strong>} *(You can change the placeholders to match your own email content)\nTime: {<strong>Meeting Time<\/strong>} *(Same as above)<\/code><\/pre>\n<\/div><\/div>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\">The content from the corresponding columns in the spreadsheet will be automatically inserted into these placeholders (keywords enclosed in curly braces).<\/p>\n\n\n\n<figure class=\"wp-block-table u-mb-ctrl u-mb-40\"><table class=\"has-fixed-layout\"><thead style=\"--thead-color--bg:var(--color_pale03);--thead-color--txt:var(--swl-text_color--black)\"><tr><th>Placeholder<\/th><th>Spreadsheet Column<\/th><th>Example Content<\/th><\/tr><\/thead><tbody><tr><td><code>{Last Name}<\/code><\/td><td>Column A<\/td><td>Smith<\/td><\/tr><tr><td><code>{Meeting Date}<\/code><\/td><td>Column D<\/td><td>October 10 (Thu)<\/td><\/tr><tr><td><code>{Meeting Time}<\/code><\/td><td>Column E<\/td><td>13:30<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Please feel free to modify the placeholders as needed to match the content of your own email.<\/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>Copy the Template File<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40 is-style-shadow\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"565\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-215-1024x565.png\" alt=\"\" class=\"wp-image-22453\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-215-1024x565.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-215-300x166.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-215-768x424.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-215.png 1130w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Copy the file from the template <a href=\"#download\">link below<\/a>.<\/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>Enter the Draft Email Subject<\/strong><\/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=\"866\" height=\"268\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-217.png\" alt=\"\" class=\"wp-image-22455\" style=\"width:495px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-217.png 866w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-217-300x93.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-217-768x238.png 768w\" sizes=\"(max-width: 866px) 100vw, 866px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Enter the subject of the draft email you created in Gmail into cell C1.<br>When sending emails, the draft with the matching subject will be used.<br>(The original draft will remain, as the email is sent by duplicating the draft.)<\/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\">Enter the Required Information<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image is-style-shadow u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"396\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-219-1024x396.png\" alt=\"\" class=\"wp-image-22457\" style=\"width:724px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-219-1024x396.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-219-300x116.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-219-768x297.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-219.png 1227w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\">Enter the name, email address, and merge fields (such as meeting date).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can freely change the field names in cells D2 and E2 (yellow cells) to suit your needs,<br>but make sure that the field names match the placeholder names used in your Gmail draft.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example:<\/p>\n\n\n\n<ul class=\"wp-block-list u-mb-ctrl u-mb-40 has-swl-pale-02-background-color has-background\">\n<li>If you enter \u201cMeeting Date\u201d in cell D2 \u2192 Use {Meeting Date} as the placeholder in the draft email body<\/li>\n\n\n\n<li>If you enter \u201cMeeting Time\u201d in cell E2 \u2192 Use {Meeting Time} as the placeholder in the draft email body<\/li>\n<\/ul>\n\n\n\n<p class=\"u-mb-ctrl u-mb-30 wp-block-paragraph\">By managing the field names in the spreadsheet and the placeholders as a set in this way, the information will be inserted correctly.<\/p>\n\n\n\n<p class=\"is-style-big_icon_point wp-block-paragraph\">When you change the placeholders, don\u2019t forget to also update the corresponding column names in the spreadsheet.<\/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>Check the Recipients to Send<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40 is-style-shadow\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"309\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-220-1024x309.png\" alt=\"\" class=\"wp-image-22458\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-220-1024x309.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-220-300x90.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-220-768x231.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-220-1536x463.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-220.png 1686w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Check (\u2714) the recipients you want to send emails to.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Emails will only be sent to rows where column G (email sent timestamp) is empty.<br>(This helps prevent duplicate sending to the same recipients.)<\/em><\/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>Click the &#8220;Send Emails&#8221; Button<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image is-style-shadow u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"306\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-222-1024x306.png\" alt=\"\" class=\"wp-image-22460\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-222-1024x306.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-222-300x90.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-222-768x230.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-222-1536x459.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-222.png 1686w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\">Emails will be sent in bulk to all checked recipients (each email is sent individually).<\/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>Email Sending Complete<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40 is-style-shadow\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"286\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-224-1024x286.png\" alt=\"\" class=\"wp-image-22462\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-224-1024x286.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-224-300x84.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-224-768x214.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-224-1536x428.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-224.png 1685w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-40 wp-block-paragraph\">After sending, the date and time of sending will be automatically recorded in column G.<br>Additionally, the background color will change to green to indicate that the email has been sent.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When you open Gmail, you will see the sent emails in the \u201cSent\u201d folder as a record.<\/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>(If Needed) Clear Data<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40 is-style-shadow\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"456\" height=\"276\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-226.png\" alt=\"\" class=\"wp-image-22464\" style=\"width:303px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-226.png 456w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-226-300x182.png 300w\" sizes=\"(max-width: 456px) 100vw, 456px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image is-style-shadow u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"763\" height=\"557\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-227.png\" alt=\"\" class=\"wp-image-22465\" style=\"width:429px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-227.png 763w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/image-227-300x219.png 300w\" sizes=\"(max-width: 763px) 100vw, 763px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Click the \u201cClear Data\u201d button to display clear options.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can choose to clear all data, or only clear the recipient checkboxes and sent timestamps.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is useful when reusing the template.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Notes<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list u-mb-ctrl u-mb-60 has-swl-pale-01-background-color has-background\">\n<li class=\"u-mb-ctrl u-mb-10\"><strong>Set Placeholders in Your Draft Email<br><\/strong>Insert placeholders in the email body that correspond to the columns in your spreadsheet.<br>If you don\u2019t need to use placeholders, you can use the template without them.<br>(Example: <code>{Meeting Date}<\/code> \u2192 The content of the \u201cMeeting Date\u201d cell in column D will be inserted.)<\/li>\n\n\n\n<li class=\"u-mb-ctrl u-mb-10\"><strong>Placeholders must exactly match the field names in your spreadsheet<\/strong><br>For example, cells D2, E2, etc. If there is any mismatch, the data will not be inserted correctly.<\/li>\n\n\n\n<li class=\"u-mb-ctrl u-mb-10\"><strong><strong>The draft subject in Gmail must exactly match<\/strong><\/strong><br>The subject you enter in the spreadsheet must match the subject of the draft in Gmail.<\/li>\n\n\n\n<li class=\"u-mb-ctrl u-mb-10\"><strong>Emails will not be sent to rows with a timestamp in column G, even if the recipient is checked<br><\/strong>This setting helps prevent accidental resending to recipients who have already received the email.<\/li>\n\n\n\n<li class=\"u-mb-ctrl u-mb-10\"><strong>Be aware of Gmail\u2019s daily sending limit<br><\/strong>(About 500 emails per day for free accounts.)<\/li>\n\n\n\n<li class=\"u-mb-ctrl u-mb-10\"><strong>Check your email with a test send<\/strong><br>Before actual use, please send a test email to your own test address to confirm that the email body and merge fields are working as intended.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-40\" id=\"download\">Download the Template Here<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You can copy the completed template from the link below (Google Sheets).<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-30 wp-block-paragraph\">By using this template, you can skip the setup process and start sending emails right away.<\/p>\n\n\n\n<div class=\"wp-block-codoc-codoc-block\"><div class=\"codoc-entries\" data-without-body=\"1\" id=\"codoc-entry-L14rTtLqBw\"  data-entry-button-text=\"\u8cfc\u5165\u3059\u308b\" data-support-button-text=\"\u30c1\u30c3\u30d7\u3067\u5fdc\u63f4\u3059\u308b\" data-support-message=\"\u4eca\u5f8c\u3082\u696d\u52d9\u52b9\u7387\u5316\u306b\u5f79\u7acb\u3064\u60c5\u5831\u3092\u63d0\u4f9b\u3057\u3066\u307e\u3044\u308a\u307e\u3059\u3002\u3054\u652f\u63f4\u3044\u305f\u3060\u3051\u308b\u3068\u5b09\u3057\u3044\u3067\u3059\u3002\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>[Contact Us Here] The template introduced in this article is a paid product. Have you ever wanted to send bulk [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":22470,"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=19841","footnotes":""},"categories":[12],"tags":[],"class_list":["post-22446","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\/22446","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=22446"}],"version-history":[{"count":6,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/22446\/revisions"}],"predecessor-version":[{"id":22472,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/22446\/revisions\/22472"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media\/22470"}],"wp:attachment":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media?parent=22446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/categories?post=22446"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/tags?post=22446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}