Part of the Formfacade family

Lookup data from Google Sheets in Google Forms.

Pick a sheet to populate dropdowns, look up prices, and autofill fields in your forms — no code, always in sync.

Your Google Sheet
CountryCityPrice
IndiaChennai1200
IndiaBangalore1450
FranceParis1980
FranceLyon1620
Your form
↓ synced from sheet
India ▾
Chennai ▾
1,200

Connect once. Stay in sync forever.

Three steps from a spreadsheet to a live data source for your forms.

1

Connect

Pick a Google Sheet via Google Picker. We add a read-only collaborator so we can mirror it. Your data stays in your sheet — we don't copy or own it.

2

Sync

We mirror your sheet into a fast read-only store and keep it fresh as you edit. Diff-only updates — no full re-syncs.

3

Query

Your forms use the data — populate dropdowns, look up prices, compute totals, filter dependent options. All from your sheet.

From plain forms to data-driven experiences.

Patterns that cover most form-data needs without writing a line of integration code.

Dropdown population

Pull values from any column as dropdown options — including distinct, sorted, and filtered.

"Pull department names from my Staff sheet as dropdown options."

Lookup & calculate

Use a form selection as a lookup key and surface the matching value, or compute a total.

"Customer picks beverage and size; show the price from my Prices sheet."

Dependent dropdowns

Filter the second dropdown based on the first — countries narrow to cities, brands to models.

"Pick a country, then show only cities in that country."

Multi-field autofill

One selection populates several fields — pick an ID, autofill the rest of the row.

"Pick employee ID; autofill name and department."

Connect your first sheet.

Free during the beta. Pick a sheet, share it with our service account, and you're live in under a minute.

Connect a sheet