How to get a variable from google sheet column for Grafana?

I want to get a variable for grafana dashboard from google sheet but if we select source as google sheet Regrex text box only display , unable to add google sheet link and range.

I don’t think that datasource has query-based template variables. BVut you could try using a different template variable style, like a custom text, and then using that variable inside your query in the query-editor

Hi @mattabrams . Following on with this discussion, do you know if it is possible to have the same Google Sheet data source configuration for variables as we have in the panels? In other words, being able to input the sheet ID and the specified range. Currently I have the same problem as in the picture shared by @da17csr220 where I can select Google Sheets as a data source, but cannot do anything with it.

2 Likes