Load Select With Google Spreadsheet Worksheet Name
What follows is an example of a select box dynamically populated with the names and index of worksheets in a Google spreadsheet. If a option is selected and the load button is clicked, the text area will be loaded with the JSON interpretation of the specific sheet.
By default, the textarea is loaded with the JSON import containing information about the spreadsheet. It is where the worksheet information is obtained. Read more about this here.