Quietools Lists
Keep the choices of a Google Forms™ question in sync with a list in Google Sheets™.
Quietools Lists is an add-on for Google Forms™. You pick a spreadsheet and a range, and the add-on uses that list as the choices of a dropdown, multiple choice or checkbox question. When the list changes, the form follows: when you click Update now, or automatically after each response.
How it works
- Open your form and start Quietools Lists from the add-ons menu.
- Choose a question, pick your spreadsheet in Google’s file picker, and enter the range to read, for example Sessions!A2:A. Empty cells and duplicates are skipped.
- Edit the spreadsheet. The question’s choices update when you click Update now, or after each response with the full version.
Made for lists that change
- Workshops, classes and appointments with a limited number of places.
- Order forms whose product list lives in a stock spreadsheet.
- Internal requests that list people, rooms, sites or projects.
When something goes wrong
- If the spreadsheet can’t be read, because a tab was renamed or a file moved, your current choices stay in place and the add-on tells you what to check.
- Before each change, the previous list is kept. One click puts it back and pauses the link while you fix the spreadsheet.
- When a list runs empty, the question can show a message such as “Full: no places left”, or the form can close and reopen by itself once the list fills up again.
Permissions, and why
Quietools Lists asks for the narrowest access that does the job. Google shows these lines when you install it.
| Permission | Why it’s needed |
|---|---|
| See and manage the forms in which this application has been installed | To update the choices of the questions you link. It can’t open your other forms. |
| See, edit, create and delete only the specific Google Drive files you use with this app | To read the spreadsheets you pick in the file picker. It can’t open your other files, and it only reads them. |
| Allow this application to run when you are not present | To update the list after each response. |
| Display and run third-party web content in prompts and sidebars inside Google applications | To show its sidebar and Google’s file picker. |
| Connect to an external service | To check a license key with Polar, our payment provider. Only the key and an activation label are sent. |
Your form and spreadsheet data stay in Google. Quietools has no servers that store them. Read the privacy policy.
Pricing
Free
No account, no card.
- One link per form
- Update when you click Update now
- Restore previous choices
- English, French, Spanish, Portuguese, Italian and German
Full version
Everything in Free, plus:
- Unlimited links
- Automatic update after each response
- Automatic closing and reopening of the form
- Yearly, up to 3 Google accounts€29 / year
- Lifetime, up to 3 Google accounts€79 once
- Team, up to 25 Google accounts€99 / year
Payments are handled by Polar, our merchant of record. Taxes are calculated at checkout.
Questions
Does Quietools Lists store my data?
Only the settings it needs, such as which question is linked to which range, and the previous list so you can restore it. They are saved inside your form, in Google. Nothing is copied to a Quietools server.
Which questions can it fill?
Dropdowns, multiple choice questions and checkboxes.
Which languages does it speak?
English, French, Spanish, Portuguese, Italian and German. It follows the language of your Google account.
Can I move my license to another Google account?
Yes. In the sidebar, click Remove the license from this account, then activate the key on the other account. You can also free an activation from your Polar customer portal.
What happens when a yearly plan ends?
Your links stay and keep working with Update now. Automatic updates and automatic closing stop until you renew.