FRFormRanger
Google Forms + Sheets add-on

Sync Google Forms choices from Sheets.

FormRanger maps selected Sheets columns into Google Forms dropdown, multiple-choice, checkbox, and grid choices. Start with one question, run Preflight, update once, then check the public respondent preview.

Free during public launch. Tested on the real Google Forms add-on path: sidebar mapping, save, Preflight, Update now, and respondent preview.

Dropdown Multiple choice Checkbox Grid choices Preflight Free launch
Install from Marketplace Run first-run test
First-run pathSheets to Forms
Google Sheetsource column
HeaderSession
Alpha, Beta, Workshop A
Google Formchoice question
QuestionChoose a session
Choices updated from the selected column
FormRangerWorkspace add-on

Link one question, run Preflight, update choices, and verify the respondent-facing form before launch.

Update verified
1. Select source2. Preflight3. Update4. Public preview

Keep form choices in sync with a Sheet.

Use FormRanger when Google Sheets is the source list for a Google Forms question.

1

Dropdown and multiple choice

Refresh sessions, departments, locations, products, or categories from Google Sheets.

2

Checkbox lists

Update multi-select choices without maintaining Apps Script.

3

Grid choices

Keep row or column choices aligned before sharing the form.

First-run proof

Do one small update before trusting a live form.

Use a copied form, one supported choice question, and one Sheets column with Alpha and Beta. A successful first run means Preflight passes, Update now reports an updated question, and the public preview shows the expected values.

Install FormRanger Open first-run checklist
Install

Open the add-on inside the Google Form you want to update.

Preflight

Check file access, sheet tab, column, and question mapping before changing choices.

Preview

Open the respondent-facing preview after Update now, not only the editor.

Run the checklist Read setup guide Watch demo
Boundary

Not a booking or inventory lock.

FormRanger updates Google Forms choices from selected spreadsheet data. It does not reserve seats, process payments, or change choices while a respondent is already filling out the form.

Fix dropdown not updating Read permissions

Frequently asked questions

Which question types work?

Dropdown, multiple choice, checkbox, multiple-choice grid, and checkbox grid choices.

What should I test first?

Use one copied form, one supported question, and one Sheets column with Alpha and Beta. Run Preflight, update, then check the public respondent preview.

Can it handle dependent dropdowns?

Use FormRanger for spreadsheet-backed choice refresh before respondents use the form. It is not respondent-time conditional filtering.

Install from Marketplace Setup support