Mail merge emails, documents, letters and envelopes within Google Workspace ™. Create hundreds of documents with the best mail merge add-on for Google Docs ™ and Google Sheets ™.
Listing updated:April 11, 2024
Works with:
4M+
Overview
Easiest mail merge add-on to generate documents or letters, send emails and print envelopes. Export to PDF, Word or print right in Google Docs ™. Mail Merge for Google Docs ™ & Google Sheets ™ is free. No sign-up required. No advertising or watermarks.

It's the best way to mail merge documents within Google Workspace ™ (formerly G Suite ™). This mail merge add-on lets you send hundreds of personalized emails, letters, create envelopes from a mailing list or merge documents such as snail mail, reports, certificates & more! 
 
Let the Mail Merge Wizard guide you to create merged documents in Google Docs ™ from a Google Spreadsheet mailing list. Mail Merge can be used as a mail merge add-on for Google Docs ™ or a mail merge add-on from Google Sheets ™. This is currently a free mail merge add-on. You can create and print as many documents, letters or envelopes as you want.

BEST MAIL MERGE

➤ Save time mailing out hundreds of letters or envelopes at once. Create letters and envelopes without copying and pasting information multiple times. 
➤ Transition to Google Drive ™ easily. Find all the features you were used to in Microsoft Word Mail Merge and Excel. Mail merge in Google Docs ™ is easier to use than MS Word Mail Merge and compensates for lack of a mail merge function in Google Docs ™ & Sheets. No more gymnastics with Word and Excel.
➤ You don’t need any computer skills! Mail merge doesn’t have to be a struggle. If you are looking for an easy mail merge in Google Docs ™ that will let you merge documents in minutes, you’ve found it!

SUPPORT

Need a helping hand? Join our forum and ask your questions:

➢ https://groups.google.com/g/mail-merge-documents

You’ll also find useful guides to get started: 
- How to mail merge documents in Google Docs ™
- How to create a mail merge from a Google Sheets ™ spreadsheet
- What are the different types of mail merge
- How to use merge fields in Google Docs ™
- How to write bulk letters using mail merge

If you find bugs or have improvements to suggest, share them on the Google forum: https://groups.google.com/g/mail-merge-documents

LEAVE US A REVIEW

If you enjoy using Mail Merge for Google Docs ™, please leave us the best constructive review! Your feedback is much appreciated.

******************************

WHAT IS MAIL MERGE

Mail Merge lets you create a batch of documents that are personalized for each recipient. For example, a form letter might be personalized to address each recipient by name. A data source, like a Google Sheets ™ spreadsheet is associated with the document. Placeholders--called merge fields--tell Google Docs ™ where in the document to include information from the data source. That way, it’s possible to mail merge emails, letters, envelopes or labels.

HOW DO I CREATE A MAIL MERGE DOCUMENT IN GOOGLE DOCS ™?

