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