Did you know that you can pull information from a GoogleSheet into your web forms and wizards? This allows you to pull information from a large dataset. This is helpful if you want to automatically populate things like addresses from a list of predetermined addresses.

To set up Query GoogleSheets

  1. Go to your Google Sheet page and click File then Publish to the Web... and click Publish.
  2. From the Web Form Builder, under Specialty Tools, add the Query GoogleSheet element to your form
  3. Either click the settings icon or right-click and click More Options
  4. Copy the Sheet ID from the URL in your browser (this should be at the very top of the browser when you're in the Google sheet and not under any of the settings) and paste it in the inspector under GoogleSheet URL in the following format replacing "{SHEET_ID}": https://docs.google.com/spreadsheets/d/{SHEET_ID]/edit


Want to try this on your own? Try these Google Sheet ID's:

Query a list of US States:

1OMBxeZzgID1QvScBkG6o_1nLiwZrKuAWbV_JXEg8ZI8

Query a list of Counties in New York: 

18DW2nKTej3h94R9vp3r0udLllfwC3HvdUVJNrQTfdFo

Here is a demo form to see how it will look after it's successful!

Did this answer your question?