Audeza Choice Sync

Your Google Forms choices, kept in sync with a Sheet.

Pick a column. Its values become the choices of a dropdown, multiple choice, checkbox or grid question, and they stay current as the sheet changes.

  • Free for 3 questions per form
  • Opens only the sheet you pick
  • Emails you when a sync fails
Rooms sheet
Booking form

Set up a question in about two minutes.

The idea is the same as Form Ranger: the question on one side, the column on the other.

  1. Put your choices in a column

    Staff names, products, rooms, class sections. Row 1 can be a header.

  2. Link a question

    Open the add-on from the puzzle-piece menu in your form. Pick the question, then the spreadsheet, tab and column.

  3. Save and sync

    The choices fill in right away. After that, the add-on syncs on every response, every hour, and whenever you click Sync.

Step-by-step: time slot sign-ups · choice eliminator · conference sign-ups · dynamic dropdowns · populate from a sheet

Built to fail loudly, never quietly.

Most populate add-ons work until they don't, and you find out from someone who couldn't pick their name. This one tells you first.

A run log for every question

See what each sync changed, and why one failed, right in the sidebar.

UpdatedRoom · 1 added, 1 removed
No changeStaff · 42 choices
FailedStaff · header "Name" not found in row 1

Limited slots

Remove a choice once it's taken, or after N picks. Limits can come from a column. Delete a response and the slot opens again.

Intro to Sheets9 / 12 seats
Advanced formulas12 / 12 · removed
Apps Script basics3 / 30 seats

An email when it breaks

A failed sync keeps the old choices and emails you the reason. At most one email per question and error per day.

No full Drive access

The add-on can open the spreadsheet you pick and nothing else in your Drive.

Clean lists

Blanks are skipped and duplicates appear once, so a messy column never breaks a sync.

Switching from Form Ranger? Same setup, fewer surprises.

Audeza Choice Sync

  • Empty or broken sheetKeeps the old choices and tells you why
  • Run historyPer-question log with counts and errors
  • Failure alertsEmail, once per question and error per day
  • Duplicates and blanksCleaned automatically
  • Drive accessOnly the file you pick
  • SupportEmail, answered by the developer

Typical free populate add-on

  • Empty or broken sheetCan wipe the list
  • Run historyNone
  • Failure alertsNone
  • Duplicates and blanksCan fail the sync
  • Drive accessOften your whole Drive
  • SupportForum

Read the full comparison with Form Ranger

Free for most forms. $49 a year when you need more.

Every plan has the run log, failure emails and limited slots. Plans differ only in how many questions you can link.

Free

For a form or two with a few synced questions.

$0

No card needed

Install free
  • 3 linked questions per form
  • Run log and failure emails
  • Limited slots
Best value · save 32%

Pro

For one person who runs many forms.

$49 / year

or $6 / month

Buy Pro yearly
  • Everything in Free, plus:
  • Unlimited questions on every form
  • Priority email support

Domain

For a school or company where several people build forms.

$199 / year

One invoice for everyone

Buy for my domain
  • Everything in Pro, plus:
  • Pro for every account on your domain
  • No per-seat counting

Buy with the same Google account you use in Forms, then click "Check my license" in the sidebar. Polar handles payment, sales tax and VAT.

Before you install

Does the form update the moment I edit the sheet?

Not instantly. Google doesn't let a Forms add-on watch another file for edits, so changes show up at the next response or the hourly run. Click Sync in the sidebar if you need them live right away. Form Ranger has the same limit.

What happens if the column ends up empty?

The sync stops and the question keeps its current choices. You get a log entry and an email that say why. A question is never wiped because of an empty sheet.

Which question types work?

Dropdown, multiple choice, checkboxes, and the rows of multiple choice grid and checkbox grid questions. Limited slots work on the first three.

What can the add-on see in my Google account?

The form you open it in, and the spreadsheets you pick with Google's file picker. It can't browse the rest of your Drive. The privacy policy lists every permission and why it's needed.

Can other editors of the form use it?

Yes. Links and the run log belong to the form, so every editor sees them. Auto-sync runs under the account of whoever turned it on.

How do I cancel?

Use the link in your receipt email. You keep Pro until the end of the period you paid for, then the form keeps syncing its first 3 questions.

Link your first question.

Free for up to 3 questions per form, with every feature on.