Fill Google Forms dropdowns from a Google Sheet
Keep the employee list, the event sessions, the meeting rooms or the product codes in a spreadsheet. Choice Sync copies that column into your form's answer options, so you never retype a list or leave stale choices in a form.
Status: in final testing. Choice Sync isn't available in the Google Workspace Marketplace yet, and the plans below may change before launch.
How it works
- In your form, open the add-ons menu → Choice Sync → Open Choice Sync.
- Pick a dropdown, multiple-choice or checkbox question.
- Choose the spreadsheet, tab and column with your options, then click Save & preview.
- Click Sync all now, or turn on auto-sync (Pro).
Built to be safe with your form
- Blank cells are skipped, extra spaces are trimmed and duplicates are removed.
- Keep sheet order, or sort A→Z or Z→A, with numbers in natural order (Room 2 before Room 10).
- It won't wipe a question by syncing an empty column.
- Your "Other" option stays on.
- Every sync is logged in the sidebar, so a failure is never silent.
- Minimal permissions: it can see only this form and only the spreadsheet you pick. It can't see the rest of your Drive. Privacy details.
Plans
| Free | Pro | |
|---|---|---|
| Linked questions per form | 1 | Unlimited |
| Manual "Sync all now" | ✓ | ✓ |
| Auto-sync (hourly and after each response) | – | ✓ |
| Price | $0 | about $4.50/month |
Common uses
- HR and ops: an employee or department picker that updates when the staff sheet changes.
- Events: session or time-slot choices taken from your schedule sheet.
- Facilities: rooms, vehicles or equipment that people can request.
- Sales and inventory: product or SKU lists for order and request forms.
Support
Email [email protected]. We reply within 2 business days.