orrajabii

I am using importjson with cmc api in google sheet like this: importjson("https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?CMC_PRO_API_KEY="& cmcAPIkey&"&symbol=TASTE","/data/TASTE/quote/USD/price","noInherit,noTruncate,noHeaders") You need to replace cmcAPIkey with your api key.