How to populate a Google Forms dropdown from a Spreadsheet?
This is a common question from Google Sheets users who keep a long list in a sheet. For example, your dropdown has hundreds of choices, such as a list of suppliers. Google Forms lets you paste the options into a dropdown by hand, but it can't fill a dropdown from a Sheet on its own, so the form falls behind each time the list changes. You can write an Apps Script instead, but someone has to write it and fix it. With Formfacade, you can connect your sheet and populate dropdown options using simple instructions in plain English or any language. Your respondents will see the current list and can type a few letters to find their choice. Even better, your forms update from the Sheet every 30 minutes or each time someone submits and the responses are recorded in Google Forms as normal.
Let's start. Connect your Google Sheet to your form and follow the steps under Method #2 below.
Dropdown questions in Google Forms
A dropdown question allows respondents to select one answer from a list of predefined options. It is similar to a multiple choice question in that respondents can select only one answer from the available choices. Unlike multiple choice, the options are hidden until the respondent clicks the dropdown field. This works well for long lists where you want to keep the form compact.
How to add a dropdown question in Google Forms?
Open your form in Google Forms > click on the + add question icon > enter the question title > select Dropdown question type > Enter the answer choices in Add option > If you want to make the question mandatory, enable the Required toggle button.
Tip: Instead of adding each answer choice manually, you can copy the options from a spreadsheet and paste them into the first answer choice field. Google Forms will automatically split them into separate options.
Limitations
- Google Forms has a hard limit of 1,000 options per dropdown. Lists longer than this will not load correctly.
- There is no native way to pull options from a Google Sheet. Options have to be typed or pasted in manually.
- Any change to the list, whether adding, removing or editing an option, requires opening the form and editing it manually.
To overcome these limitations, you can use Apps Script or the Formfacade - Sheets Lookup add-on to populate a Google Form dropdown from Google Sheets.
Method #1: Google Apps Script
Apps Script allows you to automate tasks across Google Forms, Sheets, Drive and other Google Workspace apps. You can write a script that reads a column from your sheet and automatically updates your form's dropdown with those values. For example, if you have a Google Sheet with a list of 500+ suppliers, you can automatically populate the supplier dropdown in your form without having to add them manually.
How to set it up?
- Open your form in Google Forms > click on the ⋮ three dots menu in the top right > select Apps Script
- Apps Script page will open in a new tab > click Create script > paste the following script.
- Replace YOUR_FORM_ID and YOUR_SHEET_ID with the IDs from your form and sheet URLs. Replace QUESTION_TITLE with the exact title of your dropdown question as it appears in your form, including capitalisation and spacing.
- Once you make these changes, save your script and click Run to execute it. Google will ask you to authorize the script to access your form and sheet. Click Review Permissions, select your Google account and click Allow. Running it manually also lets you confirm the script works before setting up the trigger.
- Click the Triggers icon (clock) in the left sidebar > click Create a new trigger > In the dialog that opens, choose which function to run: select updateDropdown > Select event source: select Time-driven > Select type of time based trigger: choose Hour timer or Day timer > Select interval: choose your preferred frequency (for example, every hour or every day) and click Save.
How to find your Form ID and Sheet ID?
Form ID: Open your form in Google Forms. In the URL, copy the string between /d/ and /edit.
https://docs.google.com/forms/d/FORM_ID/edit.
Sheet ID: Open your Google Sheet. In the URL, copy the string between /d/ and /edit.
https://docs.google.com/spreadsheets/d/SHEET_ID/edit.
Limitations
- Requires writing and maintaining code. Scripts can stop working without any warning, leaving respondents with stale or missing options until someone notices and fixes the issue.
- Google Forms cannot display more than 1,000 options in a dropdown and Apps Script cannot bypass this limit.
- Each form needs its own script and trigger. If you have multiple forms pulling from the same sheet, you have to replicate and maintain the setup for each one.
Method #2: Use Formfacade - Sheets Lookup
You can use Formfacade to connect your Google Sheet to your form without any code. Describe what you want in plain English or any language and it will populate your dropdown with data from your sheet. The form stays in sync with your sheet automatically.
How to set it up?
Your Google Form needs a dropdown question and your Google Sheet needs the list of options.
- Click on Connect your Google Sheet to your form
- Click on "Populate a dropdown from Google Sheets" in the page that opens
- Paste your Google Form link and click Next. Formfacade will copy your questions
- Pick connected sheets page will be displayed. Select your sheet or click + Connect another sheet and click Next. If you have not connected a sheet yet, click Connect a Google Sheet and pick your sheet in Google's window
- "How do you want to connect?" will be displayed with an instruction written for you. Edit it in plain English and click Proceed. For example, populate the supplier dropdown with the names from the Supplier sheet
- "Your form is ready" will be displayed. Click Preview your form to see it
- Use the Formfacade share link to collect responses.
Your dropdown will show the options from your sheet and stays in sync when your list changes.
Why this approach?
- No Apps Script needed. Replace custom scripts and workarounds with a simple plain English instruction.
- Supports large lists. Handles hundreds or thousands of options with no performance limits.
- Flexible UI. Show a standard dropdown or enable search for autocomplete on long lists.
- Your sheet is the single source of truth. Update data in one place and every connected form reflects it automatically.
- Your sheet is never modified. Formfacade mirrors your data to serve forms fast and never uses write access to your sheet.
Limitations
- Requires a subscription to Formfacade - Sheets Lookup.
- Responses are recorded in Google Forms as normal, but you must use the Formfacade link instead of the native Google Forms URL to collect responses.
Comparison
| Apps Script | Formfacade - Sheets Lookup | |
|---|---|---|
| Requires code | Yes | No |
| Stays in sync automatically | Yes (if trigger works) | Yes (every 30 mins or on each submission) |
| Works past 1,000+ choices | No | Yes |
| One sheet, multiple forms | No, Separate script per form | Yes |
| Maintenance required | Yes | No |
| Cost | Free | Requires a subscription |
Use Apps Script if your list is under 1,000 options and you are comfortable writing and maintaining scripts. Use Formfacade - Sheets Lookup if you want a reliable, no-code option, especially if your list is large, changes frequently or needs to power more than one form.
Frequently Asked Questions
What happens when I add a new row to my sheet?
With Formfacade, the form syncs automatically with no action needed. By default, it syncs every 30 minutes or when the form is submitted. With Apps Script, the update happens the next time the trigger fires, hourly or daily depending on your schedule.
Is there a limit on how many options I can have?
Google Forms has a hard cap of 1,000 options per dropdown. Apps Script cannot bypass this. Formfacade handles lists of any size and converts long lists to a search-as-you-type interface automatically.
Can one sheet power dropdowns across multiple forms?
Yes. Both the import method and the add-on support connecting the same sheet to multiple forms. With Apps Script, you need a separate script and trigger for each form.
Can I control which options appear in the dropdown?
Yes, with Formfacade. You can deduplicate options to show only unique values, sort them or filter them by a condition. For example: "Show only suppliers where the Status column says Active."
Summary
If you keep your dropdown options in a Google Sheet, pasting them into your form by hand falls behind. With Formfacade, you connect your sheet and describe what you want in plain English. Connect your Google Sheet to your form with Formfacade. If you have any questions, write to support.
Last updated: