You can make your own coingecko reader from their free API
https://www.coingecko.com/api/documentations/v3
and google sheets script ImportJson https://gist.github.com/paulgambill/cacd19da95a1421d3164
following these instructions
https://hackernoon.com/3-best-ways-to-import-json-to-google-sheets-ultimate-guide-3k8s24ya
Then you can put something like this into the sheet
=importJSON(“https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=usd”)
and voila
1 Like
thanks! I ended up using a different resource, but I was curious about the relationship between coingecko and google in this case 