Portant Workflow can group data within your source spreadsheet and place it into tables within your document. If your source spreadsheet contains multiple rows that should be grouped and inserted into one table then this is the feature for you. A good example use case is when you need to include multiple Google Sheet rows into an invoice template or purchase order.
If you need to use this feature your source spreadsheet will normally have rows which are grouped together like the example below.
You can easily place a data merge table into a document in a few easy steps:
Open the Google Sheet Source Block, then the advanced options. Then select the column the table data will be grouped by. This column needs to be unique (e.g. no columns which are named Invoice Number and Invoice No. with the same data in the column.
Add or open the document block and insert a table into the document (Insert > Table).
Then add the tags into the table. These are the tags of the data that will have multiple lines per document. Please ensure the tags are only added on one row.
Optional: You can add header and footer rows to the top and bottom rows of the table and format as appropriate. The additional rows will only be placed immediately after the row with tags.
After you have set up the grouping and other document settings (e.g. Document name, pdf or email etc) you can click the Create Documents button, and voila!, invoices will be made including tables with multiple lines from the spreadsheet source!
We created Portant only a few months ago, so any feedback or suggestions you have for us would be greatly appreciated. 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
Select a Google Doc agreement template, add a signature placeholder and place your contract signing on auto-pilot.
Select a Google Sheet of invoice data, add a Google Docs invoice template, and place your invoicing on auto-pilot.
Select a Google Form, add tags to a Google Doc or Slides template, and generate PDFs from responses.
Open your Google Sheet, connect a template, add tags to your document, and create multiple documents.
Select a Google Form, add tags to a Google Docs template, and customise documents from responses for free.