{"id":39732,"date":"2022-04-29T12:35:48","date_gmt":"2022-04-29T10:35:48","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=39732"},"modified":"2025-12-17T23:37:57","modified_gmt":"2025-12-17T22:37:57","slug":"fusion-de-courrier-google-docs","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/how-to-solve-with-sheetgo\/mail-merge-google-docs\/","title":{"rendered":"Comment r\u00e9aliser une fusion de courriers \u00e0 partir de Google Docs ?"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]A mail merge can be an extremely useful tool for the majority of businesses in order to streamline processes for maximum efficiency. Although there are many mail merge software available, these are often quite expensive. Did you know that there is an even easier way to create a mail merge with the tools you already have? You can create a mail merge using Google Docs!<\/p>\n<p>Finding a way to create a mail merge directly using Google Docs is a very useful thing for many business processes. Whether you\u2019re sending personalized letters to recipients, or private contracts to new employees, a mail merge allows you to bulk send customized emails in a matter of minutes, without sacrificing a high standard of work.<\/p>\n<p>In this article, let\u2019s explore the ways you can create a mail merge from Google Docs, and why creating a mail merge from Google Sheets may be a better alternative for your business for a more straightforward, customizable, and effective way to send personalized emails in bulk.[\/et_pb_text][et_pb_text module_id=&#8221;from&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to create a mail merge from Google Docs<\/h2>\n<p>Unlike Microsoft Word, Google Docs does not have a native mail merge feature. This means that in order to create a mail merge using Google Docs, you must combine it with other features and tools.<\/p>\n<p>There are two main ways you can create a mail merge using Google Docs:<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<ol>\n<li><b>Coding:<\/b> If you have sufficient experience in coding, you can use <a href=\"https:\/\/developers.google.com\/apps-script\" target=\"_blank\" rel=\"noopener\">Google Apps Script<\/a> or <a href=\"https:\/\/developers.google.com\/docs\/api\/samples\/mail-merge\" target=\"_blank\" rel=\"noopener\">Google Docs API<\/a> to create your mail merge.<\/li>\n<li><b>Third-party add-ons:<\/b> You can use apps from the Google Workspace platform that allow you to create a mail merge from Google Docs. These include add-ons such as <a href=\"https:\/\/workspace.google.com\/marketplace\/app\/mail_merge_for_google_docs\/799434348782\" target=\"_blank\" rel=\"noopener\">Mail Merge for Google Docs<\/a>, <a href=\"https:\/\/workspace.google.com\/marketplace\/app\/g_merge_plus_mail_doc_merge_with_attachm\/650516967184\" target=\"_blank\" rel=\"noopener\">G Merge Plus<\/a>, <a href=\"https:\/\/workspace.google.com\/marketplace\/app\/autocrat\/539341275670\" target=\"_blank\" rel=\"noopener\">Autocrat<\/a> and <a href=\"https:\/\/workspace.google.com\/marketplace\/app\/smartsheet_for_google_docs\/306818934099\" target=\"_blank\" rel=\"noopener\">Smartsheet for Google Docs<\/a>.<\/li>\n<\/ol>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]With no native mail merge feature, there is an extremely limited number of ways to achieve a Google Docs mail merge. Unfortunately, the above methods of creating a mail merge using Google Docs are rather complex and require advanced coding skills. For most users, it\u2019s simply not worth the time, money or effort to use. We recommend that users should find an easy alternative.[\/et_pb_text][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Why you should mail merge from Google Sheets<\/h3>\n<p>Contrary to Google Docs, creating a mail merge from Google Sheets is a much more accessible, simple alternative that offers even more benefits. You can take each row of spreadsheet data and transfer it directly into your email, creating personalized emails ready to send to recipients.<\/p>\n<p>With Sheetgo, you can go one step further and automate the entire process. In just a simple workflow, Sheetgo allows you to create a mail merge via Gmail in 2 different ways &#8211; one also including your Google Docs!<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>1. Sending a mass email<\/h4>\n<p>Sheetgo allows you to create personalized mass emails directly within the online tool. You can create a custom workflow containing your spreadsheet full of custom data, and choose to generate an email template. Sheetgo turns each column of your spreadsheet into a smart tag &#8211; you can add these to your email template, and Sheetgo will substitute the tags with the dynamic data from your spreadsheet.<\/p>\n<p>As a result, you can send out hundreds of personalized emails in a matter of minutes, without having to use Google Docs.[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>2. Sending data from existing Google Doc<\/h4>\n<p>If you already have your content in an existing Google Doc, Sheetgo also offers a way for you to share this as a bulk email also. You can create a Google Doc template with your specific data, and send this as an attachment to recipients via Gmail.<\/p>\n<p>Simply connect your spreadsheet full of data to your Google Doc template. Sheetgo will transfer the dynamic data in your spreadsheet to the Doc template, and create a new Google Doc for each row of data.<\/p>\n<p>As a result, recipients will receive a personalized document as an attachment to the email.[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]Now that you understand the intelligent ways Sheetgo can create a mail merge, let\u2019s go through a step-by-step on how you can create a mail merge using Google Docs through Sheetgo.[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text module_id=&#8221;using&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How to create a mail merge using Google Docs<\/h3>\n<p>Finding a way to create a mail merge that uses Google Docs is extremely useful, especially when your content is already in a Google Doc, such as a letter.<\/p>\n<p>In this example, let\u2019s say I am head of HR for a school. I need to send out letters to parents about their children\u2019s student attendance. I already have the main content of the letter in a Google Doc, and all of the student attendance data in a Google Sheet.<\/p>\n<p>Using the Sheetgo online platform, I can create a workflow that connects these two files together, transfers the data into the Google Doc, converts the Doc to PDF (for security purposes), and then sends the Doc as an attachment via Gmail directly to each recipient &#8211; all automatically!<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 1: Sign up to Sheetgo<\/h4>\n<p>To sign up for Sheetgo, click on the button below. You can sign up using your Google, Microsoft, or Dropbox account.[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;SIGN UP FOR FREE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;30px||30px||true|false&#8221; custom_padding=&#8221;15px|20px|15px|20px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]To create a mail merge, you must be subscribed to the Individual or Business plan. Head to the <a href=\"https:\/\/www.sheetgo.com\/pricing\/\" target=\"_blank\" rel=\"noopener\">Sheetgo pricing page<\/a> for more details.[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 2: Prepare your spreadsheet and Docs template<\/h4>\n<p>You should have two different files ready to connect to a workflow:[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h5>1. Spreadsheet source data<\/h5>\n<p>Your spreadsheet should contain all of the dynamic data you would like to transfer to your document template.<\/p>\n<p>For example, my spreadsheet contains data about each student\u2019s attendance, including their name, percentage of attendance, number of sick days, etc. This will allow me to create personalized letters for each student.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/mailmerge-\u2013-1.png&#8221; alt=&#8221;mail merge google docs 0&#8243; title_text=&#8221;mailmerge \u2013 1&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<b>Important:<\/b> Make sure that each column has a clear header &#8211; this will become a Sheetgo Tag you can use to transfer this data to a specific place in your document template (see more below). Each new row of data will create a new document.[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h5>2. Document template<\/h5>\n<p>Your document template should contain the text you wish to have on all of your generated documents. Then, use the Sheetgo Tags (the headers of your spreadsheet columns) where you would like to transfer the dynamic data to. Don\u2019t forget to format each tag with double curly brackets &#8211; {{tag}} &#8211; for this to work.<\/p>\n<p>As you can see below, I have my letter template ready, with the main text typed out, and the smart tags where I want to add dynamic data.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/mailmerge-\u2013-2.png&#8221; alt=&#8221;mail merge google docs 1&#8243; title_text=&#8221;mailmerge \u2013 2&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 3: Create a new workflow<\/h4>\n<p>Now that your files are ready, it\u2019s time to create your workflow.<\/p>\n<p>First, head to the Sheetgo web app. In the Workspace, click <b>+New Workflow<\/b>.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/mailmerge-\u2013-3.png&#8221; alt=&#8221;mail merge google docs 2&#8243; title_text=&#8221;mailmerge \u2013 3&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]Under <b>Create a custom workflow<\/b> section, click <b>Create connection<\/b> from the new connection option.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/mailmerge-\u2013-4.png&#8221; alt=&#8221;mail merge google docs 3&#8243; title_text=&#8221;mailmerge \u2013 4&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 4: Connect your files<\/h4>\n<p>It\u2019s time to upload your files. Under <b>Select source<\/b> click on the <b>Single file<\/b> option to upload your spreadsheet.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/mailmerge-\u2013-5.png&#8221; alt=&#8221;mail merge google docs 4&#8243; title_text=&#8221;mailmerge \u2013 5&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]Click <b>+Select file<\/b> and search for your spreadsheet. You can change the storage folder on the left-hand side of the window. Once you locate your file, double click to upload it.<\/p>\n<p>In the dropdown below, select the spreadsheet tab where your data is located. Then, press <b>Next<\/b>.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/mailmerge-\u2013-6.png&#8221; alt=&#8221;mail merge google docs 5&#8243; title_text=&#8221;mailmerge \u2013 6&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]Next, scroll down to the <b>Generate<\/b> section and select <b>Documents<\/b>.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/mailmerge-\u2013-7.png&#8221; alt=&#8221;mail merge google docs 6&#8243; title_text=&#8221;mailmerge \u2013 7&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]Click <b>+Select file<\/b> and upload your document template. Below, you can edit the file names of the new documents you\u2019ll generate &#8211; in this example, I have renamed the files \u201c{{Student first name}}\u2019s attendance\u201d. You can also choose to add these new documents to a new or existing folder, and also change the folder name.<\/p>\n<p>In order to ensure that only one document is generated for each row of data in your spreadsheet (i.e. to avoid duplication), make sure that the <b>Check generated documents<\/b> button is activated.<\/p>\n<p>Once you\u2019re happy with your edits, click <b>Next<\/b>.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/mailmerge-\u2013-8.png&#8221; alt=&#8221;mail merge google docs 7&#8243; title_text=&#8221;mailmerge \u2013 8&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 5: (Optional) Generate PDF versions<\/h4>\n<p>Sheetgo not only allows you to directly send your Google Docs as attachments or access links, but also converts them to PDF automatically. This is a great option for those who have documents better suited to PDF for sharing, such as contracts, reports or invoices. This is because PDF is a universally compatible and more secure format &#8211; click on the following link to read more about converting Google Docs to PDF for more information.<\/p>\n<p>In order to convert your newly generated documents into PDF, under the <b>Generate<\/b> section click <b>PDF<\/b>.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/mailmerge-\u2013-9.png&#8221; alt=&#8221;mail merge google docs 8&#8243; title_text=&#8221;mailmerge \u2013 9&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]Here, you can choose whether to add PDF versions of your documents to a new or existing folder. You can also rename the folder and change its location within your storage files.<\/p>\n<p>Once finished, click <b>Next<\/b>.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/mailmerge-\u2013-10.png&#8221; alt=&#8221;mail merge google docs 9&#8243; title_text=&#8221;mailmerge \u2013 10&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 6: Share via Gmail<\/h4>\n<p>Now that you have your newly generated documents (and PDFs), you can prepare the mail part of the mail merge!<\/p>\n<p>Under the <b>Share<\/b> section, select <b>Gmail<\/b>.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/mailmerge-\u2013-11.png&#8221; alt=&#8221;mail merge google docs 10&#8243; title_text=&#8221;mailmerge \u2013 11&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]Firstly, select the way you want to send your documents using the dropdown menu under the Sending method section. You can choose from the following options:[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<ol>\n<li><b>Share files and send access links:<\/b> Send access links for your Google Docs for recipients to access the online file. Edit their permission level as either a Viewer or Editor.<\/li>\n<li><b>Add files as attachments:<\/b> Send Google Docs as a Word attachment or PDFs as an attachment, that recipients can download to access the file.<\/li>\n<\/ol>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/mailmerge-\u2013-12.png&#8221; alt=&#8221;mail merge google docs 11&#8243; title_text=&#8221;mailmerge \u2013 12&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]Next, add the email addresses of the recipients. Sheetgo gives you the option to either manually enter email addresses (Use custom recipients), or to transfer the email addresses located in your spreadsheet (Get dynamically from column).<\/p>\n<p>As I have the parent emails already in my spreadsheet. I can choose the <b>Get dynamically from column<\/b> option. In the dropdown menu, select the column where the email addresses are located. In this example, I will choose column A.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/mailmerge-\u2013-13.png&#8221; alt=&#8221;mail merge google docs 12&#8243; title_text=&#8221;mailmerge \u2013 13&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]Finally, you can change the subject of your email based on your needs.<\/p>\n<p>Once finished, click <b>Finish and save<\/b>.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/mailmerge-\u2013-14.png&#8221; alt=&#8221;mail merge google docs 13&#8243; title_text=&#8221;mailmerge \u2013 14&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;merge&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Google Docs mail merge<\/h3>\n<p>And there you have it! With Sheetgo, you can set up a mail merge using your Google Docs in a matter of minutes. From a simple spreadsheet, you can transfer your dynamic data into your Doc and send it as an attachment or access link to recipients &#8211; all automatically!<\/p>\n<p>After following these steps, you should be able to bulk email personalized documents that look something like this:<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/mailmerge-\u2013-15.png&#8221; alt=&#8221;mail merge google docs 14&#8243; title_text=&#8221;mailmerge \u2013 15&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span style=\"font-weight: 400;\">Alternatively, you can watch the video below to learn how to send personalized emails to multiple recipients.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_video src=&#8221;https:\/\/www.youtube.com\/watch?v=IgA8W20wpjg&#8221; _builder_version=&#8221;4.21.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; module_alignment=&#8221;center&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_video][et_pb_text module_id=&#8221;do&#8221; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How to do a mail merge from Google Docs<\/h3>\n<p>Looking to automate important document generation within your business processes? Why not check out our article on <a href=\"https:\/\/www.sheetgo.com\/blog\/business-processes\/contract-generator\/ \">How to create a contract generator in PDF and Gmail<\/a>?<\/p>\n<p>Alternatively, read more related blog posts below!<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A mail merge can be an extremely useful tool for the majority of businesses in order to streamline processes for maximum efficiency. Although there are many mail merge software available, these are often quite expensive. Did you know that there is an even easier way to create a mail merge with the tools you already [&hellip;]<\/p>\n","protected":false},"author":41,"featured_media":39734,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[33],"tags":[43],"class_list":["post-39732","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-solve-with-sheetgo","tag-sheetgo"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/39732","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=39732"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/39732\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/39734"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=39732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=39732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=39732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}