Read Cells from Google Sheets in JavaScript or HTML

I would like to be able to read the values in a column from Google Sheet with JavaScript of HTML and add the values to a ComboBox or use them for other purpose.



Basically I want to imitate the following action in VBA with Excel. (In excel if I want to read the Values in Column A I would do something like)



Dim i as integer

Dim value as string

i = 1

//Read value on cell A1

Value = Range(“A” & i).value

//Keep reading values on column A till cell is empty

While value <> ” ”

Value...

Read Cells from Google Sheets in JavaScript or HTML WordPress ...