FRFormRanger
Google Forms + Sheets add-on

Keep form choices synced from Sheets.

FormRanger turns spreadsheet ranges into live dropdown, checkbox, and multiple-choice options so teams stop copy-pasting lists into Forms.

Sheet ranges Dropdown sync Checkbox options Refresh controls
Install from Marketplace
Choice sync previewSheets → Forms
Google Sheetsource range
Rows found128 choices
Workshop A, Workshop B, Workshop C
Google Formdropdown question
QuestionChoose a session
Choices updated from sheet
FormRangerWorkspace add-on

Pick a sheet range, map it to a question, preview the choices, and refresh when the source changes.

Sync ready
1. Configure2. Preview3. Launch

A focused workflow, not another bulky form builder.

Each FormSuite add-on does one operational job around Google Forms, Sheets, Docs, or Gmail — then gets out of the way.

1

Select source data

Choose the spreadsheet and range that owns the list.

2

Map to a question

Connect the range to a dropdown, checkbox, or multiple-choice item.

3

Refresh safely

Preview and update the form when the sheet changes.

Watch the demo.

Watch the workflow once, then run a small test in your own Google file.

Frequently asked questions

Does it replace FormGuard?

No. FormRanger syncs choices from Sheets. FormGuard controls limits, quotas, alerts, and close behavior.

Can it sync dropdowns and checkboxes?

Yes. It is built for Google Forms choice questions that should be maintained from spreadsheet data.

Should the sheet be the source of truth?

Yes. Keep the list in Sheets, then refresh the form choices from that source.