logo
Documents
Sep 14

Generate multiple documents from one data source with Document sets

Lead Marketing Specialist

Plumsail Documents Processes can now generate more than one document at a time. With the new Document sets feature, you can add multiple templates to the same Process, use different template formats, and generate the entire set from the same data in a single run.

To see how it works, we'll build a sales proposal package containing a project proposal, pricing spreadsheet, and presentation. We'll use the same client and project data across all three templates and make the presentation conditional, so it's only generated when it's actually needed.

Instead of maintaining a separate Process for each document, we'll keep the whole proposal package together and generate it in one run.

Further in the article:

What are Document sets in Plumsail Documents?

A Document set is a collection of multiple templates within a single Plumsail Documents Process. All templates in the set can be generated together from the same input data in a single Process run.

The templates don't have to use the same format. You can combine DOCX, XLSX, PPTX, fillable PDF, and HTML templates in one Process and configure each template separately, including its output format, file name, and conditions for when it should be generated.

For our sales proposal package, we'll use three templates:

All three documents will use the same client and project data, but each template will use it differently.

DOCX, XLSX, and PPTX templates in one Plumsail Documents Process  

Create a sales proposal Document set

Let's start by creating a Process and adding the three templates that make up our proposal package.

Create the Process and add the project proposal

  1. Go to Processes in your Plumsail Documents account
  2. Click Add process
  3. Choose to upload your own template
  4. Upload the Project proposal DOCX template
  5. Name the Process Sales proposal package
  6. Create the Process

Project proposal DOCX template uploaded to a new Plumsail Documents Process  

We'll start with the main project proposal. It contains the client name, project overview, scope of work, timeline, and total investment.

The template uses tokens such as:

{{clientName}}
{{projectName}}
{{projectSummary}}
{{duration}}
{{total}}

It also uses the services collection to populate the scope of work table.

Word project proposal template with tokens for client and project data  

Open the template settings and configure:

  • Template name: Project proposal
  • Output filename: {{clientName}} - Project proposal — the {{clientName}} token makes the file name dynamic, for example Contoso - Project proposal.pdf
  • Output file type: PDF

We use a DOCX template because it's convenient to design and edit in Word, while the final proposal will be generated as a PDF.

Project proposal template settings with PDF output in Plumsail Documents  

Add the pricing spreadsheet

Instead of creating another Process for the pricing spreadsheet, we'll add it to the same Document set.

  • Click Add template in the Process panel

Add another template to the documents set  

Configure:

  • Output filename: {{clientName}} - Pricing breakdown
  • Output type: XLSX

Pricing breakdown template settings  

The spreadsheet contains the same client and project information as the proposal, but uses the services collection to create a detailed pricing table with quantities, rates, and amounts.

The XLSX template also contains the {{presentationRequired}} token. We'll use this value later to decide whether the PowerPoint presentation should be generated.

The {{presentationRequired}} token can be kept on a separate data sheet so it doesn't appear in the customer-facing pricing table.

Excel pricing breakdown template with repeating service rows and Plumsail Documents tokens  

Add the proposal presentation

Finally, add the PowerPoint presentation to the same Process.

Open the template settings and configure:

  • Output filename: {{clientName}} - Proposal presentation
  • Output type: PPTX
  • Turn on Conditionally run template
  • Set the condition to presentationRequired Equals TRUE

The presentation is not needed for every sales opportunity, so we use the presentationRequired token to control whether this template should run. When its value is TRUE, Plumsail Documents Process generates the PowerPoint presentation along with the other documents in the set. If it is FALSE, the presentation is skipped.

Add proposal presentation to documents set  

At this point, our Sales proposal package contains three templates in three different formats: a Word proposal, an Excel pricing breakdown, and a conditional PowerPoint presentation. All three remain independently configurable while being part of the same Process.

Configure the Process output

Before adding a delivery, open Process settings and make sure Output files is set to Separate files.

This keeps the generated documents as separate files, ready to attach to the Outlook email we'll configure next. If needed, you can also combine the generated documents into a single PDF or package them into a ZIP archive.

Plumsail Documents Process settings with Separate files selected as the output  

Send the generated documents with Outlook

