Coinranking in Google Sheets

Hi everyone.
Could you please explain how I can use Coinranking API in Google Sheets to import live price data?
For example, I have a list of tickers like ‘BTC’, ‘ETH’… I’d appreciate helping with a formula that will use Coinranking API and refer to the column with my tickers.