How can i make custom Variables based on the values from certain column? I'm using Google Sheets as the data source

How can i make custom Variables based on the values from certain column? I’m using Google Sheets as the data sources. I’m already trying to use Custom but it didn’t work.

My raw data consists from a table of assets & locations table, i’m making a geomap dashboards, then i wanna filter/making dropdown variables based on certain column that has string values.

Please help, thanks everyone!

welcome to the :grafana: forum, @azharizalfajar

the GoogleSheets data source plugin supports template variables for spreadsheet and range, but it does not support query-based template variables :+1:

Hey! When you say template variables for spreadsheet and range, is it possible to define a template variable that defines a value to then use within a separate query? Thanks!

Hi @adamgailiunas!
Where you able to solve this? I’m trying to do the same thing: Getting data from a column in Google Sheet and assign the values to a variable to use as a filter in a query on a SQL server.
Please let me know if you found a way of doing this!
Thanks!