Skip to main content
All CollectionsPro Tips
Query GoogleSheets
Query GoogleSheets

This article walks through how you can query a Google Sheet as a database to have other fields populated based on a selection

Andrew Liebelt avatar
Written by Andrew Liebelt
Updated over 2 years ago

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

  1. Go to your Google Sheet page and click File then Publish to the Web... and click Publish.

  2. From the WebForm 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 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!

Did this answer your question?