{"id":15066,"date":"2023-07-25T13:21:34","date_gmt":"2023-07-25T06:21:34","guid":{"rendered":"https:\/\/gcloudvn.com\/?p=15066"},"modified":"2023-08-10T09:59:53","modified_gmt":"2023-08-10T02:59:53","slug":"google-sheets-now-integrated-with-mail-merge-in-gmail","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/google-sheets-now-integrated-with-mail-merge-in-gmail\/","title":{"rendered":"Google Sheets now integrated with mail merge in Gmail"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-sheets-now-integrated-with-mail-merge-in-gmail\/#Co_gi_thay_doi\" >What\u2019s changing<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-sheets-now-integrated-with-mail-merge-in-gmail\/#Ai_bi_anh_huong\" >Who\u2019s impacted<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-sheets-now-integrated-with-mail-merge-in-gmail\/#Tai_sao_lai_quan_trong\" >Why it\u2019s important<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-sheets-now-integrated-with-mail-merge-in-gmail\/#Thong_tin_them\" >Additional details<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-sheets-now-integrated-with-mail-merge-in-gmail\/#Bat_dau\" >Getting started<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-sheets-now-integrated-with-mail-merge-in-gmail\/#Rollout_pace\" >Rollout pace\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-sheets-now-integrated-with-mail-merge-in-gmail\/#Tinh_kha_dung\" >Availability<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Co_gi_thay_doi\"><\/span><b>What\u2019s changing<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Last year, we made it easier to send individual emails to many recipients with the launch of multi-send in Gmail, and introduced the ability to personalize multi-send emails with mail merge tags like @firstname and @lastname.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Today, we\u2019re excited to announce that mail merge will support Google Sheets in the web version of Gmail. This integration will allow you to link a Sheet with up to 1,500 recipients and use any data column from your Sheet as a mail merge tag.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-15074\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/mailmerge1.gif\" alt=\"Google Sheets has been integrated with Mail Merge in Gmail 1\" width=\"600\" height=\"572\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/mailmerge1.gif 512w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/mailmerge1-13x12.gif 13w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ai_bi_anh_huong\"><\/span><b>Who\u2019s impacted<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">End users\u00a0<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tai_sao_lai_quan_trong\"><\/span><b>Why it\u2019s important<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">With mail merge, you can send more engaging and personalized marketing emails to a wider audience from Gmail on the web.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Thong_tin_them\"><\/span><b>Additional details<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">With this update, mail merge will completely replace multiple sending. Google is also moving the mail merge icon from the main compose toolbar at the bottom of your email draft to the top right corner of the compose window. You can still use the mail merge feature without linking the Sheet, using the built-in merge tags: @firstname, @lastname, @fullname and @email.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Like multiple submissions, mail merge contains a unique unsubscribe link for each recipient by default. Recipients who unsubscribe from your emails are automatically excluded from future mail merges you send.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Bat_dau\"><\/span><b>Getting started<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Admins<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">For customers <a href=\"https:\/\/gcloudvn.com\/en\/google-workspace\/\">Google Workspace Enterprise Standard<\/a>, Enterprise Plus, Education Standard and Education Plus, by default, mail merge is restricted to internal recipients.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">For Google Workspace Business Standard and Business Plus customers, mail merge is available for external recipients by default.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">For all Google Workspace editions, you can turn mail merge ON for external recipients at the OU or Group level.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Visit the Help Center to learn more about <\/span><a href=\"https:\/\/support.google.com\/a\/answer\/173555\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">managing Gmail settings for your users<\/span><\/a><span style=\"font-weight: 400;\">, and customizing access policies for different organizational units or groups.\u00a0<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">End users\u00a0<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">To link your Sheet to a draft in Gmail:<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Turn on mail merge using the icon in the top-right corner of a new compose tab.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Click Add from a spreadsheet and select which Sheet you want to use for recipient data.<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"3\">The Sheet must contain at least one column of email addresses and one column with recipient names.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-15075\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/mailmerge2.png\" alt=\"Google Sheets has been integrated with Mail Merge in Gmail 2\" width=\"600\" height=\"218\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/mailmerge2.png 512w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2023\/07\/mailmerge2-18x7.png 18w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Note: Your recipient data must be in the first tab of the Sheet.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Note: Users are limited to 1,500 mail merge recipients or messages per day, and you can't use Cc or Bcc when recipients are added from a Sheet.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Next, you will see a Finish linking spreadsheet dialog:<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Choose the columns that contain recipients\u2019 email addresses and names.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To insert merge tags to your draft:<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Type \u201c@\u201d in your draft to show a list of available merge tags.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Every valid column in the first tab of your Sheet should be available as a merge tag.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Insert the desired merge tag by pressing Enter or by clicking on the tag.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Note: Merge tags can\u2019t be used in the subject line or in links.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Visit the Help Center to learn more about <\/span><a href=\"https:\/\/support.google.com\/mail\/answer\/12921167\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Mail Merge in Gmail<\/span><\/a><span style=\"font-weight: 400;\">.\u00a0<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Rollout_pace\"><\/span><b>Rollout pace\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on June 27, 2023<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on July 19, 2023<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tinh_kha_dung\"><\/span><b>Availability<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">For Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Standard customers, <a href=\"https:\/\/gcloudvn.com\/en\/google-workspace-for-education\/\">Education Plus<\/a> and Non-Profit Organization<\/span><\/li>\n<\/ul>\n<p class=\"p1\" style=\"text-align: justify;\">For more detailed product information or to need technical support, you can contact Gimasys - Premier Partner of Google in Vietnam at the following information:<\/p>\n<ul class=\"ul1\" style=\"text-align: justify;\">\n<li class=\"li2\"><b>Hotline:\u00a0<\/b>0974 417 099 (HCM) | 0987 682 505 (HN)<\/li>\n<li class=\"li3\"><span class=\"s3\"><b>Email:\u00a0<\/b><a href=\"mailto:gcp@gimasys.com\"><span class=\"s4\">gcp@gimasys.com<\/span><\/a><\/span><\/li>\n<\/ul>\n<p class=\"p4\" style=\"text-align: right;\"><b>Source: Gimasys<\/b><\/p>","protected":false},"excerpt":{"rendered":"<p>C\u00f3 g\u00ec thay \u0111\u1ed5i N\u0103m ngo\u00e1i, Google \u0111\u00e3 gi\u00fap vi\u1ec7c g\u1eedi t\u1eebng email \u0111\u1ebfn nhi\u1ec1u ng\u01b0\u1eddi nh\u1eadn tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n b\u1eb1ng vi\u1ec7c ra m\u1eaft t\u00ednh n\u0103ng g\u1eedi nhi\u1ec1u l\u1ea7n trong Gmail v\u00e0 gi\u1edbi thi\u1ec7u kh\u1ea3 n\u0103ng c\u00e1 nh\u00e2n&hellip;<\/p>","protected":false},"author":2,"featured_media":15076,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1,134],"tags":[],"class_list":["post-15066","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","category-google-workspace","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/15066","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=15066"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/15066\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/15076"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=15066"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=15066"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=15066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}