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

If you regularly send customer letters, invitations, marketing communications or other personalised documents, creating each one individually can take a considerable amount of time.

A mail merge in Google Docs can make the process much quicker.

Mail merge allows you to take information from a contact list or spreadsheet and use it to create multiple personalised documents. Instead of manually changing names, addresses and other details for every recipient, much of the process can be automated.

In this guide, we’ll explain how to create a mail merge in Google Docs, the benefits of using one and, importantly, the data checks you should carry out before sending your documents to print.

What is a mail merge?

A mail merge combines a standard document with a source of personalised data.

For a typical postal mailing, you’ll need:

Your main document – the Google Docs document containing the letter, message and design that will remain largely the same for every recipient.

Your recipient data – usually stored in Google Sheets and containing information such as names, company names and postal addresses.

The mail merge process takes the relevant information from your spreadsheet and places it into designated areas of your document.

For example, instead of manually creating:

Dear Sarah,

you could create a personalised field for the recipient’s first name. When the merge is completed, each document is automatically populated with the relevant person’s details.

Why use mail merge in Google Docs?

Save time

One of the biggest benefits of mail merge is the amount of administrative time it can save.

Imagine you need to send a personalised letter to 500 customers.

Rather than creating 500 separate documents and manually changing each name and address, you can create your document once and use your recipient data to generate the personalised versions.

For regular or larger mailings, those time savings can quickly add up.

Reduce repetitive data entry

Copying and pasting customer information between documents isn’t just time-consuming, it also increases the opportunity for mistakes.

Using information directly from a structured data source reduces the amount of manual data entry involved.

Your original data still needs to be accurate, however, which is why checking your spreadsheet before starting the merge is so important.

Personalise your communications

Mail merge makes it much easier to personalise communications at scale.

That might simply mean addressing each recipient by name, but you can potentially use additional data fields to personalise information such as their company, customer reference, renewal date, location or other relevant details.

Keep your documents consistent

Because every personalised document is based on the same Google Docs template, your core messaging and formatting can remain consistent throughout the mailing.

What do you need for a Google Docs mail merge?

Before you start, prepare two things:

1. A Google Docs document containing the letter or communication you want to personalise.
2. A Google Sheets spreadsheet containing your recipient information.

Depending on the Google Workspace features available to your account and the type of merge you’re carrying out, you may also need to use a compatible mail merge add-on or extension.

The exact process can therefore vary slightly depending on the method you choose, but the basic principle remains the same: your Google Sheet provides the data and your Google Doc provides the document template.

Step 1: Prepare your data in Google Sheets

Before creating your letter, we’d recommend getting your recipient data in order.

Ideally, each row should represent one recipient and each column should contain one type of information.

For example:

Keeping each piece of information in a separate column makes it easier to control how the information appears in your finished document.

Use clear column headings too. First Name, Surname and Postcode are much easier to work with than headings such as Column 1, Column 2 or internal abbreviations that someone else might not understand.

Step 2: Check and clean your mailing data

Don’t rush straight into creating the merge.

The quality of your finished mailing depends heavily on the quality of the data you put into it.

Check recipient names

Look for obvious spelling mistakes and inconsistencies.

Check that first names and surnames are in the correct columns and that titles such as Mr, Mrs, Ms or Dr are correct where you’re planning to use them.

Also look at capitalisation.

For example:

SARAH JONES

might not look as professional in a personalised letter as:

Sarah Jones

However, be careful when automatically changing capitalisation because people’s names don’t always follow standard formatting rules.

Check how recipients will be addressed

Decide how your greeting should appear.

For example:

Dear Sarah,

or:

Dear Ms Jones,

Then make sure you have the data needed to produce that greeting for every recipient.

If you’re planning to use first names, what happens when a record doesn’t contain one?

Identifying these exceptions before you start can prevent awkward greetings appearing in your finished mailing.

Check postal addresses

If you’re producing a physical mailing, address accuracy is particularly important.

Check that your records contain the required address information, including the building or house number, street, town or city and postcode.

Look for missing information, spelling errors and information that has accidentally been entered into the wrong column.

Check postcode formats

Review your postcodes for obvious inconsistencies.

Look for missing spaces, incomplete postcodes or formatting issues that may have occurred when information was imported from another database.

Look for duplicate recipients

Check whether the same individual or organisation appears more than once.

Duplicate records can result in someone receiving multiple copies of the same mailing, unnecessarily increasing your printing and postage costs.

Remove records that shouldn’t be included

Finally, make sure your mailing list contains only the recipients who should receive the communication.

