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 generate/send different documents to different recipients from only one Google Form submission.

 

Generate multiple files from one Google Form

timer 20 min.

Click on the flowchart to zoom in

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. Simon wants to offer an event ticket to Delphine
2. The event manager submits a Google Form with details on the event (price, attendees, date, location etc.)
3. Simon will receive the invoice and Delphine the invitation card

 

 

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.

Click 'I have my own template', check that all your markers are valid, and finally click 'Next':

3. Configure Form Publisher on your original form

Once you have configured everything click 'Next' again.

On the 'Sharing Options & Notifications' screen, add the recipient who will receive the file every time someone submits the form. Then, click 'Done'.

In our example, the generated Google Doc will be sent to delphine.leroy@revevol.eu.

4. Add a new template to your current form

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

Then, click Form Publisher > 'Add new template'. A new sidebar appears. Click 'Get started':

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

To open this duplicate form, click 'Connected to Event':

If you want to access your connected template from your original template, open Form Publisher. Then, click 'Additional template settings' (which replaced 'Add new template'):

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 selected our own Google Sheet as template. Click 'I have my own template', make sure that all markers are valid, and click 'Next':

6. Configure Form Publisher on the connected form

Once you have configured everything click 'Next' again. 

Finally, into 'Sharing Options & Notifications' add the recipient who will receive the file each time someone submits the form. Then, click 'Done':

In our example, the generated Google Sheet will be sent to simon.debray@revevol.eu.

Both document will be 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 ‘Add new 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 will generate the files as Google Doc and Google Sheet.

In our example, delphine.leroy@revevol.eu will receive the invitation card (Google Doc):

And simon.debray@revevol.eu will receive the invoice (Google Sheet):