Did you know that you can pull information from a GoogleSheet into your WebForms 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
Go to your Google Sheet page and click File then Publish to the Web... and click Publish.
From the WebForm Builder, under Specialty Tools, add the Query GoogleSheet element to your form
Either click the settings icon or right-click and click More Options
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 ID. You will find the Sheet ID in the URL here where {SHEET_ID} is in the following URL:
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:
14wvnQygIX1eCVo7H5B7a96W1v5VCg6Q9yeRoESF6epw
Here is a demo form to see how it will look after it's successful!