today I made a fresh installation of Grafana 6.7.1 on Windows 10, installed the Google Sheets datasource plugin 0.9.0 and restarted Grafana.
I created a Google Sheets datasource with my API key.
When I create a new dashbaord -> Add query and enter your example Spreadsheet ID (1TZlZX67Y0s4CvRro_3pCYqRCKuXer81oFp_xcsjPpe8) I immediately get a “Metric request error”.
What I am doing wrong or how can I fix that problem?
See the screenshots: