{"id":15693,"date":"2021-02-25T17:54:11","date_gmt":"2021-02-25T17:54:11","guid":{"rendered":"https:\/\/www.gmass.co\/blog\/?p=15693"},"modified":"2024-01-24T23:49:12","modified_gmt":"2024-01-24T23:49:12","slug":"mail-merge-google-docs","status":"publish","type":"post","link":"https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/","title":{"rendered":"How to Do Mail Merge Using Google Docs (Step-by-Step Guide)"},"content":{"rendered":"<p>A <a href=\"https:\/\/www.gmass.co\/blog\/mail-merge\/\"><b>mail merge<\/b><\/a> lets you quickly send a batch of personalized emails to a large email list.<\/p>\n<p>Often, you\u2019d use tools like <a href=\"https:\/\/www.gmass.co\/blog\/mail-merge-word\/\">MS Word and Excel<\/a> to perform a mail merge, but that\u2019s not the only option out there.<\/p>\n<p>You can also use the mail merge <b>Google Docs<\/b> approach.<\/p>\n<p>In this step-by-step guide, I\u2019ll show you <a id=\"this\" href=\"#howto\">how to create a mail merge using a Google Doc template<\/a>. I\u2019ll then explain <a href=\"#why\">why Google Docs isn\u2019t your best option to perform mail merges<\/a> and walk you through <a href=\"#easiest\">the simplest way to do a mail merge<\/a>!<\/p>\n<h2>Mail Merge Google Docs: Table of Contents<\/h2>\n<p>(Click on links to jump to specific sections)<\/p>\n<ul>\n<li><a href=\"#howto\">How to Perform a Mail Merge in Google Docs<\/a><\/li>\n<li><a href=\"#why\">Why Google Docs Isn\u2019t Ideal for Performing Mail Merges<\/a><\/li>\n<li><a href=\"#easiest\">The Easiest Way to Perform Mail Merges Today<\/a><\/li>\n<li id=\"howto\"><a href=\"#faq\">2 Mail Merge FAQs<\/a><\/li>\n<\/ul>\n<p>Let\u2019s get started.<\/p>\n<h2>How to Perform a Mail Merge in Google Docs<\/h2>\n<p>Before we dive into the mail merge Google Docs process, it\u2019s essential to know that <b>Google Docs doesn\u2019t have a native <\/b><b>mail merge<\/b><b> feature<\/b> \u2014 unlike Microsoft Word.<\/p>\n<p>As a result, there are three popular ways to do a <a href=\"#faq1\">mail merge<\/a> in Google Docs:<\/p>\n<ul>\n<li>Using the Google Docs API.<\/li>\n<li>Using Google Apps Script.<\/li>\n<li>Using a third-party add-on.<\/li>\n<\/ul>\n<p>If you\u2019re familiar with coding, you can use the Google Docs API or the Google Apps Script platform to create your mail merge.<\/p>\n<p>Otherwise, consider using a third-party add-on like Autocrat, Smartsheet Merge, or Avery Label Merge. These Google Workspace (formerly G Suite) apps let you create personalized Google Doc files by automatically inserting data from a Google Sheet or Google Form.<\/p>\n<p><b><i>Note: <\/i><\/b><i>There\u2019s<\/i><i> a<\/i> <i>more straightforward way<\/i> <i>to perform a <\/i><a href=\"https:\/\/www.gmass.co\/gmail-mail-merge\"><i>Gmail mail merge<\/i><\/a><i>. Instead of using a third-party tool <\/i><i>like Autocrat to <\/i><i>start mail merge<\/i><i>, <\/i><a href=\"#howtocreate\"><b><i>use Google Sheets with GMass<\/i><\/b><\/a><i>, the ultimate <\/i><i>mail merge<\/i><i> tool.<\/i><\/p>\n<p>However, whether you\u2019ll be using the Google Docs API, the Google Apps Script platform, or a third party add-on for your mail merge, you\u2019ll need the following:<\/p>\n<ol>\n<li>A Google Sheet (<b>data<\/b><b> file<\/b>) containing the data you want to merge into the document.<\/li>\n<li>A Google Doc (<b>main <\/b><b>document<\/b>) containing the letter or email template with placeholders to insert mail merge data.<\/li>\n<\/ol>\n<p>Now that you know what you\u2019ll need for a mail merge workflow, I\u2019ll go over how to perform a mail merge in the Google Docs web app using Autocrat:<\/p>\n<h3>A. Create the Data File and Main Document<\/h3>\n<p>Before using Autocrat, we need to create the data file and template document required for the mail merge process.<\/p>\n<p>Here are the steps involved:<\/p>\n<p><b>Step 1<br \/>\n<\/b>Create a Google Sheet containing the data you want to merge \u2014 this Google Sheet will be your <b>data<\/b><b> file<\/b>.<\/p>\n<p>Ensure that you include a header for each data column you\u2019ll use to <b>personalize <\/b>your Google Docs document. These headers can be anything, like <i>First name<\/i>, <i>Title<\/i>, <i>Company<\/i>, <i>Address<\/i><i>, <\/i>etc.<\/p>\n<p>For example, here\u2019s the Google Sheets data file I\u2019ve created:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18260\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-1024x320.png\" alt=\"Google sheet\" width=\"550\" height=\"172\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-1024x320.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-300x94.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-768x240.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-24x8.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-36x11.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-48x15.png 48w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet.png 1077w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p><b>Step 2<br \/>\n<\/b>Next, create your <b>main <\/b><b>document<\/b> \u2014 the file containing the message you\u2019ll send, with placeholders to insert your data.<\/p>\n<p>To do this, type your email body in a Google Doc and add merge tags to it.<\/p>\n<p><i>What is a merge tag?<br \/>\n<\/i>A merge tag is a <b>placeholder <\/b>where Autocrat will insert the data from your Google Sheet.<\/p>\n<p>To add merge tags, enter your column headings and enclose them within the <b>&lt;&lt; &gt;&gt;<\/b> symbols. An example of a merge field you could use is &lt;<i>&lt;First name&gt;&gt;<\/i>.<\/p>\n<p>Here\u2019s the template I\u2019ve created:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18261\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Template.png\" alt=\"Template\" width=\"550\" height=\"286\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Template.png 814w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Template-300x156.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Template-768x399.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Template-24x12.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Template-36x19.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Template-48x25.png 48w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<h3>B. Install Autocrat<\/h3>\n<p>Once your Google spreadsheet and Google document are ready, you need to install the Autocrat add-on.<\/p>\n<p>Follow these steps to install the add-on:<\/p>\n<p><b>Step 1<br \/>\n<\/b>Open the Google Sheet containing your data and click <b>Add-ons <\/b><b>&gt; <\/b><b>Get add-ons<\/b>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18262\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Get-add-ons.png\" alt=\"Get add-ons\" width=\"550\" height=\"235\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Get-add-ons.png 535w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Get-add-ons-300x128.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Get-add-ons-24x10.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Get-add-ons-36x15.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Get-add-ons-48x21.png 48w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p><b>Step 2<br \/>\n<\/b>Search for \u201cAutocrat\u201d in the Google Workspace Marketplace (formerly Google Apps Marketplace and later G Suite Market Place).<\/p>\n<p>Then, install the mail merge add-on, select your account, and grant necessary permissions to Autocrat.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18263\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-an-account.png\" alt=\"Choose an account\" width=\"509\" height=\"431\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-an-account.png 576w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-an-account-300x254.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-an-account-24x20.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-an-account-36x31.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-an-account-48x41.png 48w\" sizes=\"auto, (max-width: 509px) 100vw, 509px\" \/><\/p>\n<p><a href=\"#this\"><b>Go back to Contents<\/b><\/a><\/p>\n<h3>C. Use Autocrat to Perform the Mail merge<\/h3>\n<p>Here\u2019s how to use Autocrat to perform a mail merge:<\/p>\n<p><b>Step 1<br \/>\n<\/b>Select <b>Add-ons &gt; Autocrat &gt; Open <\/b>in your Google Spreadsheet file to launch Autocrat.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18264\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Open-button.png\" alt=\"Open button\" width=\"550\" height=\"256\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Open-button.png 570w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Open-button-300x139.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Open-button-24x11.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Open-button-36x17.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Open-button-48x22.png 48w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p><b>Step 2<br \/>\n<\/b>Once Autocrat has launched, click <b>NEW JOB<\/b>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18265\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/New-job.png\" alt=\"New job\" width=\"550\" height=\"349\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/New-job.png 715w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/New-job-300x190.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/New-job-24x15.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/New-job-36x23.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/New-job-48x30.png 48w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p><b>Step 3<br \/>\n<\/b>Provide a name for the merge job, and press<b> Next<\/b>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18266\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Next-button.png\" alt=\"Next button\" width=\"550\" height=\"351\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Next-button.png 712w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Next-button-300x191.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Next-button-24x15.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Next-button-36x23.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Next-button-48x31.png 48w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p><b>Step 4<br \/>\n<\/b>From the <i>Choose <\/i><i>template<\/i> window that opens, click <b>From drive<\/b>, choose your main document from your Google Drive, and click <b>Next<\/b>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18267\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/From-drive-button.png\" alt=\"From drive button\" width=\"550\" height=\"356\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/From-drive-button.png 718w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/From-drive-button-300x194.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/From-drive-button-24x16.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/From-drive-button-36x23.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/From-drive-button-48x31.png 48w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p><b>Step 5<br \/>\n<\/b>You now need to link your source data (Google Sheet) to the template document (Google Doc).<\/p>\n<p>If the tags in your template document match the column names in your source data precisely, Autocrat will automatically map them. Otherwise, you\u2019ll need to map each merge tag to the corresponding column header manually.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18268\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/map-source-data.png\" alt=\"map source data\" width=\"550\" height=\"347\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/map-source-data.png 729w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/map-source-data-300x189.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/map-source-data-24x15.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/map-source-data-36x23.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/map-source-data-48x30.png 48w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>After verifying that the mappings are accurate, click <b>Next<\/b>.<\/p>\n<p><b>Step 6<br \/>\n<\/b>Enter the file naming convention you want to use for the mail merge documents.<\/p>\n<p>Here, I\u2019ve given the file name as <i>&lt;&lt;First name&gt;&gt; bill<\/i>. This way, the mail merge documents created will have personalized file names, making it easier to identify them.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18269\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/File-settings-tab.png\" alt=\"File settings tab\" width=\"550\" height=\"348\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/File-settings-tab.png 723w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/File-settings-tab-300x190.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/File-settings-tab-24x15.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/File-settings-tab-36x23.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/File-settings-tab-48x30.png 48w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>You can then save the merged document as a PDF or Google Docs file.<\/p>\n<p><b>Step 7<br \/>\n<\/b>Choose the folder where you want to save your merged docs and click <b>SAVE<\/b>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18270\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-folder.png\" alt=\"Choose folder\" width=\"550\" height=\"349\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-folder.png 721w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-folder-300x190.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-folder-24x15.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-folder-36x23.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Choose-folder-48x30.png 48w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p><b>Step 8<br \/>\n<\/b>Click the <i>play<\/i> button to start mail merge.<\/p>\n<p>Additionally, you can use the <i>pencil <\/i>button to edit the mail merge, the <i>eye <\/i>icon to preview it, and the <i>trashcan<\/i> button to delete it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18271\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Play-button.png\" alt=\"Play button\" width=\"550\" height=\"170\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Play-button.png 649w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Play-button-300x93.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Play-button-24x7.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Play-button-36x11.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Play-button-48x15.png 48w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>Once you\u2019ve run the job, your merged Google document would look something like this:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18272\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/merged-document.png\" alt=\"merged document\" width=\"550\" height=\"280\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/merged-document.png 633w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/merged-document-300x153.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/merged-document-24x12.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/merged-document-36x18.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/merged-document-48x24.png 48w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p><a id=\"why\" href=\"#this\"><b>Go back to Contents<\/b><\/a><\/p>\n<p>Now that you\u2019ve seen how to do a mail merge in Google Docs, I\u2019ll explain why you need a better way to do mail merges:<\/p>\n<h2>Why Google Docs Isn\u2019t Ideal for Performing Mail Merges<\/h2>\n<p>If you\u2019re used to performing a mail merge using an Excel spreadsheet and a Word document, you\u2019ll find that the mail merge process in Google Docs is more complicated.<\/p>\n<p><i>Why?<br \/>\n<\/i>It\u2019s because <b>Google Docs doesn\u2019t have native <\/b><b>mail merge<\/b><b> capabilities<\/b>.<\/p>\n<p>You\u2019ll need to use either the Google Docs API or a third-party tool like Autocrat, Avery Label Merge, or Smartsheet Merge.<\/p>\n<p>Not only are they complicated to use, but <b>they serve just one purpose<\/b>: <i>running a <\/i><i>mail merge<\/i>.<\/p>\n<p>You <b>can\u2019t<\/b> create email lists, analyze recipient engagements, or even automate follow-ups \u2014 all of which are essential for email outreach campaigns.<\/p>\n<p>For a far more straightforward and comprehensive mail merge solution, consider <a id=\"easiest\" href=\"https:\/\/www.gmass.co\/blog\/google-sheets-mail-merge\/\"><b>integrating Google Sheets with GMass<\/b><\/a>. Not only does GMass help you create effortless mail merges, but it can also handle almost any other aspect of email outreach.<\/p>\n<p><a href=\"#this\"><b>Go back to Contents<\/b><\/a><\/p>\n<h2>The Easiest Way to Perform Mail Merges Today<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18273\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Gmass-1024x503.png\" alt=\"Gmass\" width=\"750\" height=\"369\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Gmass-1024x503.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Gmass-300x147.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Gmass-768x377.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Gmass-1536x755.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Gmass-24x12.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Gmass-36x18.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Gmass-48x24.png 48w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Gmass.png 1919w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/p>\n<p><a id=\"howtocreate\" href=\"https:\/\/www.gmass.co\/\"><b>GMass<\/b><\/a> is an easy-to-use <b>mail merge<\/b><b> tool<\/b> that works <b>directly inside your <\/b><b>Gmail account<\/b>. Its advanced features have made it popular among employees in giants like Uber and Google, Twitter, and LinkedIn.<\/p>\n<p>Whether you\u2019re an email marketer, small business owner, or casual mail sender, the tool is perfect for you.<\/p>\n<h3>How to Create a Mail Merge with GMass<\/h3>\n<p>GMass\u2019 <a href=\"https:\/\/www.gmass.co\/blog\/google-sheets-mail-merge\/\">Google Sheets<\/a> integration lets you perform massive mail merges instantly.<\/p>\n<p>Here\u2019s how to do it:<\/p>\n<p><b>Step 1<br \/>\n<\/b>Download the <a href=\"https:\/\/chrome.google.com\/webstore\/detail\/gmass-powerful-mail-merge\/ehomdgjhgmbidokdgicgmdiedadncbgf\">GMass Chrome extension<\/a> and sign in with your Gmail account.<\/p>\n<p><b>Step 2<br \/>\n<\/b>Add the mail merge data to a Google Sheet and format it as plain text.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18274\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-1-1024x318.png\" alt=\"Google sheet\" width=\"550\" height=\"171\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-1-1024x318.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-1-300x93.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-1-768x239.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-1-24x7.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-1-36x11.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-1-48x15.png 48w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Google-sheet-1.png 1081w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p><b>Step 3<br \/>\n<\/b>Compose your email and then click the <i>GMass<\/i> button in the top right-hand corner of your Gmail draft.<\/p>\n<p>You <b>don\u2019t <\/b>need to add any placeholders here.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18275\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Gmass-button.png\" alt=\"Gmass button\" width=\"550\" height=\"507\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Gmass-button.png 753w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Gmass-button-300x276.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Gmass-button-24x22.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Gmass-button-36x33.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Gmass-button-48x44.png 48w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p><b>Step 4<br \/>\n<\/b>Click <b>From a <\/b><b>Google Sheet<\/b>, and from the drop-down menu that shows up, select the Google Sheets file you created earlier.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18276\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/From-a-google-sheet.png\" alt=\"From a google sheet\" width=\"550\" height=\"242\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/From-a-google-sheet.png 733w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/From-a-google-sheet-300x132.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/From-a-google-sheet-24x11.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/From-a-google-sheet-36x16.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/From-a-google-sheet-48x21.png 48w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>If you have multiple sheets in your spreadsheet file, choose the sheet you want to use for the mail merge.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18277\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Email-template-button.png\" alt=\"Email template button\" width=\"550\" height=\"240\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Email-template-button.png 832w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Email-template-button-300x131.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Email-template-button-768x335.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Email-template-button-24x10.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Email-template-button-36x16.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Email-template-button-48x21.png 48w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>Once done, click on <b>CONNECT TO <\/b><b>SPREADSHEET<\/b>.<\/p>\n<p><b>Step 5<br \/>\n<\/b>GMass will now <b>automatically <\/b>insert email addresses into your email\u2019s <i>To<\/i> field.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18278\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/To-field.png\" alt=\"To field\" width=\"550\" height=\"510\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/To-field.png 667w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/To-field-300x278.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/To-field-24x22.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/To-field-36x33.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/To-field-48x44.png 48w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p><b>Step 6<br \/>\n<\/b>Select the <b>downward-facing arrow<\/b> next to the<b> GMass<\/b> button to bring up the <i>Settings<\/i> window.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18279\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Arrow-button.png\" alt=\"Arrow button\" width=\"550\" height=\"283\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Arrow-button.png 664w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Arrow-button-300x155.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Arrow-button-24x12.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Arrow-button-36x19.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Arrow-button-48x25.png 48w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>Here, you can automatically create personalized emails, set up automated follow-ups, schedule mass emails to go out later, and more.<\/p>\n<p><b>Step 7<br \/>\n<\/b>To personalize your email, select the <i>Personalize<\/i> drop-down menu to view all column names in your spreadsheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18280\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Personalize.png\" alt=\"Personalize\" width=\"350\" height=\"311\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Personalize.png 385w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Personalize-300x266.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Personalize-24x21.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Personalize-36x32.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Personalize-48x43.png 48w\" sizes=\"auto, (max-width: 350px) 100vw, 350px\" \/><\/p>\n<p><b>Step 8<br \/>\n<\/b>Select the required column headings you want to add and then paste them at the right spots in your email.<\/p>\n<p>Remember to ensure that you include the corresponding placeholder for each mail merge field.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18281\" style=\"border: 1px solid #000000;\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Final-test-final.png\" alt=\"Final test final\" width=\"550\" height=\"508\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Final-test-final.png 649w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Final-test-final-300x277.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Final-test-final-24x22.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Final-test-final-36x33.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/11\/Final-test-final-48x44.png 48w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p><b>Step 9<br \/>\n<\/b>Once you\u2019re done, click the <b>GMass <\/b>button to send your merged emails \u2014 <b>it\u2019s that easy!<\/b><\/p>\n<p>However, performing a Gmail mail merge <b>isn\u2019t all<\/b> that GMass can do for you.<\/p>\n<p>Here are some more powerful GMass features:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.gmass.co\/blog\/mail-merge-personalization\/\"><b>Automatic Personalization<\/b><\/a><b>:<\/b> From simple <a href=\"https:\/\/www.forbes.com\/sites\/blakemorgan\/2020\/02\/18\/50-stats-showing-the-power-of-personalization\/\">email personalization<\/a> like automatically personalizing the subject line to fallback values and personalized <a href=\"https:\/\/www.gmass.co\/blog\/how-to-include-a-personalized-link-in-a-gmail-email-marketing-campaign\/\">links<\/a> and <a href=\"https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/\">attachments<\/a>, GMass takes care of it all.<\/li>\n<li><a href=\"https:\/\/www.gmass.co\/blog\/reports\/\"><b>Email <\/b><b>Analytics &amp; Reports<\/b><\/a><b>:<\/b> Analyze the performance of your emails using detailed reports showing the open rate, click rate, unsubscribe rate, and more.<\/li>\n<li><a href=\"https:\/\/www.gmass.co\/blog\/auto-follow-up-emails-until-reply\/\"><b>Automated Follow-ups<\/b><\/a><b>: <\/b>Keep sending automated follow-up emails to a recipient until they open your message, click on a link inside the email, or respond to it.<\/li>\n<li><a href=\"https:\/\/www.gmass.co\/blog\/new-feature-schedule-mass-emails\/\"><b>Scheduling<\/b><\/a><b>: <\/b>Schedule your emails to reach the recipient\u2019s inbox when they\u2019re most likely to respond.<\/li>\n<li><a href=\"https:\/\/www.gmass.co\/blog\/you-can-now-send-10000-emails-with-gmass-and-gmail\/\"><b>Bypass <\/b><b>Gmail<\/b><b>\u2019s<\/b><b> sending limits<\/b><\/a><b>:<\/b> Send up to 10,000 emails per rolling 24 hours \u2014 bypassing your account\u2019s sending limits. Moreover, GMass will automatically schedule all the emails you can\u2019t send today to be sent the next day.<\/li>\n<\/ul>\n<p>To start using this robust outreach tool, <a href=\"https:\/\/chrome.google.com\/webstore\/detail\/gmass-powerful-mail-merge\/ehomdgjhgmbidokdgicgmdiedadncbgf\"><b>download the <\/b><b>Google Chrome<\/b><b> extension for GMass<\/b><\/a> today and sign up for free with your Gmail or Google account.<\/p>\n<p><a id=\"faq\" href=\"#this\"><b>Go back to Contents<\/b><\/a><\/p>\n<p id=\"faq1\">Next, I\u2019ll go over a couple of commonly asked questions about mail merge:<\/p>\n<h2>2 Mail Merge FAQs<\/h2>\n<h3>1. What Is a Mail Merge?<\/h3>\n<p>A <b>mail merge<\/b> is used to create personalized emails or any other document at scale by using data from a spreadsheet or data file.<\/p>\n<p>Usually, the process requires two separate documents:<\/p>\n<ul>\n<li>The main document that you\u2019ll be sending out (like an email). This document will have placeholders for the data that will be added automatically during the mail merge.<\/li>\n<li id=\"faq2\">A data file containing the information you\u2019ll link to your main document. This file can be a spreadsheet, Google Doc, or Google Slide.<\/li>\n<\/ul>\n<p>At the end of the process, the mail merge would have combined the two documents into one personalized message.<\/p>\n<h3>2. How to Do a Mail Merge with Microsoft Word and Excel?<\/h3>\n<p>You can perform a mail merge using the Microsoft Word and Excel apps on your computer.<\/p>\n<p>This way, you can create multiple documents at once, like bulk invoices, customized mailing labels (or merge labels), and mass emails.<\/p>\n<p>To perform a mail merge with Excel, follow this process:<\/p>\n<ul>\n<li>Add your mail merge data into an Excel spreadsheet (data file).<\/li>\n<li>Type in your email or letter in a Word document (template file).<\/li>\n<li>Add the recipient list from your spreadsheet to the template document.<\/li>\n<li>Use the \u201cInsert Merge Field\u201d option to add mail merge data into your email or letter body.<\/li>\n<li>Preview results and finish the mail merge.<\/li>\n<\/ul>\n<p><b><i>Read my <\/i><\/b><a href=\"https:\/\/www.gmass.co\/blog\/mail-merge-word\/\"><b><i>step-by-step guide on performing a <\/i><\/b><b><i>mail merge<\/i><\/b><b><i> using MS <\/i><\/b><b><i>Excel<\/i><\/b><b><i> and <\/i><\/b><b><i>Word<\/i><\/b><\/a><b><i> for more info.<\/i><\/b><\/p>\n<p><a href=\"#this\"><b>Go back to Contents<\/b><\/a><\/p>\n<h2>Wrapping Up<\/h2>\n<p>While it\u2019s not impossible to perform a mail merge with a Google Docs template, the process is much more complicated than using Microsoft Word and Excel.<\/p>\n<p>Even though tools like Autocrat can help you to a certain extent, they\u2019re not an ideal solution \u2014 the process remains largely inconvenient, and you\u2019re limited in terms of what you can do.<\/p>\n<p>Fortunately, <b>GMass <\/b>offers you a more straightforward way to perform a mail merge and boost email marketing outcomes. From automatic email personalizing and follow-ups to detailed analytics and reporting, GMass is the only emailing tool you\u2019ll ever need.<\/p>\n<p><b><i>Why not <\/i><\/b><a href=\"https:\/\/chrome.google.com\/webstore\/detail\/gmass-powerful-mail-merge\/ehomdgjhgmbidokdgicgmdiedadncbgf\"><b><i>try out GMass\u2019 <\/i><\/b><b><i>Google Chrome<\/i><\/b><b><i> extension today<\/i><\/b><\/a><b><i> and perform massive <\/i><\/b><b><i>mail<\/i><\/b><b><i> merges with<\/i><\/b> <em><strong>ease?<\/strong><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A mail merge lets you quickly send a batch of personalized emails to a large email list. Often, you\u2019d use tools like MS Word and Excel to perform\u2026<\/p>\n","protected":false},"author":2,"featured_media":15943,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-15693","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mail-merge"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\r\n<title>How to Do Mail Merge Using Google Docs (Step-by-Step Guide)<\/title>\r\n<meta name=\"description\" content=\"Want to do a mail merge in Google Docs? This step-by-step guide with screenshots shows you how and highlights a better alternative.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to Do Mail Merge Using Google Docs (Step-by-Step Guide)\" \/>\r\n<meta property=\"og:description\" content=\"Want to do a mail merge in Google Docs? This step-by-step guide with screenshots shows you how and highlights a better alternative.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/\" \/>\r\n<meta property=\"og:site_name\" content=\"GMass Blog\" \/>\r\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/GmailMailMerge\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2021-02-25T17:54:11+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2024-01-24T23:49:12+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/02\/Featured-image-v2-how-to-do-a-mail-merge-using-Google-docs-140kb.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"1001\" \/>\r\n\t<meta property=\"og:image:height\" content=\"467\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"Ajay Goel\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@PartTimeSnob\" \/>\r\n<meta name=\"twitter:site\" content=\"@GMassForGmail\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ajay Goel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mail-merge-google-docs\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mail-merge-google-docs\\\/\"},\"author\":{\"name\":\"Ajay Goel\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\"},\"headline\":\"How to Do Mail Merge Using Google Docs (Step-by-Step Guide)\",\"datePublished\":\"2021-02-25T17:54:11+00:00\",\"dateModified\":\"2024-01-24T23:49:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mail-merge-google-docs\\\/\"},\"wordCount\":2010,\"commentCount\":19,\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mail-merge-google-docs\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/Featured-image-v2-how-to-do-a-mail-merge-using-Google-docs-140kb.png\",\"articleSection\":[\"Mail Merge\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mail-merge-google-docs\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mail-merge-google-docs\\\/\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mail-merge-google-docs\\\/\",\"name\":\"How to Do Mail Merge Using Google Docs (Step-by-Step Guide)\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mail-merge-google-docs\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mail-merge-google-docs\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/Featured-image-v2-how-to-do-a-mail-merge-using-Google-docs-140kb.png\",\"datePublished\":\"2021-02-25T17:54:11+00:00\",\"dateModified\":\"2024-01-24T23:49:12+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\"},\"description\":\"Want to do a mail merge in Google Docs? This step-by-step guide with screenshots shows you how and highlights a better alternative.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mail-merge-google-docs\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mail-merge-google-docs\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mail-merge-google-docs\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/Featured-image-v2-how-to-do-a-mail-merge-using-Google-docs-140kb.png\",\"contentUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/Featured-image-v2-how-to-do-a-mail-merge-using-Google-docs-140kb.png\",\"width\":1001,\"height\":467,\"caption\":\"how to do a mail merge using Google docs\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mail-merge-google-docs\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Do Mail Merge Using Google Docs (Step-by-Step Guide)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/\",\"name\":\"GMass Blog\",\"description\":\"Tips and tricks for sending mail merge and mass email campaigns directly from Gmail\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\",\"name\":\"Ajay Goel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g\",\"caption\":\"Ajay Goel\"},\"description\":\"Ajay is the founder of GMass and has been developing email sending software for 20 years.\",\"sameAs\":[\"https:\\\/\\\/twitter.com\\\/PartTimeSnob\",\"https:\\\/\\\/x.com\\\/PartTimeSnob\"],\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/author\\\/ajay-goel\\\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Do Mail Merge Using Google Docs (Step-by-Step Guide)","description":"Want to do a mail merge in Google Docs? This step-by-step guide with screenshots shows you how and highlights a better alternative.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/","og_locale":"en_US","og_type":"article","og_title":"How to Do Mail Merge Using Google Docs (Step-by-Step Guide)","og_description":"Want to do a mail merge in Google Docs? This step-by-step guide with screenshots shows you how and highlights a better alternative.","og_url":"https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/","og_site_name":"GMass Blog","article_publisher":"https:\/\/www.facebook.com\/GmailMailMerge\/","article_published_time":"2021-02-25T17:54:11+00:00","article_modified_time":"2024-01-24T23:49:12+00:00","og_image":[{"width":1001,"height":467,"url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/02\/Featured-image-v2-how-to-do-a-mail-merge-using-Google-docs-140kb.png","type":"image\/png"}],"author":"Ajay Goel","twitter_card":"summary_large_image","twitter_creator":"@PartTimeSnob","twitter_site":"@GMassForGmail","twitter_misc":{"Written by":"Ajay Goel","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/#article","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/"},"author":{"name":"Ajay Goel","@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8"},"headline":"How to Do Mail Merge Using Google Docs (Step-by-Step Guide)","datePublished":"2021-02-25T17:54:11+00:00","dateModified":"2024-01-24T23:49:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/"},"wordCount":2010,"commentCount":19,"image":{"@id":"https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/02\/Featured-image-v2-how-to-do-a-mail-merge-using-Google-docs-140kb.png","articleSection":["Mail Merge"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/","url":"https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/","name":"How to Do Mail Merge Using Google Docs (Step-by-Step Guide)","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/#primaryimage"},"image":{"@id":"https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/02\/Featured-image-v2-how-to-do-a-mail-merge-using-Google-docs-140kb.png","datePublished":"2021-02-25T17:54:11+00:00","dateModified":"2024-01-24T23:49:12+00:00","author":{"@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8"},"description":"Want to do a mail merge in Google Docs? This step-by-step guide with screenshots shows you how and highlights a better alternative.","breadcrumb":{"@id":"https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/#primaryimage","url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/02\/Featured-image-v2-how-to-do-a-mail-merge-using-Google-docs-140kb.png","contentUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2021\/02\/Featured-image-v2-how-to-do-a-mail-merge-using-Google-docs-140kb.png","width":1001,"height":467,"caption":"how to do a mail merge using Google docs"},{"@type":"BreadcrumbList","@id":"https:\/\/www.gmass.co\/blog\/mail-merge-google-docs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gmass.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Do Mail Merge Using Google Docs (Step-by-Step Guide)"}]},{"@type":"WebSite","@id":"https:\/\/www.gmass.co\/blog\/#website","url":"https:\/\/www.gmass.co\/blog\/","name":"GMass Blog","description":"Tips and tricks for sending mail merge and mass email campaigns directly from Gmail","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.gmass.co\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8","name":"Ajay Goel","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g","caption":"Ajay Goel"},"description":"Ajay is the founder of GMass and has been developing email sending software for 20 years.","sameAs":["https:\/\/twitter.com\/PartTimeSnob","https:\/\/x.com\/PartTimeSnob"],"url":"https:\/\/www.gmass.co\/blog\/author\/ajay-goel\/"}]}},"_links":{"self":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/15693","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/comments?post=15693"}],"version-history":[{"count":23,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/15693\/revisions"}],"predecessor-version":[{"id":23916,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/15693\/revisions\/23916"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/media\/15943"}],"wp:attachment":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/media?parent=15693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/categories?post=15693"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/tags?post=15693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}