Using Mail Merge In Google Docs: Guide

Merge screenshot 5 672X420

This article is about Using Mail Merge In Google Docs: Guide. So read this free guide, Using Mail Merge In Google Docs: Guide step by step. If you have query related to same article you may contact us. So Lets begin this guide:

Guide: Using Mail Merge In Google Docs: Guide

When I was in school, the tech part of my brain was already thriving. But the school’s computer classes with MS Office never sparked my passion. Sure, they were useful things, something that would one day get us a job. Still, I hated it. The worst part was learning mail merge.

I tried in school, in college, and in the little time I spent in an accounting firm. It never worked the way I wanted it to. More importantly, I never “got it”. I now have a tremendous amount of respect for people who interact with the Office suite day in and day out, because believe me, it’s not easy.

As much as I hate MS Office’s implementation of mail merge, I get its appeal. It’s better than just sending a mass email with no personal greetings, and for some people, attitude up a newsletter for just one mass email might not be worth it. There is no reason why mail merge should not be part of your workflow / business life, but there are better ways to do it outside of the MS Office universe.

That is why I would like to tell you about an alternative that is intuitive, user-friendly and really works. It works as an add-on to Google Docs (sorry MS Office folks, but maybe it’s time to consider Google Drive’s online / offline productivity suite). The add-on comes from MailChimp, one of the best and easiest email newsletter services out there.

back to menu ↑

Step 1: Create a spreadsheet with recipient information

Before we start, go to, create a new spreadsheet and enter the details for your recipients in rows with the appropriate labels. Start with first name, last name and email. You can enter fields such as Address or anything else related to your work.

Screen shot 09 13 At 3 24 44 Pm

Once that’s done, close the tab and we’ll get to work with the actual email.

back to menu ↑

Step 2: Install Merge By MailChimp Add-on

Go to, create a new document, give it whatever name you want, go to Add-ons -> Download Add-ons and search for Merge by MailChimp. Download the add-on and wait a few seconds for it to install.

Screen shot 09 13 at 2 53 38 pm

back to menu ↑

Step 3: Create the email text

This is where you do what you need to do. Google Docs has many templates and add-ons to create attractive page layouts. Inserting charts, images and other multimedia is also quite easy.

back to menu ↑

Step 4: Merge The Mail

Once the email body is ready, go to Add-ons -> Merge by MailChimp -> Send Email. This activates a pop-up explaining the steps you need to take before you can send the email.

Screen shot 09 13 at 3 19 11 am

Now select the spreadsheet we created in step 1 in the chooser.

You will see a doll in the sidebar up analyzed and processed with your spreadsheet data.

Screen shot 09 13 At 3 26 26 Pm

It already knows what the header rows are, what the headlines are and more importantly, which row contains the emailYou are of course free to change the details if you wish.

back to menu ↑

Step 5: Customize a mail merge

Since this is a “mail merge” and not just a mass mail, you can do things like add the recipient’s first names at the top or anywhere in the document.

To do this, click on Merge tags button from the sidebar. This generates a tag for each row.

Screen shot 09 13 At 3 54 56 Pm

Now select where in the document you want to insert the corresponding data and click on the tag button (e.g. First name). Do this for all necessary elements.

back to menu ↑

Step 6: Add and send sender info

In the Email Info tab, enter the sender’s name, sender’s email address, email subject line, and company name and address in the footer.

Screen shot 09 13 At 3 59 23 Pm

Screen shot 09 13 at 4 16 59 hrs

Click Send Email and your personalized mass email is on its way. Easy, isn’t it?

Screen recording 09 13 at 4 17 30 hrs

Now that the email has been sent, you can track its progress and see how many of them have been opened from the Reports option in the Add-ons section. With this add-on you can send up up to 6000 emails per month. Since you are using the services of an established newsletter company to send the email, this will also happen feature an “Unsubscribe” link and a MailChimp logo at the bottom.

back to menu ↑

Using Mail Merge In Google Docs: Guide: benefits

  • The Using Mail Merge In Google Docs: Guide tutorial is free .
  • This guide already helps so many users follow up with interest in a timely manner.
  • The price of the Using Mail Merge In Google Docs: Guide guide is free.

back to menu ↑


Tutorial summary of Using Mail Merge In Google Docs: Guide

In this guide, we told you about the Using Mail Merge In Google Docs: Guide; please read all steps so that you understand Using Mail Merge In Google Docs: Guide in case if you need any assistance from us, then contact us.

How this tutorial helping you?

So in this guide, we discuss the Using Mail Merge In Google Docs: Guide, which undoubtedly helps you.

What is actual time in which this method complete?

The time to complete the Using Mail Merge In Google Docs: Guide tutorial is 10+ minutes.

What are the supported Device?

PC Laptop or Desktop

back to menu ↑

Final note

I hope you like the guide Using Mail Merge In Google Docs: Guide. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.

For our visitors: If you have any queries regards the Using Mail Merge In Google Docs: Guide, then please ask us through the comment section below or directly contact us.
Education: This guide or tutorial is just for educational purposes.
Misinformation: If you want to correct any misinformation about the guide “Using Mail Merge In Google Docs: Guide”, then kindly contact us.
Want to add an alternate method: If anyone wants to add more methods to the guide Using Mail Merge In Google Docs: Guide, then kindly contact us.
Our Contact: Kindly use our contact page regards any help. You may also use our social and accounts by following us on Whatsapp, Facebook, and Twitter for your questions. We always love to help you. We answer your questions within 24-48 hours (Weekend off).
Channel: If you want the latest software updates and discussion about any software in your pocket, then here is our Telegram channel.