Generate multiple documents with one Google Form

This article explains how to generate multiple templates from a single form. You will learn step-by-step how to create and send different documents to different recipients from only one Google Form submission.

Generate multiple files from one Google Form

timer 20 min.

stars What you'll learn

Link multiple templates
Generate numerous files from those templates

check_circle Prerequisites

Good knowledge of Google Form
Knowing how to configure Form Publisher
Understanding templates & markers

mode_edit Running a simple example

Alice, the event manager, wants to invite Bob's team to an event.
Alice submits a Google Form with details on the event (price, attendees, date, location etc.).
Bob receives the invitation card to share it with his team and Marc, the HR manager, receives the invoice with all the event details.

1. Create your original Google Form

Create your Google Form with the questions you want. Once you are done, open Form Publisher > Get started.

2. Configure your current template

Create and personalize your existing template. In our example, we selected our own Google Doc as a template, an Invitation card containing all the event details.

Click Select template, check that all your markers are valid and click Next.

info If you want to change your Google document, click the Edit icon.

3. Configure Form Publisher on your original form

Configure the Destination folder and naming convention sidebar as you need and click Next.

On the Sharing options and notifications sidebar, add the recipient who will receive the file every time someone submits the form. Then, click Next.

In our example, the generated Google Doc is sent to bob.fordemos@gmail.com.

4. Add a new template to your current form

After completing the previous step, open the add-on menu again.

Then, click Form Publisher > Additional template. A new sidebar appears. Click Get started.

Then, Form Publisher duplicates the current Google Form into a new one (renamed Connected to Event), with the same questions. The connected form is automatically linked to your current form. So every time someone submits the original form, data will be forwarded to the connected one.

By default, Activate additional template is ticked, make sure it is unless you don't want your additional template to be generated when the original template is created.

To open this duplicate form, click Open.

info Form Publishers select Always create both templates by default. Leave this option selected if you want to send multiple templates from one Google Form. Please read this article: Conditional template: Generate different templates based on response submitted to know more about the other options.

5. Configure your connected template

On the connected Google Form open Form Publisher > Get started.

info Once you connected your form, if you want to add questions on any of the two forms, you have to add it manually on the other one.

Then, create and personalize your connected template with the markers you want, precisely as you did for your original Google Form.

In our example, we created an invoice with all the details of the event. We also added a formula that multiplies the Ticket Price by the Number of employees invited.

In our example, we selected our own Google Sheet as a template. Click Select template, make sure that all markers are valid and click Next.

6. Configure Form Publisher on the connected form

Configure the Destination folder and naming convention sidebar as you need and click Next.

Finally, on the Sharing options and notifications sidebar add the recipient who receives the file each time someone submits the form. Then, click Next.

In our example, the generated Google Sheet is sent to marc.walkerd@gmail.com.

Both documents are sent to different email addresses depending on your configuration.

7. Add a third or more templates (optional)

This option is useful if you want to send more than two templates at the same time. To do so:

Open Form Publisher from your connected template
Click Additional template
Configure the Connected to Event form by adding a new template
Select Create both templates in the Sharing options and notifications sidebar

info Please note that each time you want to duplicate your Google Form you have to click Additional template from your last duplicated form.

warning For one single form submission by your respondent (on the original form), Form Publisher generates as many documents as the number of templates you have set up. However, we recommend adding three templates maximum (or connect 3 Google Forms) to the original Google Form. In that case, it avoids any potential files generation conflicts with Form Publisher.

8. Send your Google Form

Once you are done with all the configurations, open your original form. In our example, we go back to the Event file.

Then, click Send.

Every time your respondent submits a form (on the original one), Form Publisher generate the files as Google Doc and Google Sheet.

In our example, bob.fordemos@gmail.com receives the Invitation Card (Google Doc).

The Invitation Card contains all the event's details, Bob only has to share it with his team.

And marc.walkerd@gmail.com receives the Event invoice (Google Sheet).

The Event invoice contains all the details of the event as well, allowing Marc to know the costs of this event, to refund the employees.

Generate documents – such as quotes, purchase requests, agreements, or presentations – from Google Forms