Learn more about using the IMPORTXML function:

Learn to pull stock prices: https://youtu.be/Cd-DlJdWbsg

Read the article on how to pull crypto prices:

Pulling cryptocurrency prices into Google Sheets (3 Methods)

For using the IMPORTDATA method (credit to cryptoprices.cc):
https://cryptoprices.cc/
https://cryptoprices.cc/sitemap.txt

In this video I will teach you three different ways to pull crypto prices into your Google spreadsheet.

First I will show you how to use the GOOGLEFINANCE function to pull the prices of major cryptocurrencies, and then I will show you how to use the IMPORTXML function to pull the price of any crypto, from a specified website that you want to pull data from. Then I’ll show you how to use the IMPORTDATA function to pull crypto prices from cryptoprices.cc

source