Google Forms dropdown not updating from Google Sheets?
A Google Forms dropdown will not automatically stay linked to a Google Sheets range by default. If your choices are stale, missing, duplicated, or still showing old values, start by checking the source data, the mapping, and whether an update actually ran.
Google Forms does not natively sync dropdown choices from Sheets
A Sheets data validation dropdown can point at a range, but a Google Forms dropdown is a form question with its own stored choices. To keep it aligned with Sheets, you need manual copy/paste, Apps Script, or an add-on workflow that updates the question choices.
If the list changes rarely
Paste the choices manually before launch and inspect the form preview.
If you maintain code
Use Apps Script and be ready to manage form IDs, question item IDs, triggers, and authorization.
If you want a sidebar flow
Use FormRanger to select the spreadsheet, map one question, run Preflight, and Update now.
If the list is mission-critical
Do a copied-form test first and keep a manual fallback for the first launch.
What to check when choices do not update
Confirm the Google Sheet still contains the values you expect in one clean source column.
Remove blank rows, duplicate values, old notes, hidden helper text, or mixed data from that source column.
Check that the target Google Forms question is a supported choice question such as dropdown, multiple choice, or checkbox.
Confirm the spreadsheet is still accessible to the Google account running the add-on or script.
Run Preflight or your equivalent validation before updating the live form.
Use Update now, reload the form preview, and check the respondent-facing version, not only the editor.
For the first test, use only two obvious values such as Alpha and Beta. This makes it easy to see whether the form is truly updating from the selected sheet data.
Common failure patterns
The sheet changed
The tab, column, header, or data range changed after the mapping was created.
The form question changed
The dropdown was deleted, duplicated, renamed, or changed to another question type.
The account lost access
The selected spreadsheet moved, was shared differently, or is owned by another account.
The old choices are cached in your view
Refresh the respondent preview or open the public form link in a new tab before judging the result.
If the dropdown represents real seats, inventory, payments, or reservations, do not treat Google Forms as a strict stock-control system. Use a safety buffer or a purpose-built system for high-stakes availability.
Safe first-run fix with FormRanger
Create a copied Google Form with one test dropdown question.
Create a small Google Sheets source column with two choices.
Install FormRanger and select the source spreadsheet through Google Picker.
Map the dropdown question to the source column.
Run Preflight, then click Update now.
Open the form preview and confirm the dropdown shows the sheet values.
If the copied form updates correctly, move the mapping to the real form and real sheet column. After a successful first run, leave a short Marketplace review or send setup feedback with the question type, source sheet pattern, and whether Preflight helped.