With Portant Data Merge you can optimise your document workflows within Google Workspace, eliminating copy-paste from your document creation. This 'Complete guide to getting started with Portant Data Merge' will walk you through how to connect a source, add tags to a template document and place your documents on auto pilot.
In this article you’ll learn how to:
The first step is to install the Add-on on your Google Workspace account.
Click on Add-ons > Get Add-ons and then search for “Portant Data Merge” (or just click this link)
Click on 'Portant Data Merge' and then select Install
After you select install Google will ask you if you would like to continue.
Then you need to select which Google account you would like to install Portant Data Merge on.
Google will display all the different permissions requests Portant Data Merge needs access to, to operate. We have put together explanation plain english list below:
Click Allow, then click Done and then you can close the marketplace window
To open the Portant Data Merge Add-on, click on Add-ons > Portant Data Merge > Start
When you open Portant Data Merge, the homepage of the app will display the sources you are able to connect.
This is where you can select the kind of source you would like to connect from the following options:
Top Tip - If there is a different integration you are looking for you can click the External Apps button (at the bottom). This is where you can vote on any integrations you would like to see Portant Data Merge work with in the future 🤙
After you have selected the source you would like to connect to, you will need to set it up. Each source has some slight differences so we have made a bespoke page for each one. Please select the one you would like to learn more about below:
In each source you need to identify the file or board you would like to connect to and then click continue.
After you have selected and connected a source, Portant Data Merge imports the column headers, questions or card fields into a table. We call this the Data Source Table. Each column/question/field in the data source appears as a separate row in the table.
To add a tag into your template please follow these steps:
Top Tip - Format the tag exactly how you would like the source data to appear (e.g. text size, colour, fort etc) Portant will place the source data in that location with the same styling as your tag has.
Note - All the missing field tags will be replaced with blanks in document templates.
You can change tag names to make them shorter, or more understandable, by following these steps:
Note - Tag names need to be unique and can’t be the same as any other data source row or tag name.
You can easily place an image into a document in a few easy steps:
Note - .jpg, .jpeg, .png and .gif file formats are supported
Inserted images are always placed into the document with a locked aspect ratio (Portant doesn't distort any images to fit the placeholder). If an inserted image has a different ratio to the placeholder, Portant scales the height while maintaining the ratio ratio until placeholder width is reached.
Portant can use the following image links/urls:
Note - When using a Form to collect images, Portant will only be able to insert one per question. If multiple images are uploaded are added, Portant will select the first one. You can limit users to only upload one in form settings.
After you have customised the format of your document and added your tags, the next thing to do is set-up your Data Merge Settings. This is where you can edit how the Data Merge will run and filter the source data used to make the documents.
The Data Merge settings are located under the Data Source table. The main settings are shown on the front of this card and the advanced settings are in a menu accessible via a button in the top right hand corner. We have put together a more detailed article for each source type below:
Portant can also help you mail merge with Google Docs or create invoices from google sheets
The next step after you have finalised the Data Merge settings, is to customise the Document Output settings. This is where you can edit the name, type and location of the output files. This box is located under the Data Merge box.
Before you start creating documents, you can edit your output documents’ name. If you are using Multiple documents mode, you can add {{tags}}, so each output document can have a different name. You can either copy and paste these tags from the document or place your cursor inside the file name field and press the 'Insert' button in the data source table.
To create PDF copies you need to purchase Portant Pro. You can do this by click the Pro icon and entering your payment details. This also enables you to remove Portant branding from any emails you use to share documents.
After you have done this, you can select the 'Create PDF documents' checkbox. When you do, Portant creates a subfolder within your Document Output Folder and saves a PDF copy for every document you make in it.
Top tip - The output folders can be renamed and moved within your Google Drive. Portant will remember where they are and save the files there. If the folder is deleted or placed in the trash Portant will create a new folder with the same name as the original.
In the top right hand corner of the Document Output box is a link to the output folder. This is the folder where Portant will save the document outputs. As mentioned above, this folder can be renamed and moved within your Google Drive. Portant will remember the folder location and save the files there.
If you need to change the document output folder you can do by opening the 'Options' menu. This is located by clicking the 'Options' button in the top right hand corner of the Data Merge box, shown below:
After clicking the 'Options' button, scroll down to the 'Output Folder' section and click the 'Change Folder' button. Then select the new location, within your Google Drive, for the document outputs to be saved in:
Sometimes it might be useful to automatically share documents with a certain people via email as soon as the document is created. With Portant Data Merge you are able to do this using our 'Share via email' functionality.
To add an email to your workflow, you need to tick the checkbox 'Automatically email created docs', which is located in the 'Share via email' box under 'Document outputs'. When you click this checkbox a modal will open with email settings.
After the email modal is open, you'll be able to see all the functions available. The standard email fields such as To, Subject and Body on the left hand side, and on the right handside you have the source tags, attachment settings and sending conditions.
If one of your {{tags}} has email in the name, Portant will automatically place it in the 'To' field. You can enter other emails addresses into this field and also add multiple {{tags}} (if they are emails)
The subject line can be customised by using {{tags}}. This works in the same way as it does in the document, by placing your cursor in the subject line field and clicking 'Insert'
Body
The body of the email can also be customised using {{tags}}. This works in the same way as it does in the document, by placing your cursor in the body field and clicking 'Insert'
Portant branding is added onto the emails in two ways. The first is adding 'via Portant Data Merge' to the end of your Sender name. And the second is via a footer that will appear at the bottom of every email. If you would like to remove this branding you can purchase Portant Pro.
Top tip - These emails will be send via your Gmail account. You will be able to view the emails send by accessing your sent folder in Gmail
You can customise the attachments sent with your email. When you Share a Google Docs/Slides file you have three levels of access you can give the recipients:
Viewer
Editor
Commenter
You can also attach a pdf to the email if you have paid for Portant Pro.
Below the attachments box there is an option to set-up sending conditions. This is where you can send an email based on the data contained within a field in the data source. To switch this setting on, click the 'Send emails based on defined rules' checkbox. After you do this a new modal will open like this:
Here you can select a field to base a condition on and then add the rule. You can add multiple rules referencing different fields. After you have completed your rule you can name it in the top right hand corner then click 'Save'.
After you have added your first email, you can add a second by clicking the 'Add secondary email' checkbox in the 'Share via email' box. After you click this checkbox another email modal window will open where you can customise your second email.
Top Tip - This is very useful if you are using Portant for approval processes. You can pair this feature with the Google Form source's Prefill links and send the first email as a Draft and the second as a final document for example.
Google sets email quotas for different levels of Google Workspace account. These email quotas are displayed at the bottom of the 'Share via email' box and the 'Email settings modal'. These numbers are sourced directly from Google.
The email limits are based on the number of recipients, not the number of unique emails. These email limits reset every 24 hours. The exact time when Google renews your quota could vary but we've seen that the quota often resets around 1 PM PST
Top tip - if your email ends in '@gmail.com' you are probably a free Gmail user.
After you've finished setting-up your Data Merge, the final step is to start it. After you start a Data Merge, Portant checks the file for any errors, then displays the progress and alerts you when it's complete.
To start creating documents click the Create Documents button.
This will open a progress bar above the Data Sources Table where you can track the process of your documents. The automation works through the following steps:
You can click this status bar to open the folder where the documents are being saved (even while the automation is running).
Before Portant starts a data merge, it checks all the tags in the document to see if they are correct. If you have a bad tag in your document it will stop the data merge and ask you if you'd like to resolve it. At this stage you can highlight the problem tag in your document so it is easy to find. (Or if it is not an issue, you can click ignore to progress.)
After you have rectified the bad tag, you can press the 'Create Documents' button again and the data merge will start.
If you need to stop the automation at any time you can press the ‘X’ next to the progress bar. The documents already created will be saved in the output folder.
That's it. Everything you need to need to know about Portant Data Merge.
We created Portant in 2021 and the feedback we have received since then has been very helpful and greatly appreciated. If you have any feedback please feel free to send us an email at contact@portant.co or use our contact form here: https://www.portant.co/support
Thanks,
Blake and James
You can do a lot more than just 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 startedTransform your work life with responsive, fully customizable, and easy-to-use templates.