Goolge sheets live data

Can someone help me with Google sheets.
I want to import live Gold usd price but it looks Google finance dosen’t provide commodities live data anymore.
Have anyone tried to get this data from any other sources?


I dont think there is a direct way.
You can refer this and write a script

i am using this but it has to be refreshed manually.
=ImportHTML(“Gold Dec 21 (GC=F) Stock Price, News, Quote & History - Yahoo Finance”,1)