Mail merge in Google Docs

Select a Google Sheet, add tags to your document, and create multiple documents via mail merge.
Get started

Mail Merge in Google Docs

Google Docs has many features that allow you to create professional looking documents quickly. One feature that allows you to create customized letters, envelopes, flyers, and other documents is Mail Merge. This tutorial will teach you how to use Portant to perform a mail merge.  

We know how painful it can be to mail merge using complicated and unwieldy programs. That’s why we’ve come to the rescue so you can mail merge easily between Google Apps.

With Portant you can connect a Google Sheet, click a few buttons and a document will be magically generated from each row of data within your Google Sheet. You can then share a merged document via a customised email or export them as pdfs. Just select the options you require and place your documentation on mail merge autopilot.

How to Mail Merge using Google Docs

Add Spreadsheet

Select the Google Sheet your data is saved in.

Add tags

Click 'insert' to place merge fields in a Google Doc

Mail Merge

Then just hit the 'create' button

Save and Share

Save as .gdoc or .pdf and share via customised email

'Mail merge for Google Docs' tutorial

Eliminate unnecessary manual work

Mail merge with Google Docs removes manual data entry from your life, saving you the time and effort of retyping or copy/pasting between Google Apps. Some businesses spend up to 70 days per year on admin, much of which could be automated. Mail merge for Google Docs enables you to get back to the more important stuff.

An animation showing documents being created every time a new line is created in a spreadsheet.
An animation showing text and images being automatically placed inside a Google Presentation.

Make your documents more accurate

Typos should be a thing of the past. With Google Docs mail merge, all data is sourced from the original Google Sheet. This means you won’t have to worry about mistakes from copying and pasting or manual data entry between Google Apps. Plus, your formatting is guaranteed to be consistent on all your documents.

Built into Google Workspace

Mail merge with the Google Apps you already use - Google Docs, Google Sheets, Google Slides, Google Forms and Google Drive. Portant mail merge is integrated into the Google Workspace (G Suite), so it’s available on the platforms you’re comfortable with. Mail merge with Google Docs will help to turbo charge your workflows so you can hit all your goals.

Google Workspace Logo

Frequently asked questions

Can you do a mail merge on Google Docs?
How do I do a mail merge with Google Docs?
Can you do a data merge using Google Docs?
How do I do a mail merge with Google Sheets?
What are the Google platforms that are used to create a mail merge?
Can you make address labels in Google Docs?
Can you do mail merge with Google Slides?
What are the types of documents where you can use mail merge?
How do I add images?
How do I export to pdf?
Can I select the rows which are merged?
Can I select the folder where the documents are saved?
Can I automatically share the documents via email?
Can you export a Google Form to Docs?

What they say about Portant

Antoine A.
Veolia

StarStarStarStarStar

“Not only did Portant Data Merge perfectly met our requirements, but their customer support was also perfect.”

Jennifer C-T
Educator

StarStarStarStarStar

"Couldn't find an add on that would merge spreadsheet data to slides including photos and now I have. Also, amazing customer service"

Russel L.
consultant

StarStarStarStarStar

"Portant is going to be a game-changer. This add-on is powerful, intuitive and adaptable to a variety of uses"

Grégoire D.
systems engineer

StarStarStarStarStar

"Excellent team, great add-on. I found a small bug, submitted it: they corrected it within 5 minutes. I recommend."

Rachel G

StarStarStarStarStar

"Easy to use and a great team! I emailed a question and they got back to me so quickly! I will be using this program for all sorts of stuff!"

Anthony J.
Citrii

StarStarStarStarStar

“Super helpful add-on. Makes life easier, saves time and helps keep your focus on the important things.”

More than mail merge

You can do a lot more than just mail merge with Portant. Portant is a fully-fledged online document automation solution that can optimise many different document flows. You can use our online document automation platform to optimise your repetitive work, so you can get back to doing the work you enjoy.

Get startedAnimation of Portant workflow for operations
Most Popular Templates

Save hours of manual work in just a few clicks

Transform your work life with responsive, fully customizable, and easy-to-use templates.