Getting crypto prices into Google Sheets

I've spent about 100 hours trying to figure out how to do this and I finally admit defeat.

I've tried the CMC API, Coingecko API, IMPORTXML, about 50 other things that chatgpt has instructed me to do and nothing I do works. Even just copy pasting everything from chatgpt straight into my sheet 100 different ways simply doesn't work. I get an error or #VALUE or something and I just can't understand how this can possibly be so complicated. Like just give me the Solana price in a Google Sheets cell! Am I crazy? I don't consider myself a stupid person, but it seems maybe I might be since this supposedly simple task is taking me longer to accomplish than my university degree.

The only method that does work is using a Google Sheets extension that I have to pay for (which I don't mind at all) but just in the spirit of finishing what I started can someone please show me how this can be done.