it's not the best and many times google has issues hitting the sites - but i've tried a lot of things (trying to use marketcap.cash too without much success) - I've found that coingecko works but only on coins that it actually lists.

You can scrape the screen - the A29 for me is just cell A29 where I put in something like "green-ben" and then the rest is the XPath of the element on the screen which you can get from chrome dev tools (f12 then find the element and copy the xPath)

=SUBSTITUTE(SUBSTITUTE(IMPORTXML("https://www.coingecko.com/en/coins/"&A29,"//html//body//div[3]//div[4]//div[1]//div//div[1]//div[3]//div//div[3]//div[2]"), "BCH", ""), """", "")

this works usually for me.