Mail merge in Google Sheets

Open your Google Sheet, connect a template, add tags to your document, and create multiple documents.
Get startedGoogle Workspace Logo
WIX LogoMarley Spoon LogoVeolia LogoRandstad LogoMotorola LogoAir Asia Logo

Mail Merge in Google Sheets

You can mail merge using Google Sheets in a few easy steps. It is simple to merge all kinds of different data stored in spreadsheets, including: images, gifs, dates, numbers and text in multiple languages. First you open your spreadsheet, then connect a Google Docs or Slides template, add tags to your template document and then click automate, and voila!, you’ve just mail merged!

We know how monotonous it can be to mail merge using complicated and unwieldy programs (or even having to write code!) That’s why we’ve come to the rescue.

With Portant you can open your spreadsheet, connect a template, 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 in Google Sheets

Google Sheets Icon

Open Spreadsheet

Open the spreadsheet you want to mail merge in.
Google Docs Icon

Connect template

Connect a Google Doc or Google Slides template
Portant Icon

Add Tags

Then just add 'column tags' into your spreadsheet
Google Drive Icon

Merge

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

'Mail merge in Google Sheets' tutorial

Eliminate laborious manual work

Mail merge in Google Sheets deletes laborious data entry from your life, saving you from the effort of retyping or copy & pasting the same text over and over again. A huge amount of time each year is spent on admin tasks, much of which could be automated. Mail merge in Google Sheets is one of the tools you can use 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 error free

Typos should be a thing of the past. With mail merge in Google Sheets, all data is sourced from your 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 in Google Sheets 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

How do I Mail Merge in Google Sheets?
Can I merge images?
How do I merge to pdf?
Can I combine multiple spreadsheet rows into one document?
Can I select which spreadsheet rows are merged?
Can I choose the folder to save the output documents in?
Can I automatically share the documents via email?

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 just mail merge

You can do a lot more than 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 startedAn animation showing a google document being created from a Trello card.