google.charts.load('current', {'packages': ['corechart']}); google.charts.setOnLoadCallback(play); function play() { var query = new google.visualization.Query( 'https://docs.google.com/spreadsheets/d/1VjCi0k-98P_3YmlHyHb3up0zPl9mp1tbYsJUJxmqegg/edit#gid=0'); query.send(draw); } function draw(r) { if (r.isError()) { alert('Error in query'); } var tc = r.getDataTable(); n=tc.getNumberOfRows() m=tc.getValue(1, 0); $("#d").html(n); }