How to load geodata from google sheet (columns) instead

My current data is hardcoded:

   var geoData = new google.visualization.DataTable();
        geoData.addColumn('string', 'City');
        geoData.addColumn('string', 'Name');
        geoData.addColumn('boolean', 'Yes/no');
开发者_如何学编程
var geoView = new google.visualization.DataView(geoData);
        geoView.setColumns([0, 1]);

---

var query = new google.visualization.Query('http://spreadsheets.google.com/...')