If you want to edit data submitted in a Google Form that does not allow re-editing, you will need to obtain the re-edit URL via a Google Apps Script program.
*Anyone can edit the data if they know the re-edit URL, so please handle it with care.
STEP 1. Outputting Google Form data to Sheets using "Link to Sheets"
STEP 2. Decide which column to save the re-edit URL in.
STEP 3. Set Google Apps Script in the Sheets.
This will take you to the code entry screen shown below.
2. Copy the template of Google Apps Script
Access the link below, select all of the program code displayed, and paste it into the code section.
- Program source (GitHUB)
3. Change two settings.
1. saveTocolumn
Please specify the column number for which you want to put an edit URL. Please note that the selected column value is overwritten.
A = 1, B = 2, .... D = 4, ....
If you specify "saveTocolumn" value is 4, the re-edit URL will be overwritten to column D.
2. formID
Please paste your Google Form's ID between the single quotes.
You can find the ID in the form's URL (between /d/ and /edit)
ex. formID
https://docs.google.com/forms/d/[formID]/edit#responses
- const formID = '[formID]';
3. Set the project name and save the Project in Google Apps Script
After changing the two values, save your Google Apps Script.
STEP 4. Run the Google Apps Script
Click on "Go to Untitled project (unsafe)" link.
You should then be able to find the re-edit URL on the sheets.
Troubleshooting
1. If you see the following error on the sheet, it means that "saveTocolumn" is not set correctly in the code.
2. If you see the following error in your sheet, it means that the formID is not set correctly in your code.
20 October 2025 @kimipooh
.png)
.png)
