How to do a mail merge in Google Docs & Sheets

Mail merge allows you to personalize a document for different recipients.

Google Docs currently lacks a mail merge feature. But thanks to the free Mail Merge Letter Generator, you can create a mail merge letter with Google Docs!

How to do a mail merge in Google Docs and Sheets

How to do a mail merge with Google Docs & the
Mail Merge Letter Generator

To mail merge your document, simply prepare it in Google Docs and personalize it using the Mail Merge Letter Generator. Afterwards, you can download your mail merge letter for free or send it directly to all recipients by post.

Preparation

Create a non-personalized document in Google Docs

Create your document as usual in Google Docs. The document should not contain any personalized elements such as an address or salutation. You’ll insert these later using the Mail Merge Letter Generator.

Save your document as a PDF via File → Download → PDF.

Preparation

Create a data source in Google Sheets

Next, insert your recipient data in a Google Sheet. You can also use a similar tool such as Excel. In the first row of the table, insert a column title that will later be used to assign the personalized data.

Choose File → Download → Comma Separated Values (.csv), to download the data as a CSV file.

Step 1

Upload your document as PDF to the Mail Merge Letter Generator

Now you can start using the free Mail Merge Letter Generator. In the first step, upload your non-personalized document as a PDF and click "Next".

Go to the Mail Merge Letter Generator

Step 2

Upload data source as CSV

In the next step, upload the CSV file containing your recipient data to the Mail Merge Letter Generator. After the upload, you can assign table columns to fields for personalization.

Afterwards, you’ll receive an overview of all the imported recipient data. You can easily add, remove or edit the recipient data.

Personalize the mail merge letter individually

Step 3

Personalize your document

Now it’s time to personalize your document. The address and the salutation are automatically placed in the letter. Of course, you can adjust the personalization any way you want and add new fields in the document via drag & drop.

You can also adjust the font and font size to suit the layout of your letter.

Step 4

Mail merge letter preview

The Mail Merge Letter Generator provides a preview for each recipient. This lets you check that all the addresses are in the right place.

Download the mail merge letter free of charge

Download mail merge letter free of charge

Step 5

Merge data with your document

Now you can generate your mail merge letters. All the letters will be combined into one continuous PDF. By clicking the "Download mail merge letter" button, you can download your mail merge document for free.

Send your mail merge letter as a physical letter

The Mail Merge Letter Generator is integrated with Pingen, an online postal service, so you can send your personalized documents directly via the Mail Merge Letter Generator. All documents are automatically printed at the highest quality and sent as physical letters at attractive prices.

Learn more about Pingen