You want to retrieve your URLs in your responses spreadsheet, but they are missing. You received an email informing you that Form Publisher failed to write in your spreadsheet. This article explains the main reasons for this issue and how to solve it.

How to retrieve your file URLs in your responses spreadsheet?

You have sent a Google Form, and after receiving multiple responses, you want to retrieve your file URLs in your responses spreadsheet.

Unfortunately, all or parts of the URLs are missing.

Several reasons can explain your issue. We suggest checking the different points listed below.

Check your Form Publisher configuration

Ensure you have selected Keep file URL and Keep increment in your Destination folder and naming convention sidebar.

An error message appears: your responses spreadsheet is missing

You want to save the Form Publisher configuration, but an error message appears.

If the Keep increment or Keep file URL options are enabled, Form Publisher needs the responses spreadsheet to generate files.

Only the first URLs’ submissions and increment numbers are missing

1. You configured Form Publisher.
2. Your form has been submitted (either from a test submission or from a recipient).
3. You checked the responses submitted in your responses spreadsheet.
4. Google Form asked you to either create a new one or upload an existing one (to know more: How to retrieve your Google Form responses?)
5. The URLs of the first submissions are missing.

Refresh the Google form page before opening your responses spreadsheet to prevent this issue.

Form Publisher doesn’t save the file URLs and increment numbers anymore

You have different sheets in your responses spreadsheet

Once you have created your Google form, all the data is automatically input into a Google spreadsheet.

If you want to create another spreadsheet after multiple responses, you can either create an entirely new spreadsheet or select an existing one (a new tab will be created at the bottom of your current spreadsheet).

In our example, we decided to create a new spreadsheet. Click Select.

You can see at the bottom of your spreadsheet a new sheet called Form Responses 2 by default.

Each time a respondent will submit a form, all the responses will be saved in your new tab. However, the file URLs and the increment columns will be missing.

From your new Google Sheet, click Data > Named ranges.

A sidebar appears.

You will have to delete the named ranges. Then, refresh the page and Form Publisher will automatically create new ones after a new submission.

To do the above, click on the pencil icon.

Click on the trash icon.

Click Remove.

Proceed for each named range if you have more.

You changed a column's name on your header

If you have changed a title on your header and Form Publisher can't retrieve the named ranges associated, your URL will be missing.

Each time a form will be submitted, the URL and the increment will be missing.

To solve the above issue, you will need to change the named ranges from your new tab.

On the Named ranges sidebar, click + Add a range.

A new named range appear.

To do the above, click on the pencil icon.

In our example, we decided to delete our named ranges. Click on the trash icon.

Click Remove.

Proceed for each named range.

Then, please refer to the table below, which contains the specific names of your named ranges:

Copy only your Google Form ID framed in red.

Go back to your spreadsheet, select your Timestamps column > Click + Add a range.

On the first field, write the name of the named ranges associated with Timestamps.

Click Done.

Proceed for each named ranges' column.

If the above article does not resolve your issue, please submit a request to our customer support service: