How to create Excel and PDF documents from Plumsail Forms in Zapier

This article describes how to create PDF documents from an XLSX template on Plumsail Forms submission with the help of Processes in Zapier. It may help you to automize the generation of documents like applications, requests, orders, etc., in your company.

Processes are a Plumsail Documents feature with an intuitive interface for creating documents from templates.

With Plumsail Forms, you can design elegant, responsive, and highly customizable forms for SharePoint Modern UI or any web page. In our example, we will collect data from a Web Form, apply it to our template and generate a new PDF document with the help of Processes.

Create a Form

We have already designed a form for a stationery and office supplies request. Here is our result form:

Plumsail Form image

You see, that the form includes information:

  • an ordering employee – here we use mostly text boxes, for the department - a dropdown

  • the order content – we use a DataTable for adding multiple lines to the order

  • under the table with order items, we place a multiline textbox for special instructions

  • and, finally, a submit button

You can use our ready form template for a stationery order request as well. Download the file and import it to the Plumsail Forms designer.

To create such a form yourself, follow this link to learn more about how to design Plumsail Web Forms.

Understanding Internal Names of Form’s fields

It’s crucial to understand the Internal Names of Form’s fields. They must correspond to tokens in a template. You can set internal names for Form’s fields in its general propeties:

setting of the form's fields

Our data table’s name is items. And its columns have their names as well - Product and Quantity.

In our XLSX template, we’ll put such tokens {{items.Product}} and {{items.Quatity}}. The templating engine will iterate through all objects in the array to render them and add the rows automatically.

Configure the Process

Now we need to create and configure the Process which will generate stationery requests in PDF format based on data from our web form submission.

Create a new Process

Go to the Processes section in your Plumsail account.

Click on the Add process button.

add process button

Set the Process name. As we’re going to generate PDF stationery orders from an Excel template, select XLSX for the template type.

create excel process

Configure a template

Once you’re done with the first step Create Process, press the Next button, and you’ll proceed to the next step – Configure Template.

It includes two substeps:

  • Editor;

  • Settings.

In Editor, you can compose the template from scratch or upload a pre-made one. It’s also possible to modify the uploaded template online.

Feel free to download an XLSX stationery order template that we have already prepared:

Template

Then upload it to the process.

upload template file

Templating syntax

When creating your own templates, mind the templating language. Plumsail Excel XLSX templates use a different approach than most other templating solutions. It uses a minimal amount of syntax to make your work done.

In short, the templating engine thinks that everything between curly {{ }} brackets is variables where it will apply your specified data. Read this article to get familiar with the templating engine.

Test template

To check how the document will look at the end, click on the Test template button.

You will see the dialog where you can fill in the auto-generated testing form. Form fields are created based on tokens from your document template. You can adjust the look of the testing form by changing token types.

test template

It’s testing. We’re going to apply the data from the web form to our template.

Once you’ve tested the template, press Save&Next to proceed further - to the Settings substep.

Here, please:

  • Switch to an active mode to remove Plumsail watermarks from resulting documents

  • Fill in the name of the result file

  • Select PDF format for the output file

  • Protect the result PDF if you wish

configure excel template

Once you’ve customized all the settings, you can test the template to see the result as we did it before.

When everything is done here, click on Save & Next to set up deliveries.

Delivery

The next step is delivery. For demonstrating purpose, we’ll store the result file in OneDrive. But there are other options.

Just set the folder’s name where the ready document will be saved.

create pdf from template on form submission

You can configure as many deliveries as you need.

Start the Process

We will start our Process from Zapier.

Create a Zap

Zap is an automated connection between web services in Zapier. You can create it from scratch following the steps explained below.

Or you can utilize the zap template. Click Use this zap, and then just customize the steps as it’s described further in this article.

This is how our Zap looks:

xlsx to pdf from Plumsail Forms Zap

Below is a step-by-step description.

New submission in Plumsail Forms

We need to start the Zap every time somebody submits our stationery request form. For that, search for Plumsail Forms in Zapier and add New submission in Plumsail Forms as a trigger.

If this is your first Zap with Plumsail Forms, on this step, sign in to your Plumsail Account from Zapier to use your forms inside Zaps.

Then, you’ll need to pick the form you want to track in the dropdown.

Plumsail Forms trigger in Zapier

The last thing to do with the trigger - Find data. Press “Test trigger” to find data. It will allow you to use the trigger output on the next step.

Test Plumsail Forms trigger to find data

Start process in Plumsail Documents

Once the trigger is set, search for Plumsail Documents and add an action Start process.

start process from Zapier action

Click Continue. If this is your first Zap, at this point, you’ll need to Sign in to your Plumsail Account from Zapier to establish a connection between the app and your account. If you already have a Plumsail account tied to the app, you can add another one at this step, and use it instead.

Customize Start Process

Choose the process you want to start by this Zap from the dropdown.

You will see fields to complete - they have the same names as tokens from the template.

To complete them, use the output from the Plumsail Forms trigger. Zapier outlines nested objects and arrays. In our case, it’s a collection of items.

JSON data

Our Zap is ready! 🎉 See how the resulting file looks:

Final document

Sign up for Plumsail Documents

As you can see, it’s simple to automize the generation of documents on Plumsail Forms submission. If you’re new to Plumsail Documents, register an account and follow the steps described in the article to set the process for automatic creation of PDFs from Plumsail Forms.

Hint

Check out one more example of automating processing PDF with Plumsail Forms - Auto-populate a fillable PDF on Plumsail Forms submission.