Guides
How to Merge Notion Database Rows into One PDF (Step-by-Step Guide)
Learn how to combine multiple Notion database rows into a single merged PDF document using PDFOutput. Step-by-step guide with templates, placeholders, and automation setup.
By Sanat Biswal · 2026-08-12 · 10 min read
If you manage a Notion database full of client records, invoices, or reports, you've probably run into this problem:
"Notion is an awesome tool when it comes to storage of data, but its not built to convert dozens of rows of notion data into one clean, shareable PDF document".
Most often, you are not looking to generate a PDF for every single record, but rather want to combine multiple Notion Database rows into single, merged PDF document.
That's exactly what this guide covers.
Below, you'll learn how to generate merged PDFs directly in a Notion database combining multiple records at once using PDFOutput, a no-code document automation tool that connects Notion with Google Docs, Word, or PDF templates.
Learn More : How to Batch Export Notion Database Rows as Individual PDFs
Why Merge PDFs Instead of Generating Them One by One?
Generating an individual PDF for every database row works fine when you need separate files — such as individual invoices or contracts or agreements or proposals etc.
But there are many situations where a single merged file is more required. Some of the examples includes:
- Monthly or weekly reports that pulls together multiple entries into one document for a client or manager or
- Combined contract packets where several agreements need to travel together as one single pdf file or
- Catalogs or price lists built from a products database or
- Team rosters, attendance sheets, or even class lists which are compiled from individual records or
- Order summaries that combines several line items into one printable sheet etc
- Sort your database first. Since rows merge in the order they appear, sorting by date, name, or priority before running the export keeps your final document organized.
- Use consistent formatting in your template. Uneven fonts or spacing between placeholders becomes obvious once dozens of entries are stacked together.
- Add page breaks between entries. This keeps each record visually separate, especially useful for reports or contract packets.
- Filter before you merge. Only include the rows you actually need in that document, an additional property (status type) like "Merge Records" makes this easy to manage.
- Test with a small batch first. Run the automation on three or four rows before merging more records from the entire database, this can help you catch any formatting issues early on.
In this situation, instead of manually generating the PDFs one by one for each row, we can automate the process to merge multiple rows together using PDFOutput and generate one polished clean merged PDF File.
Prerequisites Before Setting Up PDFOutput Automation
Before setting up the automation, make sure you have the following 3 things ready and setup:
1. A Notion account — Free plan works fine while getting started, although if you want to use a button to generate PDFs then it will require a paid Notion Plan.
2. A Google account — Templates are typically built as Google Docs, since they're the easiest format to design placeholders in and edit collaboratively. But you can also use Word File, PDF File and even Notion Pages to generate the PDFs.
3. A PDFOutput account — This is the automation layer that reads your Notion database, fills in your template, and generates the finished PDF.
Once these three are in place, you're ready to build the automation.
Related Reading : How to convert Notion Pages to PDFs on automation
Step-by-Step: How to Generate Merged PDFs in Notion
Step 1: Set Up Your Notion Database
Start with a Notion database that holds the rows you want to merge.
For this demonstration, we will consider Shipping Labels which we will merge and generate as a Single PDF File (as shown below).
Each column may represent a piece of data that you want to appear in the final PDF to be created (for example, a client name, or a date, or an amount, or description).
Best practice is to keep the property names short and consistent, since they'll be easy to map directly to placeholders that will be used in the template in the next step.
Step 2: Build a Template With Placeholders
Create a Google Doc (Word and PDF templates work too) and design the layout exactly how you want the final document to look.
Anything you want from your Notion data to appear, insert an exact placeholder wrapped inside double curly braces, like {{Order ID}}, {{Recipient Name}}, or {{Shipped to Address}} etc in the document.
These placeholders will act as like fill-in values that PDFOutput will replace with real values pulled from each matching row in your Notion Database.
For a merged document, this will act like a repeating "block" section, which will loop and run across every other row selecting and combined into one single PDF with a space added in between.
Step 3: Connect Your Notion Database and Template in PDFOutput
Inside PDFOutput, link your Notion account and select the database you prepared in Step 1.
Then attach the template you created in Step 2.
PDFOutput will then automatically match your column headers to your placeholders automatically added earlier, so simply double-check that column headers and the placeholder values are correctly added on both the sides properly or not.
Click on Preview Output to generate a Preview Document which shows how the final output will look like.
Once satisfied with the Preview Output, click on Setup Automation and it will setup the automation directly inside PDFOutput dashboard which will enable generating the PDFs right inside the Notion Database.
If you are not happy with the Preview Output generated, but find missing placeholders or want to change the layout, you can go back and adjust the template as required and regenerate the Preview Output again to validate your PDF created.
I have added a reference link below which explains step by step how to setup PDFOutput to connect Notion Database and Template for generating the PDFs.
Related Reading : How to setup PDFOutput automation (Step-by-step guide)
Step 4: Select the Rows in the Database to Merge PDF
This is the step that will help you create a merged PDF right inside Notion Database.
In your Notion Database, you will find a new column added, i.e. "Merge PDFs?", this column is a checkbox property type which will help you select all the rows that are ready to be merged into a single pdf.
Simply select the rows which you want to be merged into a single PDF, and then mark any record as "Ready to Generate" or use a button to generate the PDF.
It will now automatically create a merged pdf combining the values obtained from the selected rows as defined earlier.
So everytime you need to merge rows of data into one single pdf, just select the rows you want to merge from the database and click on Ready to Generate on any particular row out of all the selected rows to generate the merged PDF file.
The images added below shows how we have used the option for Merge PDFs? and it has generated 3 records merged into one single PDF file.
Additional Settings
Besides this, we can define the PDFFile name, Google Drive Folder link and other additional settings can be configured right inside PDFOutput automation tool.
Additionally, it also supports use of the E-Signatures as well, so if you want to implement e-signatures into your PDFs using Notion, PDFOutput also supports that.
Related Reading : How to use E-Signature in PDFOutput
Make sure to check if the automation is set under Active status inside PDFOutput dashboard before proceeding to generate the merged pdfs.
If the automation isn't set under active status, then the automation will not work.
Once the PDFs are generated inside the Notion Database, it can be downloaded from the database for use later on.
If you happen to regularly generate the same type of merged report — say, a weekly summary report, you can keep the automation under active status so it's ready to run again the next time you need it, without rebuilding anything from scratch.
Tips for Cleaner Merged PDFs
Frequently Asked Questions
Can I merge PDFs from a Notion database without any coding?
Yes. PDFOutput is a no-code automation tool built specifically for this, so you can connect your Notion database and a template (such as Google Docs, Word File, PDF File or Notion Page) using placeholders, with no additional scripts or any third-party plugins required.
What's the difference between bulk PDFs and merged PDFs?
Bulk (or batch) export creates one separate PDF file per database row. A merged PDF export combines multiple rows into a single continuous PDF, useful when you need one document instead of many documents separately.
Do I need a paid Notion plan to generate merged PDFs?
No, PDFOutput can work even with your free Notion account. Paid plan helps to unlock extra features, such as using a button inside database to generate PDFs.
Can I control which rows get merged into the PDF?
Yes. You can filter the rows by using the "Merge PDFs?" checkbox property which you can select for the rows you are looking to merge as single PDF. Once all the required rows are selected, click on the button to generate the PDF or use "Ready to Generate" property to generate the PDFs (merged PDFs).
Final Thoughts
Converting a Notion database into a single, professional PDF doesn't require copying and pasting data by hand one-by-one manually or merging the files in a separate app.
With a template built in with the placeholders in place, an automation tool like PDFOutput can handle the connection to Notion, and you can go from scattered rows to one single polished document which is ready to be shared document in just a few clicks and this setup can be reused again and again everytime its needed.