No API keys, no code, no configuration — just one formula and you're live.
Open the CryptoTrackPro listing on the Google Workspace Marketplace and click Install. You can also install from inside Google Sheets: click Extensions → Add-ons → Get add-ons, then search for "CryptoTrackPro".
Click through the authorization screen and grant the requested permissions. You'll see a list of scopes — make sure all checkboxes are ticked before clicking Allow. The add-on requires access to:
Important: The permission checkboxes are unchecked by default. Scroll through the list and tick each one before clicking Allow — otherwise the add-on won't be able to fetch prices.
In any cell, type the formula:
=cryptotrackpro("BTC-USD")
The cell will populate with the current Bitcoin price in USD. Replace BTC-USD with any supported pair:
=cryptotrackpro("ETH-USD")=cryptotrackpro("SOL-EUR")=cryptotrackpro("XRP-BTC")=cryptotrackpro("DOGE-USD")The format is always SYMBOL-QUOTE — base asset first, then the currency you want the price in. Supports 1,000+ cryptocurrencies and cross-pair calculations.
Prices don't update automatically on formula entry — you refresh on demand:
The free plan includes 50 refreshes per day — enough for casual tracking. When you need more, head to the Plans page to subscribe to Base (500/day) or PRO (unlimited). Use the same Google account email that you use in Sheets.
Instead of hardcoding a symbol, you can reference cells — so changing a ticker in one place updates your entire sheet instantly.
Put the ticker in cell A2 (e.g. BTC) and reference it:
=cryptotrackpro(A2&"-USD")
A2 = ticker, B2 = quote currency (e.g. EUR):
=cryptotrackpro(A2&"-"&B2)
A2 = ticker, B2 = how many coins you own — multiply to get current value:
=cryptotrackpro(A2&"-USD")*B2
Set up your sheet with three columns — the formula in column C does the rest. After refreshing, column C shows the live USD value of each holding.
| A — Ticker | B — Holdings | C — Value (USD) |
|---|---|---|
| BTC | 0.5 | =cryptotrackpro(A2&"-USD")*B2 |
| ETH | 2.0 | =cryptotrackpro(A3&"-USD")*B3 |
| SOL | 10 | =cryptotrackpro(A4&"-USD")*B4 |
| Total portfolio value → | =SUM(C2:C10) | |
Add as many rows as you like. Hit Refresh Data from the Extensions menu to update all prices at once.
=cryptotrackpro("BTC-USD")
=cryptotrackpro(A2&"-USD")
=cryptotrackpro(A2&"-"&B2)
=cryptotrackpro(A2&"-USD")*B2
=SUM(C2:C10)
CryptoTrackPro requests a small set of Google OAuth scopes. Here's exactly what we access and why:
Read and write access to the current spreadsheet only. Used to detect formula cells and write live prices back into them. We cannot access any of your other Google Sheets or Drive files.
Allows the add-on to make secure HTTPS requests to our price backend. This is how live cryptocurrency prices are fetched on demand.
Reads your Google account email address solely to identify your subscription tier and apply the appropriate usage allowance. We never share your email with third parties other than Stripe for payment processing.
Allows the add-on to display the sidebar and menu items inside Google Sheets. Required to render the CryptoTrackPro interface.
We never read spreadsheet content that doesn't contain our formula, never store pricing or portfolio data, and never share information beyond what's outlined in our Privacy Policy.
Make sure to use the exact format: =cryptotrackpro("BTC-USD") — with the symbol in quotes and a hyphen between the base and quote currency. Then use Refresh Data from the Extensions menu.
This means not all permission checkboxes were ticked during authorization. Go to Extensions → CryptoTrackPro → any menu item, click through the authorization flow again, and make sure all checkboxes are checked before clicking Allow.
Free accounts get 50 refreshes per day, resetting at midnight US Central Time. To get more refreshes, upgrade to Base or Pro.
Make sure you subscribed using the same Google account email that you use in Sheets. If you used a different email, contact us and we'll sort it out. Your plan activates within a few minutes of payment.