Safe workflowtest first
Google Sheetssource list
Sessionslive rows
A, B, C options
Google Formspublic form
Capacityper option
full option message
1. Sync2. Limit3. Preview
Workflow guide
Workshop registration from Sheets to Forms.
For workshops, the list of sessions often changes in Sheets while each session has a different seat count. Use FormRanger for the changing list and FormGuard for capacity rules.
Recommended setup
Use Google Workspace add-ons for the boring operational layer, then test the live-facing form before sharing.
1
Keep sessions in Sheets
Store workshop names, times, and seat labels in a clean source sheet.
2
Sync to Google Forms
Map the sheet range to the form question before launch.
3
Add capacity checks
Set per-session quotas, waitlist text, and alerts, then test with fake submissions.
Related guides
Use these if the workflow changes from synced choices to real capacity control.
FAQ
What should live in Sheets?
Session names, labels, owners, and operational notes belong in Sheets. The public form should only show clean choices.
How do I handle waitlists?
Write a full-message or alternate link before launch so users know what to do when a session fills.
Do I need both add-ons?
Use both only if you need both dynamic choices and capacity limits. If the list never changes, FormGuard may be enough.