Search Support
Query GoogleSheet
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
- Go to your Google Sheet page and click File then Publish to the Web... and click Publish.
- The URL in your address bar should look something like the following: https://docs.google.com/spreadsheets/d/{SHEET_ID}/edit - copy the SHEET_ID portion to your clipboard.
- From the Web Form 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 and paste it in the inspector under GoogleSheet URL.
79047
||
How to Set Up Automatic Tagging Add any text field, checkbox, radio button, or select menus that will determine how the submission will be assigned. How to Set Up Conditional Notifications Add any text field, checkbox, radio button, or select menus that will determine how the submission will be assigned.