Hi @Cedric_Debono_Blaze! Thanks for getting back to me - I have read the first article and was able to import the doc into the snippet but am at a complete loss for what is next.
I did see about DataBlaze too, and our org has used it for a couple of "static" spreadsheets already and I am able to design snippets that way with relative ease. The data on the spreadsheet I was referencing comes from a query that is delivered through an API token to our google sheet and updates about every 5 minutes - is that possible to do with DataBlaze? If so I would prefer that route if at all possible!
@Cedric_Debono_Blaze thanks for this, I was actually finally able to get the google sheet list to print to the snippet as per the article you directed me to, and the drop down to display with the items in each row! Now I am just a little stuck on how to do two things:
In the drop down, I only want the items in the "name" column on my spreadsheet to display, and then when that option is selected I only want the value in the "soonest_availability_words" column to actually be inserted in the snippet. Any direction on a solution for that?