2. Save generated files URL in a spreadsheet

*** A new version of this article is available on this page ***

Where are my generated files stored?

All your files created are stored in a specific Drive folder.

Defining a relevant naming convention will help you find the document(s) you are looking for at a glance:

Store your generated files URL in a spreadsheet

It might also be useful to store the URL of each file created in the spreadsheet filled with your Form responses.

To do that, open your Google Form, use the menu 'Add-ons > Form Publisher > Destination folder & Naming convention'.

Then, check the box 'Save generated file URL':

If you want to save the increment in a spreadsheet (which corresponds to the number of the response), you can also tick the box 'Save increment'.

After that, you can click on the button 'Responses' in Google Form to open the spreadsheet containing your Form responses:

On that sheet, you should see 1, 2 or 3 new columns, depending if you are also asking Form Publisher to generate a PDF.

Important notes

    • URLs of files created will be added for all new form submissions, but not for the old ones.

    • Please do not rename those columns as Form Publisher is using the column headers to write the info in the right column.