Generate multiple files from one Google Form

timer 5 min.

Click on the flowchart to zoom in

stars What you'll learn

• Configure a Google Form
• Use 'File upload' question on connected form
• Generate conditional templates based on response submitted

check_circle Prerequisites

• Good knowledge of Google Form
• Knowing how to configure Form Publisher
• Knowing ho to use conditional template with section

mode_edit Running a simple example

1. If the respondent answers 'No' to join the event: the right person receives the date of future events as
   Google Doc.
2. If the respondent answers 'Yes' to join the event: the right person receives the event details as Google Sheet.

 

1. Create a File upload question based on response submitted

Configure your Google Form:

In our example, we want to add two sections based on response submitted:

To know how to add and configure different sections, we recommend reading ‘2. Add different sections’ from the following article: Generate conditional documents based on specific answers to related sections

To add a ‘File upload’ question click on the dropdown menu:

Click ‘File upload’:

Then, configure your ‘File upload’ question:

Once you are done with your original form configuration, open Form Publisher.

To know how to open and to configure Form Publisher, we recommend to follow the steps starting from the article: [Step 2] Open Form Publisher

From your template sidebar, click 'Matching markers':

If you want to display your file as image in your template, then select 'Insert as image' option. However, a clickable link will be displayed:

In our example, if the respondent answers ‘No’ to ‘Will you join us?’ question he will receive a template suggesting future events as Google Document:

Once you have configured Form Publisher on your original form, click ‘Additional template’ to add your connected form:

From the ‘Additional template’ sidebar, click ‘Get Started’:

In our example, we want to ‘Create connected template’ IF the respondent answers ‘Yes’ to 'Will you join us' question:

Click 'Save':

Then, to open your connected form, click ‘Open’:

From your connected form, your ‘File upload question’ will be marked as ‘Short answer’.

Open Form Publisher > Click ‘Get Started’.

If the respondent answers ‘Yes’, he will receive a template summing the event details as Google Spreadsheet:

Once you are done, save your Form Publisher configuration.

2. Submit your Google Form

2.1 The respondent answers 'No'

If the respondent answers ‘No’ to the ‘Will you join us?’ question:

And clicks ‘Submit’:

A confirmation message appears:

The generated file is sent to the right recipient as Google Document:

2.2 The respondent answers 'Yes'

If the respondent answers ‘Yes’ to the ‘Will you join us?’ question and clicks ‘Next’:

The respondent is redirected to the ‘ID card’ section. He will need to add a file:

And clicks ‘Submit’:

A confirmation message appears:

The generated file is sent to the right recipient as Google Spreadsheet:

The recipient will have to click on the link to upload the file: