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 Automation will run and filter the data Portant will use to make the outputs.
In this article you’ll learn how to:
There are two different types of Data Merge possible with Google Sheets. These are:
This is how you filter what data from your spreadsheet you would like to make documents with. There are a few different options you can use:
If you open the options menu in the top right hand corner of the Data Merge box you will find additional options for the data merge. These are:
Portant will periodically check the source file every hour or day. When new data is found in the source Google Sheet, a new document is created.
When selected, Portant will automatically insert document (and pdf) URLs next to the last column of your spreadsheet. like this:
Portant will add extra rows to tables containing template tags to capture all grouped rows in your spreadsheet. Learn more
Note - These additional options are only available in 'Create multiple documents mode'
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 firstname.lastname@example.org or use our contact form here: https://www.portant.co/support
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 started
Transform your work life with responsive, fully customizable, and easy-to-use templates.
Select a Google Doc agreement template, add an eSignature placeholder and put your contract signing on auto-pilot.
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.
Select a Google Form, add tags to a Google Doc template, and generate Docs every time your receive a Google Form response.
Every time a Google Form is submitted an incident report PDF is automatically generated and shared via email.
Select a Google Form, add tags to a Google Doc or Slides template, and generate PDFs from responses.