Map one question, run Preflight, update choices, then inspect the public preview.
Ready to verifySync Google Forms choices from Sheets.
Use one clean Google Sheets column as the source for Google Forms dropdown, checkbox, multiple-choice, or grid choices. Start with a copied form, run Preflight, then update the live choices only after the preview looks right.
The whole setup in one line
Put choices in one clean Sheets column, map one form question, run Preflight, click Update now, then check the public preview.
Three-step visual path
Prepare Sheets
Keep valid options in one tidy source column.
Map the question
Select a dropdown, checkbox, multiple-choice, or grid question.
Update and preview
Run Preflight, update choices, and verify the live form.
Use it when the list changes before people answer
Departments, locations, sessions, categories, checkbox lists, and grid rows maintained in Sheets.
Live booking, payment, inventory locking, or respondent-time dependent dropdown logic.
Need to see it once?
Watch one source range update one Google Forms question.
Open YouTube demoUse a copied form, one question, and two sheet values before editing a live form.
Open test guideNext steps
- Fix not updatingTroubleshoot stale dropdown choices.
- Import choicesUse a Sheets source column for supported Forms questions.
- FormRanger supportSend the source tab, mapped question type, and public preview result.
FAQ
Can Google Forms choices come from Google Sheets?
Yes. FormRanger maps selected sheet data to supported Google Forms choice questions.
What should I test first?
Test one copied form, one question, and two sample sheet values before using a real workflow.
Can it reserve options while someone fills the form?
No. It updates form choices from Sheets; it is not a live reservation or inventory-locking system.