Lookup Sheets
Populate dropdowns, autofill fields, and build conditional dropdowns in Google Forms live from a Google Sheet — set up in plain English, no code. Read-only and always in sync.
Quick Answer
How do I pull Google Sheets data into a Google Form?
Use Formfacade's Lookup Sheets. Go to formfacade.com/lookup, click Try it free, and pick what you want to do — populate a dropdown's options, autofill related fields, build conditional (cascading) dropdowns, or connect with AI. Then connect your form, connect your Google Sheet(s), and describe the connection in plain English. Formfacade reads the sheet live (every 30 minutes or on each submission) and never modifies it.
Google Forms has no native way to pull data from a Google Sheet. Lookup Sheets adds exactly that: it connects form questions to columns in your sheet and reads them live, so options and autofilled fields always match your real data — product catalogs, price lists, student rosters, employee directories. Your sheet stays the single source of truth; Formfacade mirrors it to serve forms fast and never writes to it.
What you can do with your Sheets data
After Try it free, Formfacade asks "What do you want to do with your Google Sheets data?" — four tasks, all powered by the same setup flow. Each has its own guide:
| Task | What it does | Guide |
|---|---|---|
| Populate a dropdown | Fill a dropdown's options from a sheet column (deduplicated, sorted, or filtered). | Populate a Dropdown |
| Autofill fields | When a respondent picks a value, auto-populate related fields from the same row. | Autofill Fields |
| Conditional dropdowns | Filter the next dropdown by an earlier answer, and drop choices that are used up. | Conditional Dropdowns |
| Connect with AI | Describe what you want in plain English and let Formfacade wire it up. | Connect with AI |
Every option is natural-language driven — at the Configure step you describe the connection in plain English rather than set it up by hand.
Set it up (shared by all four)
Whichever task you pick, the first three steps are the same. The Connect form screen's heading changes to match the task, but the flow is identical — then each guide above picks up at the Configure step.
Start at formfacade.com/lookup
Go to formfacade.com/lookup, click Try it free, and choose what you want to do with your Sheets data.
Connect your form
Paste your Google Form link (or click Browse to pick it from Drive) and click Next. Formfacade makes a copy of the form to add the lookup to.
Connect your Google Sheet(s)
Click Connect a Google Sheet to launch the spreadsheet picker and choose your sheet. Back on Pick connected sheets, select one or more (use + Connect another sheet to add more), then click Next.
Describe the connection — then follow your task's guide
On Configure, you describe the connection in plain English. This is where the four tasks differ. Open the guide for what you're building: Populate a Dropdown, Autofill Fields, Conditional Dropdowns, or Connect with AI.
Behavior & limits
These apply to every Lookup task:
| Behavior | Detail |
|---|---|
| Sync cadence | Every 30 minutes, or on every form submission |
| Direction | Read-only — Formfacade mirrors your data and never writes to your sheet |
| List size | Hundreds to thousands of options, with autocomplete |
| Multiple sheets | Connect more than one; different fields can read from different sheets |
| Field visibility | Autofilled fields can be editable, read-only, or hidden |
| Unknown values | The form shows an error if an entry isn't found in the sheet |
| Source of truth | The spreadsheet; edits there propagate to every connected form |
Prefer to keep your native Google Form?
The Try it free path makes a Formfacade copy served from a Formfacade link. To keep your original Google Form instead, use Install addon on the landing page and describe your lookup in plain English from inside Google Forms.
Responses still go to Google
Lookup only controls what options appear and what gets autofilled. Submitted responses keep flowing to Google Forms and your linked Google Sheet exactly as described in How Responses Sync.
Next steps
- Start with Populate a Dropdown — the simplest task.
- Scoring answers instead of looking them up? See Assign Points.
- Pre-filling fields per contact? See Prefill & Send.