Mail merge in Google Docs

Add tags to your document, connect a spreadsheet and create multiple documents via mail merge.
Get started
Google Workspace Logo
Trusted by over 3500 companies, including:
WIX LogoMarley Spoon LogoVeolia LogoRandstad LogoAir Asia Logo

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, flyers, and other documents is Mail Merge. This tutorial will teach you how to use the tool.  

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

With Portant you can connect a spreadsheet, click a few buttons and documents will be magically generated. You can then share them via customised emails or export them as pdfs. Just select the options you require and place your documentation on autopilot.

How to Mail Merge using Google Docs

Google Sheets Icon

Add Spreadsheet

Select the spreadsheet your data is saved in.
Google Docs Icon

Add Tags

Click 'insert' to place tags in a Google Doc template
Portant Icon

Mail Merge

Then just hit the 'create' button
Google Drive Icon

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 copy/pasting or retyping. 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 spreadsheet. This means you won’t have to worry about mistakes from copying and pasting or manual data entry. Plus, your formatting is guaranteed to be consistent on all your documents.

Built into Google Workspace

Mail merge with the tools you already use - Google Docs, Sheets, Slides and Forms. Portant mail merge is integrated into the Google Workspace, 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
Google Slides Icon
Google Forms Icon
Google Sheets Icon
Google Docs Icon

Frequently asked questions

Can you do a mail merge on Google Docs?
How do I Mail Merge using Google Docs?
How do I add images?
How do I export to pdf?
Can I combine multiple rows into one document?
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?
Where are add-ons in Google Docs?
Can you export a Google Form to Docs?
Can you export a Google Form to Docs?

What they say about Portant

Antoine A.
Veolia

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

Jennifer C-T
Educator

"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

"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

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

Rachel G

"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

“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 started

Check out our most popular workflows