How to add data from a third-party site to Google Spreadsheet?

Question

API

How to add the value of the exchange rate of bitcoin to the ruble in Google spreadsheet?
https://api.coinmarketcap.com/v1/ticker/bitcoin/?c...
value "price_rub"

Answer 1

=importxml("https://api.coinmarketcap.com/v1/ticker/bitcoin/?convert=RUB","/")

only you need to insert a token into the link that is in your personal account on the site