1. Open Google Docs ™ (https://docs.new)
2. Create a template document. For example, create an empty invoice template or a student grade report.
3. Click on the Mail Merge button in the sidebar on the right
4. Choose the document type (letters, envelopes, labels, emails)
5. Select recipients. In the sidebar, choose which spreadsheet you want to pull data from
6. Insert merge fields to personalize each document
7. Generate your documents
8. Download your documents as Docs, PDF or Word

HOW DO I CREATE A MAIL MERGE FROM A GOOGLE SHEETS™ ?

It’s quite the same as mail merging documents from Google Docs ™. Let’s see how to merge data from Google Sheets ™ to Google Docs ™: 

1. Open Google Sheets ™ (https://sheets.new)
2. Click on the Mail Merge button in the sidebar on the right
3. Choose the document you want to merge. Make sure to create a template document beforehand. For example, create an empty invoice template or a student grade report in Google Docs ™.
4. Choose the document type (letters, envelopes, labels, emails). The recipients will be the people listed in your current tab in Google Sheets ™.
5. Generate your documents
6. Download your documents as Docs, PDF or Word

Why use Mail merge for Google Docs over Yet Another Mail Merge (YAMM), Gmass, Mail Merge with Attachments, Mailmeteor?

******************************

PRICING

Mail merge is currently a free mail merge for Google Docs ™. 

******************************

TEMPLATES

Mail merge comes with examples of mail merge letters you can use. Here are some templates we are working on:
- Birthday invitation template in Google Docs ™
- Form letter template in Google Docs ™
- Resume template in Google Docs ™
- Annual report template for Google Docs ™
- Certificate template for Google Docs ™
- Google Docs ™ templates for students
- Google Docs ™ templates for teachers

If you are looking for more mail merge document templates, please let us know:
https://groups.google.com/g/mail-merge-documents

******************************

TYPES OF MAIL MERGE

You can use Mail Merge app to perform various types of mail merge:
➤  Mail merge Letters: create individual letters or snail mail letters from Google Sheets ™. Send hundreds of personalized letters and create multiple letters in a single go. Preparing letters in Google Docs ™ from Google Sheets ™.

➤ Mail merge Form Letters: apply merger name and address onto letters to create multiple letters with different names in Google Docs ™, or send marketing letters. Create a form letter in Word from Excel data and use it in Google Docs ™.

➤  Mail merge Individual Letters: generate individual Google Docs ™ with individual filenames, create individualized letters created from a database or mass producing unique letters. Mail merge letters into separate documents.

➤ Mail merge Documents: create customized documents from a Google Sheets ™ spreadsheet, make document writing from spreadsheet data, mail merge appointment forms, mail merge invoices, mail merge certificates, mail merge reports and more!

➤ Mail Merge Envelopes: mass printing envelopes designed in Docs, printing out directly onto envelopes for mailing out greeting and holiday cards.

➤ Mail Merge Labels: mail merge Avery Labels as well as labels from other vendors (Sheetlabels, Onlinelabels, Herma…)

******************************

USE CASES

Here are some of the many use cases of the Mail Merge add-on for Google:

★ Education

➤ Teachers parents communication: merge student names and teacher names onto documents, rather than handwriting or typing each one. Compose letters to students and parents, send personalized letters to parents & students. Personalized letters and school forms are a breeze with Mail Merge.
➤ Certificates & Awards: send formulating letters to lots of students, create permission letters for your students, generate certificates at the end of the school year.
➤ Grades Reports, Term Reports or Test Results: outputting exam documents from a large database of questions, answers and rationales.
➤ Application Forms: collect information from students and generate merged letters
➤ Student Details: gather details from your students and generate letters

★ Sales & Marketing

➤ Lead generation report: merges from spreadsheets into documents for mailing letters to prospects and clients
➤ Customer Order Forms, Customer invoices or Contracts: send out large number of letters out to your clients
➤ Brochures and catalog: sending Brochures Upon Request
➤ Labels: print return address labels
➤ Renewal letters: mail renewal letters at once 

★ Human Resources / Administration

➤ Training: Send Training program Invitations or Training Assessments 
➤ Employee management: generate Employee Stock Ownership Plan, Monthly Employee Reporting, Worksheets or Performance Review
➤ Contracts: generate contracts in a simple document
➤  Admin letters: for example, as a receptionist at an accounting firm you could use Mail Merge to send  mass emails and letters

★ Communication

➤ Thank You Letters
➤ Snail emails: sending correspondence via snail mail
➤ Invitations to Events and Webinars
➤ Registration Forms 
➤ Game & Tournament Announcements: sending prize codes to tournament winners down
➤ For clubs & association: send out form letters to your club with information from a Google Sheet ™
➤ Fundraising letters

★ Events & holidays

➤ Christmas letters and Christmas greeting cards: print out directly onto envelopes for mailing out Christmas card
➤ Thanksgiving cards
➤ New year greeting cards
➤ Wedding invitations: makes addressing your wedding envelopes fast and easy, saves you hours of handwriting envelopes for your relative’s wedding

★ For non-profit organizations: print a lot of envelopes for a non-profit you volunteer for or automate the tedious tasks within your organization thanks to Mail Merge.

★ Donor letters: mail merge letters to donors from your donor spreadsheet, quickly customize hundreds of donor letters! Generate non-profit donor statements or year-end donor letters.

★ Acknowledgement letters: mail merge acknowledgement letters, sending end of year tax acknowledgment letters to membership communications.

And many more...

➤ Send out mass emails/letters to tenants
➤ Use the merge to make a catalogue from a Google Sheet ™
➤ Let your VA merge to documents and emails
➤ Draft letters for supporters…
➤ Mail merge on Chromebook ™

Our users are:

- Businesses and professionals: large companies, small businesses, entrepreneurs
- Teachers, schools & universities 
- Associations, NGO & clubs
- And also startups, digital marketing agencies or consultancy groups… 

******************************

PRIVACY

Mail Merge is a Google Workspace add-ons that has successfully passed Google’s security review. The add-on requires minimal permissions to run. We do not transfer or sell any personal data. We never save the content of your template, generated documents, Google Sheets ™ or Google Forms’ data.

******************************

WEBSITE: https://mailmergedocs.com
SUPPORT: https://groups.google.com/g/mail-merge-documents
CONTACT US: https://groups.google.com/g/mail-merge-documents
Additional information
PricingFree of charge
Privacy policy
Terms of service
Mail merge for Google Docs ™ will ask for the permissions shown below. Learn more
Mail merge for Google Docs ™ will need access to your Google account
This will allow Mail merge for Google Docs ™ to :
See, edit, create, and delete all your Google Docs documents
See, edit, create, and delete only the specific Google Drive files you use with this app
See, edit, create, and delete all your Google Sheets spreadsheets
Send email on your behalf
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Karen Gimnig Nemiah
July 29, 2024
This app should be so simple, and it did eventually do the job for me, but so much frustration. First, the instructions to click on the icon in the side panel refer to a side panel that is not visible until you tell it to be by clicking on a barely noticeable arrow in the lower right of the screen. Big thing to miss. Then, when I first tested the merge it deleted everything that was bulleted. Big flaw. I had to reformat my whole document. Too much frustration for something that is supposed to be time-saving.
Is this review helpful?
Yes
No
Profile Picture
DMF Committee
July 24, 2024
It works in a fashion but if the template has numbered paragraphs they are deleted during the merge meaning the finished letters are missing chunks of text. Not great and could be overlooked. NEEDS FIXING - this was reported a year ago. Still not fixed. The "send emails" option does NOT work. It sends emails without asking where they are to go and without adding all the mail merge fields.
Is this review helpful?
Yes
No
Profile Picture
Doug Marty
July 2, 2024
Seems pretty buggy to me. This is the first time I am trying to do a merge in Google, I always used MS before. The merge is dropping my letterhead (header), as well as five, numbered, paragraphs. I also don't see how I can access a template, which is already defined in Google Docs. We'll see if technical support helps, if so, I will update this review
Is this review helpful?
Yes
No
Profile Picture
Tien Tran
August 17, 2024
For me, very easy to use; however the add-on crashed (may be due to my computer). After restarting my computer, it works very well.
Is this review helpful?
Yes
No
Profile Picture
Eric Aguilera
March 1, 2024
I have been tying to figure out what was wrong with my google doc and google sheet as I kept getting an error message. But it turns out that I am not the only one. I'm also getting the same error as everyone else: We could not merge your document. This might happen when your document is too heavy or has too many formatting's applied. Please edit your document and try again. Looks like its broken and they don't have any support so who knows if it will ever be fixed. It was working great for the past year, up until a couple of days ago, I hope they will get the issue resplved.
Is this review helpful?
Yes
No
Profile Picture
David Scott
February 6, 2024
Given the reviews, I had low expectations. Yes, it probably doesn't work for big mailing lists. Yes, it refused to accept any of the image types I tried to insert in the template. Also, I'm not using it to send emails. I just wanted to use data I collected in a Google form and then create nicer-looking final documents according to a template in Google Docs. It does that perfectly well and lets me export them as a pdf; even better! However, after working with the extension for a few days on my laptop and Android tablet (you have to use the browser version of Google Docs from a tablet, not the Google Docs app), I am now unable to install this extension on my wife's Google Docs account. The website just keeps giving a 404 error. Is the website down today? Oh, and I'm also now nervous that the Google Groups support is blocked because of "spam, malware, or malicious content." I can believe that this might be the result of users expressing frustration, but I really hope I didn't install malware! Getting the Google group support page fixed and available again would give me greater peace of mind! Otherwise, I may need to uninstall and find something else.
Is this review helpful?
Yes
No
Profile Picture
Rachela Fey
March 2, 2024
I have used this for over a year for work and it has worked perfectly -- UP UNTIL NOW!! For the past week, any document I've tried to merge keeps telling me the same error, regardless of the size or formatting of my documents (mind you it won't even merge 5 lines). Message: "OH SNAP! We could not merge your document. This might happen when your document is too heavy or has too many formattings applied. Please edit your document and try again." I wish there was someone to speak to or some sort of support team that would fix this app because it's really essential. It's clearly something very wrong with the app.
Is this review helpful?
Yes
No
Profile Picture
A User of Mail merge for Google Docs ™
August 14, 2024
It's a good tool, but it should have the option to schedule. And there should be an option to set a delay for sending emails in seconds and also be trackable within Google Sheets along with the emails.
Is this review helpful?
Yes
No
Profile Picture
Elizabeth Bohannon
March 12, 2024
I have been experience an inability to merge ANY document since about the beginning of March. There is no ability to file a complaint for this broken down code/function within the Google system. Please fix this, as it makes this program essentially obsolete.
Is this review helpful?
Yes
No
Profile Picture
Haley Brown
January 8, 2024
Barely works! When creating an email mail merge you have to ensure the tab/sheet name is no more than 5 characters or you'll receive the Add-on error saying "Something went wrong when executing add-on" or an error message saying "Oops! Try again" to preview the email. When using the letter mail merge, there is a chance you will receive the Add-on error so you have to wait 24 hours for it to work again and it may only work once. Google - FIX THIS!!
Is this review helpful?
Yes
No
1-10 of 189
Search
Clear search
Close search
Google apps
Main menu