Keeping track of your crypto-currency portfolio can be challenging. There are a few services out there, but nothing beats the flexibility of a spreadsheet.
Google Sheets is a very convenient spreadsheet tool. But while we can get the current Bitcoin exchange rate with the GOOGLEFINANCE("BTCUSD") function, other crypto-currencies and information (market cap, volume, etc) are not available.
The CRYPTOFINANCE() function, available as a Google Sheets Add-On, uses the coinmarketcap API to returns the rates, market cap, volume, change, total supply and rank...
Full Guide is here:
https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14