So day two with this product. I have a googlesheet that has a list of items. In this example my sheet has the following
Very simple. On Wappler I am trying to work out how to connect a dropdown to read the list from the Google Sheet so that if any changes are made on the sheet, they are reflected in the dropdown. i.e.
So my thinking is that I need to connect the googlesheet (maybe publish this as a CSV that connects to an SQL so any changes are synced into the SQL?)
Can someone point me to a video or document that helps me to understand how I might achieve this?