Google Forms does not have a native way to look up data from Google Sheets based on a respondent's selection, but you can use the Formfacade – Lookup Sheets add-on to implement lookup in Google Forms without any code. Unlike populating a dropdown, a lookup requires the form to query your sheet in real time when a respondent makes a selection. Apps Script does not support this within a native Google Form.

What is a Lookup in Google Forms?

A lookup connects a question in your form to a column in your Google Sheet. When a respondent selects or enters an answer, the form queries your sheet in real time and returns a related value based on that selection.

For example, when a respondent enters a coupon code, the form can look up and return the applicable discount from your sheet. Or, if a respondent selects a student name from a dropdown, the form can look up and return that student's email address from your sheet. The email address is recorded as an answer for the email address field in the form. You can choose to hide this field so respondents do not see it while completing the form.

This is different from populating a dropdown, where the sheet is only used to supply the list of options. A lookup happens after the respondent makes a selection or enters a value, and returns data from your sheet based on what they chose.

Can I use Apps Script?

Apps Script can be used to edit a form or trigger actions after a respondent submits the form. For example, it can look up a sheet to update answer choices in a dropdown, or send a confirmation email to the respondent. However, Apps Script cannot respond to a respondent's input in real time within a native Google Form.

A lookup requires the form to query your sheet the moment a respondent makes a selection or enters a value, and Apps Script has no way to do this while the respondent is filling out the form.

Method 1: Import Google Forms via URL

If you have already created your form in Google Forms, you can use the form URL to import it to Formfacade. This creates a copy of your form in Formfacade where you can configure the lookup. When respondents submit the form using the Formfacade link, responses are recorded in Google Forms. You can use the Link to Sheets feature in Google Forms to automatically sync responses to Google Sheets in real time.

Let's take this example. A school admin form presents a dropdown of student names. When a staff member selects a name, the student's email address is automatically looked up from the sheet and recorded with the response. This eliminates manual entry errors and ensures the email address is always accurate and up to date. The email field can be hidden so the staff member does not see it while filling out the form.

How to set it up?

Go to formfacade.com > click Try it free > select Import via URL > paste your Google Forms URL, and click Proceed.
Use simple instructions to connect your sheet and implement the lookup. For example: "When a staff member selects a student name, look up and return the email address from the Students sheet."
Share the Formfacade link with your respondents.

Method 2: Add-on 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 query your sheet in real time when a respondent makes a selection and populate the answer with data from your sheet. The form stays in sync with your sheet automatically.

Let's take this example. A retail store uses a Google Form to take orders and support discount redemption. When a customer enters a coupon code, the form queries the sheet in real time and returns the applicable discount. If the coupon code does not exist in the sheet, the form displays an error message.

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: "When a customer enters a coupon code, look up and return the applicable discount from the Discounts 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. Use simple plain English instructions to set up the lookup.
Handles large data. Supports data of any size backed by Google Sheets with no performance limits.
Flexible UI. Hide lookup fields or mark them as read-only so respondents cannot edit the returned value.
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.

Frequently Asked Questions

Can I hide the looked-up value from the respondent?

Yes. You can choose to hide the field that displays the returned value. The value is still recorded with the form response but the respondent does not see it while filling out the form.

What happens if the value entered by the respondent does not exist in the sheet?

The form can display an error message to the respondent. For example, if a customer enters an invalid coupon code, the form will notify them that the code does not exist.

Can the lookup return a value from a different sheet than the one powering the dropdown?

Yes. The dropdown and the lookup can be connected to different sheets.

Does the sheet need to be in a specific format for the lookup to work?

No. As long as the lookup values are in one column and the related values are in another column, Formfacade can work with your existing sheet structure.

Are responses recorded in Google Forms?

Yes. Regardless of whether you use the import method or the add-on, responses are recorded in Google Forms as normal. You can use the Link to Sheets feature in Google Forms to sync responses to Google Sheets in real time.

How to look up data from Google Sheets in Google Forms?