Your organisation should also ensure that its use of personal data and mailing lists complies with its applicable data protection and marketing requirements.

Step 3: Create your document in Google Docs

Next, open Google Docs and create the document you want to personalise.

Add the content that will remain the same for everyone, such as your main message, headings, contact information and calls to action.

Leave space for the information that will change between recipients, including the recipient’s name and address.

For example, your address section might eventually contain fields representing:

First Name + Surname
Company
Address 1
Address 2
Town/City
County
Postcode

Step 4: Choose your Google Docs mail merge method

Unlike a traditional Microsoft Word mail merge, the exact Google Docs workflow can depend on your Google Workspace setup and the type of personalised documents you’re creating.

You may be able to use functionality available through Google Workspace or a third-party mail merge add-on that connects Google Sheets with Google Docs.

When choosing an add-on, check what access and permissions it requires before allowing it to access customer or business data.

Whichever method you use, you’ll normally need to select:

• The Google Sheet containing your recipient data
• The relevant worksheet or tab
• Your Google Docs template
• The fields that should be inserted into the document

Step 5: Add your personalised fields

Your mail merge tool will allow you to identify where information from Google Sheets should appear in the document.

For example, your letter might start with a personalised greeting using the First Name column.

Your address block might use several different fields from the spreadsheet.

The important thing here is to make sure each field is connected to the correct column in your Google Sheet.

A surname field accidentally connected to a company column could result in hundreds of incorrectly personalised documents.

Step 6: Preview your personalised documents

This is one of the most important parts of the process.

Don’t assume that because the first document looks right, every document will look right.

Preview a selection of recipients from throughout your data.

Check that names appear correctly, greetings make sense, addresses are complete and information is appearing in the correct location.

Pay particular attention to recipients with unusually long names, company names or addresses.

A short name might fit perfectly:

Sarah Jones

But a longer name or company name could unexpectedly wrap onto another line and change the positioning of the rest of your document.

Step 7: Check for blank fields

Missing information can cause unexpected gaps in your finished documents.

For example, some recipients may have an Address 2, while others won’t.

Make sure an empty Address 2 field doesn’t result in an awkward blank space within your address block.

The same applies to titles, company names and other optional information.

Testing different types of records before printing is the easiest way to identify these issues.

Step 8: Create a test mailing

Before producing your entire mailing, create a small sample.

Choose a range of recipients rather than simply using the first few rows of your spreadsheet.

Check the finished documents for:

• Correct names and greetings
• Complete addresses
• Correct postcodes
• Consistent fonts and formatting
• Unexpected blank spaces
• Long names or addresses
• Incorrect page breaks
• Text moving onto an additional page
• Incorrectly populated fields

If you’re using window envelopes, print a physical test and fold it exactly as the finished mailing will be folded.

Check that the recipient’s address sits correctly within the envelope window and that no other confidential or unwanted information is visible.

Step 9: Generate your final documents

Once you’ve checked your data, tested your merge and reviewed the results, you can generate the final personalised documents.

Depending on the mail merge method you’re using, these may be created as individual Google Docs, PDFs or another suitable format.

For a physical mailing, it’s worth carrying out one final check of the generated files before committing to the full print run.

A five-minute check at this stage could prevent hundreds or thousands of incorrectly personalised pages from being printed.

Google Docs mail merge checklist

Before sending your mailing to print, check:

☐ Recipient data has been cleaned and reviewed

☐ Duplicate records have been identified

☐ Names are correctly formatted

☐ Greetings work for different types of recipients

☐ Postal addresses are complete

☐ Postcodes have been checked

☐ Unwanted records have been removed

☐ Personalisation fields match the correct spreadsheet columns

☐ Blank fields have been tested

☐ Long names and addresses have been tested

☐ Several records from throughout the database have been previewed

☐ A sample has been printed

☐ Window envelope positioning has been checked where applicable

☐ Page breaks and page counts are correct

☐ The final generated documents have been reviewed

If the answer to all of these is yes, you’re in a much stronger position to start printing.

Make your next mailing easier

A Google Docs mail merge can take much of the repetitive work out of creating personalised documents.

By combining a well-prepared Google Sheet with a reusable document template, businesses can produce personalised communications much more efficiently, saving time while reducing unnecessary manual data entry.

But creating the documents is only one part of getting a mailing into your customers’ hands.

My Mailing Room can help with the wider mailing process, from data and printing through to fulfilment and postage.

Whether you’re preparing a customer communication, marketing campaign or regular business mailing, we can help turn your data and documents into a professionally produced mailing that’s ready to go.

Talk to the My Mailing Room team about your next mailing.