I am having the same problem. I actually got the chart to work when using a google spreadsheet. But when I tried to create a 2nd chart, I get the error:
Not enough columns given to draw the requested chart
I even have the same data as the chart that works. Uploading it via CSV works fine but when pulling from a google spreadsheet, it gives this error.
To publish the spreadsheet as a CSV, just add this to the URL the format like this.
/export?format=csv
https://docs.google.com/spreadsheets/d/1_jQTx9_Yvv-zE9lmVxPYgUpvM8E5SqvOUeTfKBYTMqg/export?format=csv
