How to populate a Google Forms dropdown from a Spreadsheet?

You can use Apps Script or the Formfacade - Lookup Sheets add-on to populate a dropdown in Google Forms from Google Sheets. If you are comfortable with code, Apps Script gives you a scriptable way to sync your sheet with your form. If you prefer a no-code approach, Formfacade – Lookup Sheets lets you connect your sheet and populate dropdown options using simple instructions in plain English or any language.

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 – Lookup Sheets 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 > 
  • 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 - Lookup Sheets addon for Google Forms

You can use the Formfacade – Lookup Sheets add-on 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?
Install the Formfacade – Lookup Sheets add-on > Open your form in Google Forms > click on the add-on icon > click Formfacade - Lookup Sheets > add-on menu options will be displayed > click Lookup Sheets > follow the prompts to connect your sheet, click Next > Describe what you want in plain English and click Proceed. For example, populate the supplier dropdown with the names from the Supplier sheet > click on the Publish icon in the top right corner > use the Formfacade share link to collect responses.

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 – Lookup Sheets. 
  • 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 - Lookup Sheets

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 – Lookup Sheets 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."

Made with formfacade

Last updated: