Sort:  

does this work on Google Sheets? If yes, what's the actual implementation?

It's google sheets addon CRYPTOFINANCE. Once you install it, it works that simple.
Function could pull btc, usd, any fiat price from coinmarketcap. Also trading volume, %growth.

Coin Marketplace

STEEM 0.18
TRX 0.15
JST 0.029
BTC 61952.36
ETH 2417.96
USDT 1.00
SBD 2.64