Quick answertest before sharing
Google Formspublic form
Problemnative gap
manual updates break
FormSuiteadd-on workflow
Fixguided setup
small preflight test
Google Sheets to Google Forms
Populate a Google Forms dropdown from a spreadsheet.
Populate a Google Forms dropdown from a Google Sheets column and refresh the choices without maintaining a custom Apps Script.
Recommended setup
Use this when your list changes in Sheets and the form should follow that source list.
1
Clean the source column
Keep one choice per row. Remove blank rows, duplicate labels, and helper notes from the live range.
2
Map the range to the question
Choose the Google Form question that should receive the Sheet values.
3
Refresh and preview
Update choices, then open the public form link to verify respondents see the new dropdown.
When this beats Apps Script
Apps Script is fine for one-off internal forms. An add-on workflow is easier when non-developers need to update the list, test it, and avoid trigger maintenance.
Related guides
Use these next if your workflow changes.
FAQ
Can Google Forms read dropdown choices directly from Sheets?
Not natively. You need Apps Script or an add-on to copy Sheet values into the Form question choices.
Does the public form update automatically?
Always verify the public form after a refresh. The editor view alone is not enough.
Can this work for multiple-choice too?
Yes, the same source-list workflow can apply to dropdown, multiple-choice, checkbox, and supported grid questions.