My boss is going to be mind-blown when i show him that I can display his sheets datas in Grafana. Thank you for the guide the video has a really good structure well-edited too. Watching from Brazil, I hope to see more videos from you soon. It would be nice to see some other possibilities of data manipulation in Grafana using Google Sheets
You could use transformations, specifically the "Filter data by values" transformation, where you can select a field (column in Google Sheets) and filter for the value you want. I also recommend checking out or asking in community.grafana.com/ 🙂, as there might be more people with similar problems who have figured it out.
Hello Ivana, thank you for the interesting guide. I have a question: when I try to run the query after pasting the Spreadsheet ID (around 3:28 in the video) I get Google API Error 400, despite following your steps... do you have any suggestions on the matter? Thank you very much in advance.
I am not sure what could it be, but I would double check that: - you made the spreadsheet available for Anyone with link (0:56 in the video) - that your API key is enabled for Google Sheets service (2:25 in the video) - that you copied a correct google Spreadsheet ID from URL (if URL is docs.google.com/spreadsheets/d/akg0hKc6jVjlkuLVWJ1icZdXJrdmofobT0EE6qvgst9U/edit#gid=0, the spreadsheet id is akg0hKc6jVjlkuLVWJ1icZdXJrdmofobT0EE6qvgst9U) - ensure that your range is correct. For example, in my case, my spreadsheet name (which you can find at the bottom) is "plunges", but the default value is usually "Sheet1". My data is in cells A1 to I17. Thus, the range should be plunges!A1:I17 (or in the default case, it would be Sheet1!A1:I17). Alternatively, you can just use Sheet1!A1:I, or simply Sheet1 if you do not want to limit the cells. Hope it helps!
@@ivana.huckova Hello Ivana, thank you for your swift response. I have double-checked what you suggested, but unfortunately the problem isn't solved :/ I'm quite at a loss what to do now
Problem found, if you upload an Excel file from your personal computer to Google Drive, it won't work properly. However, if you create a new Google Sheet and paste the data into it, everything works fine.
You saved me and Lucas Alves. We were having trouble with this for a college project. Thanks!
Great video Ivana! Hope to see more videos like these, they are super helpful! 🎉
Great Video! For all like me who get stuck for a minute on how to get the ID of the GSheet = it's encoded=visible in the URL ;-)
My boss is going to be mind-blown when i show him that I can display his sheets datas in Grafana. Thank you for the guide the video has a really good structure well-edited too.
Watching from Brazil, I hope to see more videos from you soon. It would be nice to see some other possibilities of data manipulation in Grafana using Google Sheets
Great video Ivana! Very helpful
u saved my life, thank u
Video absolutely perfect! Thanks
Thanks for the guide! Also, is there any way to apply filters and only show certain rows of the spreadsheet?
You could use transformations, specifically the "Filter data by values" transformation, where you can select a field (column in Google Sheets) and filter for the value you want. I also recommend checking out or asking in community.grafana.com/ 🙂, as there might be more people with similar problems who have figured it out.
@@ivana.huckova transformations worked like a charm! thanks :D
Hello Ivana, thank you for the interesting guide.
I have a question: when I try to run the query after pasting the Spreadsheet ID (around 3:28 in the video) I get Google API Error 400, despite following your steps... do you have any suggestions on the matter?
Thank you very much in advance.
I am not sure what could it be, but I would double check that:
- you made the spreadsheet available for Anyone with link (0:56 in the video)
- that your API key is enabled for Google Sheets service (2:25 in the video)
- that you copied a correct google Spreadsheet ID from URL (if URL is docs.google.com/spreadsheets/d/akg0hKc6jVjlkuLVWJ1icZdXJrdmofobT0EE6qvgst9U/edit#gid=0, the spreadsheet id is akg0hKc6jVjlkuLVWJ1icZdXJrdmofobT0EE6qvgst9U)
- ensure that your range is correct. For example, in my case, my spreadsheet name (which you can find at the bottom) is "plunges", but the default value is usually "Sheet1". My data is in cells A1 to I17. Thus, the range should be plunges!A1:I17 (or in the default case, it would be Sheet1!A1:I17). Alternatively, you can just use Sheet1!A1:I, or simply Sheet1 if you do not want to limit the cells.
Hope it helps!
@@ivana.huckova Hello Ivana, thank you for your swift response.
I have double-checked what you suggested, but unfortunately the problem isn't solved :/ I'm quite at a loss what to do now
@@PPPolB I am not sure what else could it be. I went trough the steps again and I can't think of anything else. ☹
I have the same problem, maybe this method won't work anymore.
Problem found, if you upload an Excel file from your personal computer to Google Drive, it won't work properly. However, if you create a new Google Sheet and paste the data into it, everything works fine.