🤖 Generate, save and email documents automatically from templates (mail merge). Portant can merge data from Google Sheets, Google Forms or Trello into Docs and Slides.
Listing updated:November 30, 2023
Works with:
💫 Transform the complexity and monotony of a repetitive document into a well-oiled workflow, so you can free up time to work smarter, not harder. 

Here’s everything Portant Data Merge does...
📁 Document Generator - Creates multiple documents from a Google Sheet or Trello board (data merge).
🤖 Automatically creates new documents when a Google Form response is submitted (or when a Google Sheet is updated).
📄 Combines multiple rows from sheets into one document or presentation
✉️ Custom email messages (Mail Merge), email notifications and document sharing from your email address (via Gmail)
🧾 Automatically save documents and presentations as PDFs (Pro feature)
✅ Create approval workflows using the 'Form Edit Response' links and email conditional logic.
👌Make your documents more accurately and ensure typos are a thing of the past.Plus, your formatting is guaranteed to be consistent on all your documents.
⏱️ Save time. Delete copy and paste from your workday, and place your repetitive documents on auto-pilot.
📍 Centralise and consolidate your workflows in Google Workspace and reduce the number of external tools you rely on (and pay for)

And that's not all…
🚀 We have big plans for Portant and a feature backlog that will enable you to create beautiful documents and presentations with less effort. 
💡 So if there is a feature that you would like to see, please let us know: contact@portant.co 

How to start using Portant:
1️⃣ Install the add-on 
2️⃣ Open the add-on by selecting: Add-on > Portant Data Merge > Start
3️⃣ Select and connect a Google Sheet or Google Form 
4️⃣ Insert simple tags to indicate where you want each answer to be placed in the final document.
5️⃣ Click START and automatically create documents and save them in a folder on your google drive.
6️⃣ Optional | Share documents with email addresses.
7️⃣ Optional | Set Portant to automatically create documents whenever there is a change to the sheet or new answer to the form.

There are many use cases...
📊 Project teams: Generate project status reports, end of week summaries, executive reports, team check-ins, end of month showcases.
🧾 Sales teams: Create pitch decks, sales letters, quotes, invoices or contracts 
👥 HR teams: Produce onboarding documents, salary updates, official employee letters
📦 Operation teams: Automate packing lists, carton labels, commercial invoices
🏅 Education and teachers: Make certificates, awards, progress reports, evaluations.
🎁 And many, many more! 

Portant is a great solution if you are overloaded from copy and pasting information into documents. Or if you’re looking for an alternative to simplify and centralise workflows built on top of Zapier, Workato or Integromat. Or a simpler alternative to Add-ons such as Autocrat, Document Studio or Form Publisher.

Portant is a document merge and workflow add-on available in the Google Workspace Marketplace. 

💳 Pricing
Free to use all features
$9/month to remove Portant branding from emails and copy and export as pdf 
or $89/year (Save 18%)
Additional information
PricingFree of charge with paid features
Privacy policy
Terms of service
Portant Data Merge will ask for the permissions shown below. Learn more
Portant Data Merge will need access to your Google account
This will allow Portant Data Merge to :
See, edit, create, and delete all your Google Docs documents
See, edit, create, and delete all of your Google Drive files
View and manage your forms in Google Drive
See, edit, create, and delete all your Google Slides presentations
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
Send email as you
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Julia Kedward
April 22, 2024
Easy to use. Did exactly what I needed. Saved me a ton of time. I have a template that is one, long sentence. I needed to complete this sentence by inserting 4 pieces of data. I had 85 rows, therefore making 85 sentences all with distinct data. Using this feature make that easy.
Is this review helpful?
Profile Picture
Kristy Pack
December 16, 2023
This tool made it so easy to do a merge from a spreadsheet to a new doc, attached as a pdf and sent to a specified email.... en mass. Saved me so much time. I'm so glad I found this tool.
Is this review helpful?
Profile Picture
Tim Elam
October 11, 2023
I've tried many mail merge add-ons, but none of them came close to the features and ease of use of Portant Data Merge. Setup was easy and it works flawlessly every time. I contacted support and was blown away with the quick and friendly response. Thanks for much for such a great add-on!
Is this review helpful?
Profile Picture
Research Platform
August 4, 2023
Awesome makes our life easier in creating automated documents easily sent via email to all subscribers
Is this review helpful?
Profile Picture
Teddy Gerry
September 19, 2023
Great service and exceptional customer support. Well worth the price of admission!
Is this review helpful?
Profile Picture
Janice Koehler
November 24, 2022
Looking to merge a list of members from a sheets workbook with a docs template to quickly produce an electronic membership list for our club. Look what I found... Worked almost. A page break between each member. A quick meeting with CEO Jeff Fyfe and that was fixed. Works very well and you gotta love the personal support. I can't imagine what more you could want.
Is this review helpful?
Profile Picture
Ayuba Mwada
December 29, 2023
Is this review helpful?
Profile Picture
Lilia Diaz
April 26, 2022
Here, Lilia Diaz a 25 yr teacher, now a counselor. I needed to merge info to create 100 certificates. This app was really easy to use, thanks to the tutorial videos. The merge went smoothly, but I ran into printing the merge problem. Decided to use the chat with a tech feature. Got support immediately from James, who helped me resolve that issue. Very happy to have found this app add-on. Being, I had researched youtube and other merging add-ons. This was by far the easiest to use, may more success come your way Portant!
Is this review helpful?
Profile Picture
Sudaththa Ariyasena
January 31, 2022
Exceptionally good at creating reports and invoices. I run a small manufacturing business and this product help me set up the invoices and daily production reports from Google Sheets. I really like the flexibility offered with various options that we can tweak. On the downside, the product is limited by timeout setup by Google, but it can easily be worked around by setting up the number of rows you have to process each time. The customer support is awesome! I had a small issue at the beginning and they helped me out really fast.
Is this review helpful?
Profile Picture
Kathlene Salino
March 4, 2022
Overall great platform, Makes my life much easier!! 5 stars for the overall service and for the quick and helpful response when I had an issue with it. I highly recommend emailing the support (when you encounter a problem) instead of posting a bad review. Love the automated email block feature, especially since the service is free. Would certainly make my tasks easier especially when communicating with my customers and clients.
Is this review helpful?
1-10 of 61
Clear search
Close search
Google apps
Main menu