How to do a Mail Merge in Google Docs: A Step-by-Step Guide

Mail merges can be a lifesaver when you need to send out a bunch of personalized documents. Whether you’re sending out invitations, letters, or emails, a mail merge in Google Docs can help you get the job done quickly and efficiently. In a nutshell, you’ll be setting up a template in Google Docs and then linking it to a spreadsheet in Google Sheets that contains the personalized information for each recipient. Once set up, Google Docs will create a separate document for each recipient, filled with their individual information.

Step by Step Tutorial on How to Do a Mail Merge in Google Docs

Before we dive into the nitty-gritty of mail merges, let’s talk about why they’re so awesome. A mail merge lets you create a single document that you can then customize for each individual recipient. This can save you tons of time, especially if you’re dealing with a large number of recipients. Plus, it adds a personal touch that can make your recipients feel special.

Step 1: Create a Google Sheets Spreadsheet

Create a new spreadsheet in Google Sheets that includes all the personalized information you want to include in your documents.

In your spreadsheet, you’ll want to have a column for each piece of personalized information. For example, if you’re sending out letters, you might have columns for "First Name," "Last Name," and "Address." Make sure to give each column a clear header, as this will come in handy later on.

Step 2: Create a Google Docs Template

Create a new document in Google Docs that will serve as your template. Wherever you want personalized information to appear, insert a placeholder.

In your Google Docs template, you’ll be using placeholders for the personalized information. For example, you might write "Dear {{First Name}},” where {{First Name}} is the placeholder that will be replaced with each recipient’s actual first name. Make sure your placeholders match the headers in your Google Sheets spreadsheet exactly.

Step 3: Use an Add-on to Connect Google Sheets to Google Docs

Install an add-on for Google Docs that allows you to perform a mail merge, like "Autocrat," and use it to connect your spreadsheet to your document.

Once you’ve installed the add-on, you’ll need to run it and go through the process of linking your Google Sheets spreadsheet to your Google Docs template. This typically involves matching your placeholders to the corresponding columns in your spreadsheet.

Step 4: Run the Mail Merge

Use the add-on to run the mail merge, which will create individual documents for each recipient.

After you’ve set everything up, running the mail merge is as simple as clicking a button. The add-on will take care of creating a new Google Docs document for each recipient, with all the personalized information in place.

Step 5: Review and Send

Review the generated documents to make sure everything looks good, then print or email them as needed.

Before you send out your documents, it’s important to review them to ensure that all the personalized information has been inserted correctly. Once you’re happy with how everything looks, you can go ahead and print or email the documents.

After you complete the action of doing a mail merge in Google Docs, you’ll have a separate, personalized document for each recipient on your list. This can save you a ton of time and effort, especially if you’re dealing with a large number of recipients. Plus, personalized documents can make each recipient feel valued and special, which can be great for building relationships.

Tips for Doing a Mail Merge in Google Docs

  • Make sure your Google Sheets spreadsheet is well-organized, with clear headers for each column of personalized information.
  • Double-check that your placeholders in the Google Docs template match the headers in your spreadsheet exactly.
  • Preview the merged documents before sending them out to catch any errors.
  • If you’re sending emails, make sure you have permission to email the recipients to avoid spam issues.
  • Keep your Google Docs template simple to avoid formatting issues during the mail merge.

Frequently Asked Questions

What is a mail merge?

A mail merge is a process that allows you to create personalized documents for multiple recipients using a template and a data source, like a spreadsheet.

Mail merges are useful when you need to create many documents that are mostly identical but include some personalized information. For example, you might use a mail merge to send out personalized invitations to an event.

Can I do a mail merge in Google Docs without an add-on?

No, you’ll need to use an add-on like "Autocrat" to connect Google Sheets to Google Docs and run the mail merge.

Google Docs doesn’t have a built-in mail merge feature, so using an add-on is necessary. There are several add-ons available that can help you with this.

Can I use a mail merge to send emails?

Yes, you can use a mail merge to send personalized emails. You’ll need to include the recipients’ email addresses in your Google Sheets spreadsheet and use an add-on that supports email merges.

Sending personalized emails can be a great way to reach out to customers, clients, or friends with a personal touch.

What kind of information can I include in a mail merge?

You can include any kind of personalized information, such as names, addresses, dates, and more. Just make sure the information is organized in your Google Sheets spreadsheet.

The possibilities are nearly endless, as long as you have the personalized information available in your spreadsheet.

Can I use a mail merge for labels or envelopes?

Yes, you can use a mail merge to create personalized labels or envelopes. You’ll need to set up your template accordingly and include the necessary information in your spreadsheet.

This can be a huge time-saver if you’re sending out physical mail to a large number of recipients.


  1. Create a Google Sheets spreadsheet with personalized information.
  2. Create a Google Docs template with placeholders.
  3. Use an add-on to connect the spreadsheet to the template.
  4. Run the mail merge to create individual documents.
  5. Review and send the generated documents.


Mail merges can be a powerful tool for anyone needing to send out personalized documents or emails to a large group of people. Whether you’re a teacher sending out progress reports, a business sending out promotional materials, or an individual sending out party invitations, knowing how to do a mail merge in Google Docs can save you a ton of time and effort. The process is straightforward and can be easily mastered with a little practice. Plus, with the tips and answers to frequently asked questions provided in this article, you should be well on your way to becoming a mail merge pro. So go ahead, give it a try, and watch your productivity soar!