From what I understand, it's possible to grab the URL of a single Google spreadsheet, load it into a Visualization API app, and chart the results. My question is whether it is possible to
1. List all the (CSV) spreadsheets from a Google Drive directory inside of a dropdown on a Visualization API Dashboard
2. Load the data into a dashboard chart when a file listed in the dropdown is selected.
Is the doable? It seems like the problem would be with 1, as the drop-downs seem to be limited to pre-made components, ie the CategoryFilter component.