We'll use Outlook to send the complete proposal package by email. Since the Process output is set to Separate files, the generated PDF, Excel spreadsheet, and PowerPoint presentation can all be attached to the same message.

  • Click Delivery in the Process panel
  • Select Outlook
  • Connect your Outlook account if you haven't already
  • Enter the recipient address
  • Add the email subject and body
  • Keep all templates selected so every generated document is attached

Tokens can be used in Outlook recipients, subject lines, and email bodies, so the delivery can use the same Process data as the document templates.

Outlook delivery configured to email all documents from a Plumsail Document set  

Run the complete Document set

Now that the templates, Process output, and Outlook delivery are configured, let's run the complete Process using sample JSON data.

Plumsail Documents Processes can be started in several ways, including web forms, CSV or Excel files, custom JSON, Power Automate, Make, Zapier, and REST API. For this example, we'll submit JSON directly so we can clearly see the single data object used to generate the entire Document set.

  • Click Start in the Process panel
  • Select Submit custom JSON data
  • Paste the sample JSON
  • Start the Process
{
  "clientName": "Contoso",
  "clientContact": "Alex Morgan",
  "projectName": "Customer onboarding automation",
  "proposalDate": "2026-09-09T00:00:00",
  "validUntil": "2026-10-09T00:00:00",
  "projectSummary": "Design and implement an automated customer onboarding workflow that reduces manual handoffs, standardizes document collection, and gives the team a clear view of onboarding progress.",
  "startDate": "2026-10-19T00:00:00",
  "duration": "8 weeks",
  "presentationRequired": true,
  "services": [
    {
      "name": "Discovery and workflow design",
      "shortDescription": "Workflow analysis and solution design",
      "description": "Review the current onboarding process, map requirements, and design the future workflow.",
      "quantity": 1,
      "rate": 3500,
      "amount": 3500
    },
    {
      "name": "Implementation",
      "shortDescription": "Workflow configuration and integration",
      "description": "Configure the onboarding workflow, integrations, document generation, and testing.",
      "quantity": 1,
      "rate": 12000,
      "amount": 12000
    },
    {
      "name": "Training and handover",
      "shortDescription": "Team training and documentation",
      "description": "Train the customer team and provide implementation documentation.",
      "quantity": 1,
      "rate": 3000,
      "amount": 3000
    }
  ],
  "total": 18500
}

 

The same input is used across all three templates. For example, clientName appears in the proposal, pricing spreadsheet, and presentation, while each template uses only the fields it needs.

Since presentationRequired is set to TRUE, the conditional PowerPoint template is generated as well.

JSON data used to run the sales proposal Document set in Plumsail Documents  

The Process generates:

  • Contoso - Project proposal.pdf — the final client proposal with the project overview, scope, timeline, and total investment.

Generated project proposal PDF  

  • Contoso - Pricing breakdown.xlsx — the detailed pricing spreadsheet with services, quantities, rates, and total.

Generated pricing breakdown spreadsheet  

  • Contoso - Proposal presentation.pptx — the presentation version of the proposal for stakeholder review.

Generated PowerPoint proposal presentation  

The Outlook delivery then sends all three files as attachments in a single email:

Outlook email with generated PDF proposal, Excel pricing breakdown, and PowerPoint presentation attached  

With one Process run, we've generated three documents in different formats from the same data and delivered them together by email.

Check the conditional presentation

To see the template condition in action, change:

"presentationRequired": true

to:

"presentationRequired": false

  and run the Process again.

This time, the PowerPoint template is skipped. The Outlook email contains only:

  • Contoso - Project proposal.pdf
  • Contoso - Pricing breakdown.xlsx

The Process itself stays the same. Only the documents that meet the configured conditions are generated and delivered.

Outlook emails showing three generated files with presentationRequired true and two files with it false  

Other ways to use Document sets

A sales proposal is just one example. Document sets work well whenever the same business event needs to produce several related documents.

ScenarioPossible Document set
Employee onboardingEmployment agreement + onboarding checklist + training presentation
Project kickoffProject plan + budget spreadsheet + kickoff deck
Customer reportingWritten report + detailed Excel data + presentation
ProcurementProposal + pricing workbook + supporting documents

 

Generate multiple documents from one data source with Plumsail Documents

With Plumsail Documents, you can keep related templates in one Process and generate them from the same data.

Start a free trial and try Document sets with your own templates.