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: