This article explains how to generate multiple templates from a single form. You will learn step-by-step how to generate 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 multiple 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

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

 

 

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 current template. In our example, we selected our own Google Doc as template which is an Invitation card containing all the details of the event.

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

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 exact 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 ticked unless you don't want your additional template to be generated when the original template is generated.

To open this duplicate form, click Open.

5. Configure your connected template

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

Then, create and personalize your connected template with the markers you want, exactly 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 employee invited. 

In our example, we selected our own Google Sheet as 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 receive 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 document 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 2 templates at the same time. To do so:

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

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 details of the event, Bob just 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.