Mail merge in Google Sheets

Open your Sheet, connect a template, add tags to your document, and create multiple documents.
Get started
Google Workspace Logo
Trusted by over 3500 companies, including:
WIX LogoMarley Spoon LogoVeolia LogoRandstad LogoAir Asia Logo

Mail Merge with Google Sheets

You can mail merge using 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. After you've signed up to Portant, you click 'New workflow', then select a spreadsheet and connect a Google Docs or Slides template, add tags to your Google Docs template and then click 'Start automation', and voila!, you’ve just mail merged! (Personalized emails will be sent from your Gmail sent folder and Google Docs will be saved in your Google Drive.)

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

With Portant you can open your spreadsheet, connect a Google Doc or email template, click a few buttons and Google Docs will be magically generated and saved in your Google Drive. You can even send personalized emails from your gmail account. Just select the options you require and place your workflows on autopilot.

How to Mail Merge using Google Sheets

Google Sheets Icon
Select Spreadsheet
Open the spreadsheet you want to mail merge in.
Google Docs Icon
Connect template
Connect a Google Docs or Google Slides template
Portant Icon
Add tags
Then just add 'column tags' from your spreadsheet
Google Drive Icon
Merge
Merge to create Google Docs, Slides or emails

'Mail merge in Google Sheets' tutorial

Eliminate laborious manual work

Portant 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. Portant 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 Portant 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 (and even filed in the correct location in your Google Drive)

Built into Google Workspace

Mail merge with the Google Apps 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. Portant 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?
Does mail merge work with Google Sheets?
How do I do a mail merge using Google sheets for free?
Does Google have a mail merge?
What is the best mail merge for Google Sheets?
How do I make address labels in Google Sheets?
How do I setup a mail merge?
What are the six steps of mail merge?
How do you send a mail merge to multiple recipients?
Can you print mailing labels from Google Sheets?

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 startedAnimation of Portant workflow for operations