The #1 App for document automation
Open your Sheet, connect a template, add tags to your document, and automatically create multiple documents.
No credit card required · Setup in minutes
·
900,000+ Installs
·
4.8 stars ★★★★★
Trusted by teams at
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.
01
Open the spreadsheet you want to mail merge in.
02
Connect a Google Docs or Google Slides template
03
Then just add ‘column tags’ from your spreadsheet
04
Merge to create Google Docs, Slides or emails
.gif)
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.
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)
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.
Sign up to Portant for free, click 'New Workflow', select your spreadsheet, connect a Google Docs or Slides template, add tags, and click 'Start Automation'. Portant merges images, dates, numbers, and text in multiple languages. Emails send from your Gmail and documents save to your Google Drive automatically.
Yes. Portant connects directly to Google Sheets so you can mail merge documents and emails in a few clicks. Upload an Excel file, save it as a Google Sheet, then connect a Google Docs or Slides template with tags. Portant generates personalised outputs automatically from your spreadsheet data.
Sign up to Portant for free, select your Google Sheet, connect a Google Docs or Slides template, add column tags, and click 'Start Automation'. Portant's free plan includes mail merge for documents and personalised emails with no credit card required. Upgrade anytime for higher volumes.
No. Google Workspace does not include a built-in mail merge feature. Portant is a free mail merge app that integrates with Google Sheets, Docs, Slides, and Gmail. Connect your spreadsheet, add tags to a template, and automate personalised documents and emails in minutes.
Portant is the top rated mail merge app for Google Sheets with 900,000+ installs and a 4.8-star rating. It connects to Docs, Slides, and Gmail so you can create documents and send personalised emails from your spreadsheet data. The free plan gets you started in minutes.
Create address labels from Google Sheets with Portant in minutes. Select your spreadsheet, connect a Google Docs template formatted as a 1x1 table, then turn on Data Grouping to batch your labels. Click 'Start Automation' to generate a print-ready document with all your labels.
Set up a mail merge with Portant in a few steps. Sign up for free, click 'New Workflow', select your Google Sheet, connect a Docs, Slides, or email template, add column tags, and click 'Start Automation'. Portant merges images, dates, numbers, and multilingual text automatically.
The six steps are: 1) Sign up to Portant for free, 2) Click 'New Workflow' and select your Google Sheet, 3) Connect a Docs, Slides, or email template, 4) Add column tags to personalise your template, 5) Preview one row to check formatting, 6) Click 'Start Automation' to merge all rows.
Yes. With Portant, add each recipient on a separate row in your Google Sheet and the mail merge sends a personalised email to every row automatically. You can also add multiple recipients to a single email using the 'To', 'Cc', or 'Bcc' fields in your email template.
Yes. Print mailing labels from Google Sheets with Portant by connecting your spreadsheet to a Google Docs template formatted as a 1x1 table. Enable Data Grouping to batch all rows into one document, then print. Portant generates a ready-to-print label sheet in seconds.
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.
Most popular templates
Transform your work life with responsive, fully customisable, and easy-to-use templates.
Select a Google Doc agreement template, add an eSignature placeholder and put your contract signing on auto-pilot.
Try it now
Select a Google Sheet of invoice data, add a Google Docs invoice template, and generate 10, 100 or even 1000's of invoices at a time.
Try it now
Select a Google Form, add tags to a Google Doc template, and generate Docs every time you receive a Google Form response.
Try it now
Every time a Google Form is submitted an incident report PDF is automatically generated and shared via email.
Try it now
Select a Google Form, add tags to a Google Doc or Slides template, and generate PDFs from responses.
Try it now
Systemise your contracts so they are consistent and accurate. Perfect for sales and legal operations.
Try it now