How to import crypto balances into Google Sheets or Excel in less than 5 minutes

I’ve been developing an integration tool to be able to have a unique and synthetic view on cryptos distributed in many exchanges and pools.
When looking for the needs of the community I realized a lots of people wanted this data directly in Excel. Excel being what it is, many people are concerned by security issues so I decided to also show you how to do this in Google Sheet. Both options are described below.

Problem: you have cryptos in various exchanges like binance, poolin, bittrex or coinbase, and if you are a miner you probably have some in ethermine, btc.com or antpool. Question is how to collect your balances in a centralized place within minutes, without dealing with the complexity of the API of each platform, and then refresh within seconds.

Solution:

1. Create an account on https://bminer.ca
2. Configure all your exchanges/pools/blockchain addresses. This can be a little bit tedious since you need to enter READ ONLY keys for each exchange. It is extremely important to only use READ ONLY keys to avoid any possibility in case someone would gain access to your keys.
3. In your account settings page (top right corner), take note of your API Key.

Google Sheets…

1. Create a new Google Spreadsheet.
2. Click on Tools -> Script Editor.
3. Click Create script for Spreadsheet.
4. Delete the placeholder content and paste the code from this script.
5. Rename the script to ImportJSON.gs and click the save button.
6. Back in the spreadsheet, in a cell, you can type “=ImportJSON(https://bminer.ca/api/v1/balance/PC1Y86W-ZBQ4VQ4-MX9JK1Q-0MT2ACR)” and replace the example APIKEY by yours.

In Excel…

• Create a new excel file
• Go in Data/New Query/From Other Sources/From Web

• Enter your bminer api url https://bminer.ca/api/v1/balance/PC1Y86W-ZBQ4VQ4-MX9JK1Q-0MT2ACR and replace the API Key by yours
• Click on ok, then on Connect
• A new large window will open. Click on “To table”
• Click on the small button circled in red below, and then press OK

• Finally press Close & Load

• pressing the “Refresh” button will refresh your data within seconds