How to get the token exchange rate at the current moment in a Google spreadsheet?

Question

Cryptocurrency

How to get the exchange rate of a particular crypto coin or token in a cell in a Google spreadsheet at the current moment (with the possibility of updating at the entrance or on request?
Better using the CoinGecko or CoinMarketCape sites, if possible.

Answer 1

1. Understand the API
https://www.coingecko.com/en/api/documentation
Example:
Get a list of coins and find the id of the necessary cryptocurrencies
https://api.coingecko.com/api/v3/coins/list

[
    {
        "id": "01coin",
        "name": "01coin",
        "symbol": "zoc"
    },
    {
        "id": "bitcoin",
        "name": "Bitcoin",
        "symbol": "btc"
    }
]

An example of getting the Bitcoin exchange rate in rub and usd

https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=rub%2Cusd

2. Install ImportJSON in google sheets
ImportJSON
3. Import data

=ImportJSON("https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=rub%2Cusd"; "/bitcoin/usd";)

Google sheets example