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
- You configured Form Publisher.
- Your form has been submitted (either from a test submission or from a recipient).
- You checked the responses submitted in your responses spreadsheet.
- 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?)
- 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.
Proceed for each named range if you have more.
You changed a column's name on your header
- Moving or adding columns and/or rows
- Adding new sheets
- Rename titles header (questions, timestamp)
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.
Proceed for each named range.
Then, please refer to the table below, which contains the specific names of your named ranges:
|Name of the header column
|Name of the Named Ranges
|To know more...
This column automatically appears in your responses spreadsheet: Standard markers to be reused in your template
[Form Publisher] Increment
This column appears automatically in your responses spreadsheet if you select Keep increment in the Destination folder and naming convention sidebar
[Form Publisher] Doc URL
This column appears if your template is a Google Doc. To know more: [Step 3] Select your template
[Form Publisher] Sheet URL
This column appears if your template is a Google Sheet. To know more: [Step 3] Select your template
|[Form Publisher] Presentation URL
This column appears if your template is a Google Slide. To know more: [Step 3] Select your template
|[Form Publisher] Microsoft file URL
This column appears if you select
[Form Publisher] PDF URL
This column appears if you select Keep PDF copy in Drive in your Destination folder and naming convention
|[Form Publisher] Approval
|This column appears if you activate the Approval Workflow option. Either Pending, Approved or Rejected status will appear under this column. To know more: [Part 5] Monitor the status of each request from your spreadsheet
|[Form Publisher] Comment
This column appears if you activate Approval Workflow option. Each comment from the validator will appear under this column. To know more: [Part 3] Ask for more information / add comment to a request
|[Form Publisher] Approver
This column appears if you activate Approval Workflow option. The validator’s email address will appear under this column. To know more: [Part 5] Monitor the status of each request from your spreadsheet
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.
Proceed for each named ranges' column.
If the above article does not resolve your issue, please submit a request to our customer support service: