Automating6 Min.

How to automatically create PDF files from form responses and send these to respondents

Connect your Tripetto form to Google Docs and Gmail to automatically create personalized PDF files and send these to your respondents.

When to use

You can use this automation if you want to email your respondents after they have completed your Tripetto form. You can attach a PDF file to that email message, for example to include a summary of the given answers.

Screenshot of PDF file
Create and send your own personalized PDF files.

What you need

The scenario we describe in this article is an example of connecting Tripetto to other services, in this case Google Docs and Gmail. Click here for more general information about connecting Tripetto to other services.

For this scenario you will need the following:

  • Tripetto, to collect your form submissions;
  • Integromat, to connect your form data to other services;
  • Google Docs, to create a personalized document;
  • Gmail, to send an email with PDF attachment.

Integromat alternatives

There are alternatives to use for Integromat, for example Zapier, Pabbly Connect or even a custom webhook. Of course it's up to you to use your favorite automation tool.

How to use

These are the steps to take to automate the process of creating a personalized PDF file and send that to a recipient.

Step 1 - Build Tripetto form

  • First make sure your Tripetto form collects the desired data.
  • Please make sure you have an email address field in your form, as we will need that to be able to send the email with the PDF file to the respondent.

The result of this step is your Tripetto form, which you will use to collect your data from your respondents.

Screenshot of Tripetto
Build your Tripetto form.

Step 2 - Prepare Google Docs template

  • In your Google Docs account create a new file/template. This will be the base for your final PDF file.
  • Give your template a name, for example Tripetto Template.
  • At the positions in your template where you want to use a value from the Tripetto form data, use the following format to insert a variable: {{your_variable_name}} (double brackets, without spaces). In the final file that we will generate for each form submission, those variables will be replaced with the entered value from the respondent in the Tripetto form.

The result of this step is your Google Docs template, that we will use later on in the process.

Screenshot of Google Docs
Prepare your Google Docs template, including variables.

Step 3 - Connect Tripetto to Integromat

  • In your Integromat account add a new scenario.
  • Give your scenario a name, for example Email PDF attachment from new Tripetto submission.
  • Add a Tripetto module to your Integromat scenario. As trigger select Watch Responses.
  • Connect your Tripetto form to that trigger, by copy-pasting the webhook URL from Integromat into your Tripetto form (AutomationsConnectionsIntegromat). Have a look at this article for the detailed description how to connect Tripetto to Integromat.
  • Test the connection, so Integromat receives the structure of your dataset.

The result of this step is that your Integromat scenario gets executed for each new form submission and you can use the data fields from your Tripetto form in the Integromat scenario.

Screenshot of Tripetto module in Integromat
Add a Tripetto trigger in your Integromat scenario.

Step 4 - Create Google Docs file

  • Add a Google Docs module to your Integromat scenario. As action select Create a Document from a Template.
  • Grant access to your Google account.
  • Under Document ID select your earlier created Google Docs template file.
  • If you have used variables in your template, you will now see those variables in Integromat. For each variable you can now select the corresponding data field from your Tripetto form. This is the part where you map the entered data from your Tripetto form to the variables in your Google Docs template.
  • Under Title you can enter the file name of the file. We advise to include the email address field from your Tripetto form into this, so you can recognize the different files in your Google Drive.
  • Under New Document's Location select the folder where the newly create document will be stored. We advise to store the files in a dedicated folder.
  • Test this scenario up to this point. Check if the Google Docs file gets created in the selected folder and the variables in your template are replaced with the form data.

The result of this step is you now have automated the creation of a new Google Docs file for each Tripetto form submission, including values from the Tripetto form data.

Screenshot of Google Docs module in Integromat
Add a Google Docs module in your Integromat scenario to create a new file.

Step 5 - Download PDF document

  • Add another Google Docs module to your Integromat scenario. As action select Download a Document.
  • Under Document ID activate the Map toggle. Now select the Document ID that's outputted from your previous Google Docs module.
  • Under Type select PDF Document (.pdf) to download it as a PDF file.

The result of this step is your Integromat scenario now has access to the PDF file, which we will use in our email message.

Screenshot of Google Docs module in Integromat
Add a Google Docs module in your Integromat scenario to download the new file.

Step 6 - Send email with PDF attachment

  • Now add a Gmail module to your Integromat scenario. As action select Send an Email.
  • Grant access to your Google account. Please make sure your Google account includes Gmail. Please note that you might have to take additional steps to be able to send emails via Gmail from Integromat (see instructions).
  • Under To enter the recipient. To email to the respondent of your form, select the email address from the Tripetto form data.
  • Under Subject and Content you can now enter the desired subject and message of the email. You can also use Tripetto form data in those texts.
  • Under Attachments select the option Google Docs - Download a Document. That will automatically use the PDF download from your previous module.

The result of this step is an email message will be sent to the entered recipient, with the entered subject and content, including a PDF attachment with the personalized Google Docs template.

Screenshot of Gmail module in Integromat
Add a Gmail module in your Integromat scenario to send an email with attachment.

Step 7 - Test and activate

  • Click Run once in Integromat to start testing your automation.
  • Fill out and submit your Tripetto form once.
  • Check if your Integromat scenario has been processed correctly. If so, check the Inbox of the recipient to receive the email and check if everything is okay.
  • Activate your scenario in Integromat.

From now on this scenario will be executed automatically for each new form submission! Every respondent will now receive an automated email message with a personalized PDF file as attachment 🎉

Screenshot of Gmail message
The automated email to the respondent, including the attachment.

Other examples

Tripetto lets you connect to 1.000+ services. We have made some step-by-step examples for often used scenarios:

In this article

    Help us improve