Lookup Google Sheets data in Google Forms

Populate dropdowns and autofill fields from a Google Sheet. No code.

Try it free
Install Addon
An Employees sheet with one row selected, a dashed line to a form where picking that ID fills in the same name in the same pale blue

Why us?

A Google Form can't read from a Google Sheet, so you type or paste every list by hand. Formfacade fills your dropdowns and answers from one Sheet, so you only update the list once.

Update your list once

Changing the same dropdown in every form takes time and some copies get missed. Keep the list in one Google Sheet and every connected form shows the change.

Learn more
Update your list once
Keep your forms up to date

Keep your forms up to date

Keeping a dropdown in step with your Sheet by hand is a chore. Your forms update from the Sheet every 30 minutes or each time someone submits.

Learn more

Show only the choices that fit

A Google Forms dropdown can't depend on an earlier answer, so everyone sees the whole list. Once someone picks a category, the next dropdown shows only what belongs to it.

Learn more
Show only the choices that fit
Make long lists easy to search

Make long lists easy to search

A list of hundreds or thousands is slow to scroll through. People can type a few letters and find it, even in a list of thousands.

Learn more

Stop typing the same details again

Typing an employee ID, then the name and department, leads to mistakes. Pick the ID and the form fills in the rest from your Sheet.

Learn more
Stop typing the same details again
Set it up without code

Set it up without code

A script that reads your Sheet needs someone to write it and fix it. Connect your Sheet, describe what you want in plain words, then share the Formfacade link.

Learn more

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. Your sheet is only ever read, never modified.

2

Sync

We keep your data fresh, syncing every 30 minutes or on every form submission.

3

Lookup

Populate dropdowns, build conditional dropdowns, and autofill related fields in your form.

Customers love us

Karen Launchbaugh

I really like using google forms. But, I needed something that looked a bit more professional and I stumbled across formfacade. It works great! Easy to use and include on my Wordpress site. It was also easy to download the information submitted through the form. This is absolutely one of the best apps I have ever used in terms of service and support.

Dorothy Jem Chen

Hands down one of the best add ons in Google Forms especially if you feel so limited in Google Forms. It has features like calculations - which is perfect for automating your processes. It also makes your form look minimalistic compared to the bulky design of Google Forms.

Michael Simpson

This is an amazing add-on. It provides another level of control of the look and functionality of your Google Form. The product is well thought out and easy to use. The support is great! Fast answers that went above and beyond.

Aimee Cerka

An extra 5 minutes of work to incorporate my Google Forms into my website and present a more unified brand look, that is extremely valuable.

Alexandre Bosch Puig-Alsina

I really enjoy using Google Form as a tool to do my job, but appearance is not its best part. Formfacade helped me embed it in my website and make it look more professional.

Caio Cézar

We were using Google Forms for almost 2 years, but when we found Formfacade we immediately switched to Formfacade for its aesthetics and possibility of form customization in greater detail. It enhances the customers’ perception of your website and your brand.

From startups to corporates.
1500+ companies trust us.

La Bonita Supermarkets serves shoppers in the Las Vegas area. The team uses Formfacade to display its stock loss reports on its website. Visitors can complete a form on the page they are viewing. The team uses Formfacade to collect photos and other files through its job application forms. People can attach the material to their form submission. The team uses Formfacade to customize the appearance of its stock loss reports. Glo Tanning runs a network of salons across the United States. The team uses Formfacade to add up scores from form answers. Staff can review the resulting score with each response. The team uses Formfacade to customize the appearance of its inspection forms. Missouri Western State University is a university where students learn through academic study and practical experience. The team uses Formfacade to collect photos and other files through its forms. People can attach the material to their form submission. BrightTeach provides tutoring for students. The team uses Formfacade to customize lesson report forms. Tutors record the length of each lesson and whether the student attended. Primecare Home Care provides care at home for children, adults, and families in Georgia and Indiana. The team uses Formfacade to collect photos and other files through its inspection forms. People can attach the material to their form submission. The team uses Formfacade to customize the appearance of its inspection forms. Expresswash operates laundry stores in the Philippines. The team uses Formfacade to customize the forms staff use to record sales at its laundry branches. Wellspring Academy Trust operates a group of schools in the United Kingdom. The team uses Formfacade to collect files through its inspection forms. People can attach the material to their form submission. The team uses Formfacade to customize the appearance of its inspection forms. The Signal Group provides shipping services and technology for the maritime industry. The team uses Formfacade to add up scores from form answers. Staff can review the resulting score with each response. The team uses Formfacade to customize the appearance of its timesheets. VeriSmart provides property inspections for landlords, tenants, and letting agents in the United Kingdom. The team uses Formfacade to customize the appearance of its inspection forms. Impetus Global carries out checks and records problems that need attention. The team uses Formfacade to add up scores from form answers. Staff can review the resulting score with each response. The team uses Formfacade to customize the appearance of its inspection forms. Uniline INC carries out checks and records problems that need attention. The team uses Formfacade to collect photos and other files through its inspection forms. People can attach the material to their form submission. The team uses Formfacade to customize the appearance of its inspection forms. U-VOL Foundation provides medical outreach, clean water, and health education in underserved communities. The team uses Formfacade to collect photos and other files through its inspection forms. People can attach the material to their form submission. The team uses Formfacade to customize the appearance of its inspection forms.
See customer stories →

One spreadsheet. Every form in sync.

Install Addon