Dropdown from a Googlesheet

Hi All,

So day two with this product. I have a googlesheet that has a list of items. In this example my sheet has the following

ID (Header)
TX1
TX2

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.

ID (Header)
TX1
TX2
TX3

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?

Thanks All
Mik

https://developers.google.com/sheets/api/samples/reading