I’m trying to create a dynamic enum list by populating with data from Google Sheet. However, I am unable to get the data from Google Sheet’s 2nd sheet. I could only get the data from the 1st sheet. This is not which I wanted as I want to use 1st sheet to store data from user input.
The name of Google Sheet is: sample_condition_data. There are two sheets in it: Sheet1 (to store data), and townshiplist (where I stored data to populate enum).
If I were to pull data from the 1st sheet, I could simply write sample_condition_data[ColumnName]
But if I want to go to another sheet under sample_condition_data, how can I do it?