Hello, 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 (1TZlZX67Y0s4Cv…

[Screenshot001067] [Screenshot001068]

Hi! What does your Sheet look like? Have you tried using TimeFilter?

I just used the public demo file of the Google Sheets datasource plugin developers: https://docs.google.com/spreadsheets/d/1TZlZX67Y0s4CvRro_3pCYqRCKuXer81oFp_xcsjPpe8/edit#gid=0

Does it work with any of your own sheet? When you go to the data source settings and try “Save and test”, do you get an error?

Not it also does not work with any own public sheets. I don’t get an error when adding the data source.

Looks like there is a step missing in the docs. You have to enable the Google Sheets API: https://console.cloud.google.com/apis/library/sheets.googleapis.com

Thank you, but was enabled already: [grafik]

Here is the demo page on the Grafana play site Steps that I took: Created an API Key in my GCP account Enabled the Google Sheets API Created the data source in Grafana with the API Key Created a dashboard with a graph panel and started with a Google Sheets query Copied the sheet ID: 1TZlZX67Y0s4C…

I am talking about a local installation, not a hosted one (which the play site is, I think). Plugin on play site does alos work for me.

I have solved the issue by sharing the Google Sheet publicly

Google Sheets datasource plugin not working?

Grafana

infofcc3 May 26, 2025, 10:54am 20

Topic		Replies	Views
[OFFICIAL] Grafana Google Sheets data source plugin Documentation Grafana api , plugins , datasource , google-sheets , spreadsheet	0	218	January 16, 2025
Error whit google sheet	4	879	July 7, 2020
Steps to create Grafana Dashboard using Google sheets Grafana google-sheets , grafana , spreadsheet , table-view	0	185	April 24, 2025
Grafana and Google Sheets Grafana	1	352	November 2, 2020
"An unexpected error happened" - google sheet in grafana cloud Grafana Cloud	1	348	October 2, 2023

Google Sheets datasource plugin not working?

Related topics