How to get crypto balance from your wallet in Google Sheets

Add-ons for google sheets that let you get the crypto balance from your wallet

The CRYPTOWALLET function on Google Sheets.

Why?

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 as of today there are not many services that let you get information about crypto-currency.

The CRYPTOWALLET() function, available as a Google Sheets Add-On, uses several APIs to returns the balance of your wallet.

As of today I offer support for:

• BTC
• ETH
• DASH
• IOTA

How to install

1. Go to the “Add-ons” menu, and click on “Get add-ons”.

2. On the Add-ons panel, search for “cryptowallet”, click on “+ FREE” to install it.

3. Choose under which account you want to install the Add-on.

4. CRYPTOWALLET needs to connect to an external API, click on “Allow”.

And that’s it! From there the =CRYPTOWALLET() function is available on any new spreadsheet you create.

How to use

Example

• =CRYPTOWALLET("BTC","YOUR_WALLET_ADDRESS") returns the balance of your Bitcoin address.
• =CRYPTOWALLET("ETH","YOUR_WALLET_ADDRESS") returns the balance of your Ethereum address.
• =CRYPTOWALLET("DASH","YOUR_WALLET_ADDRESS") returns the balance of your Dash address.

How to convert the balance to currency (USD / EUR)?

For that the best will be to use the CRYPTOFINANCE Add-on: https://goo.gl/WA69FV

How to send feedback and ask questions

Get in touch on Twitter:

Luciano Giavedoni (@lgiavedoni) | Twitter

Do you find CRYPTOWALLET very useful and want to thank me?

I accept Bitcoin donation: 147EgBts7ruUjaVSpDSdpEAs1E9r4DnGTt

Bitcoin address where to send your donation