The #1 App for document automation
Open a Google Sheet, connect a template, add tags, and automatically start creating PDFs.
No credit card required · Setup in minutes
·
900,000+ Installs
·
4.8 stars ★★★★★
Trusted by teams at
It's easy to mail merge to PDF in a few simple steps. You can merge all kinds of different data types to create PDFs, including: images, dates, numbers and text in multiple languages. After you've installed Portant Data Merge, the next thing you need to do is open the add-on, in either Google Docs or Google Slides, then connect a spreadsheet, add some column tags to your template and then click automate, and voila!, you've just mail merged some PDFs!
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.
01
Open the spreadsheet you want to mail merge in.
02
Connect a Google Doc or Google Slides template
03
Then just add 'column tags' into your spreadsheet
04
Save outputs as docs or pdfs and share via email
.gif)
Mail merge to PDF eliminates the monotony of data entry from your life, saving you from repetitive strain injuries caused by clicking 'CTRL + C' 'CTRL + V'. But seriously, a huge amount of time is wasted on admin tasks, much of which we believe could be automated. Mail merge to PDF is one of the tools you can use to spend less time managing documents and more time changing the game.
Mail merge to PDF means that typos are a thing of the past. All the information used to make your documents is sourced from a central spreadsheet. This means you won't have to worry about any errors from copying and pasting or typos. Not to mention, your formatting is guaranteed to be consistent on all your PDFs.
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 to PDF will help you create powerful business solutions within Google Workspace.
Yes. Open a template in Google Docs or Google Slides, connect a spreadsheet, add column tags, and click automate. Portant merges text, images, dates, and numbers into professional PDFs automatically. See the complete guide for a full walkthrough.
Yes. Store the image as an accessible URL in your spreadsheet, then mark that column as an image tag in your template. Portant inserts a placeholder you can move and resize freely. Learn more about adding images to your template.
Yes. Connect a Google Form to a Docs or Slides template in Portant, and each response automatically generates a PDF. You can also use Combine mode to merge all rows into a single document for batch printing.
Yes. In the Data Merge box you can pick a custom set of rows, create filter rules, or select just a single row. This gives you full control over which Google Sheets data gets merged into your PDFs.
Yes. You can save output PDFs to any Google Drive folder, and even use dynamic folder naming based on your spreadsheet data. See output document settings for all the options.
Yes. Portant sends personalised emails from your own address with the merged PDF attached automatically. Customise the subject, body, and recipients per row. Learn more about sharing documents via email.
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
.webp){kind=small}