By the CryptoTrackPro team · Published
Quick answer: install CryptoTrackPro, connect through its sidebar, and enter =cryptotrackpro("BTC-USD"). You do not need to create or supply a market-data API key. An account connection and plan limits still apply.
“Without an API key” describes your setup experience. An add-on can manage its own connection to data providers so you do not maintain credentials or write request code. The underlying data still comes from services with their own availability, coverage, and limits.
That can be useful for a personal portfolio, a research watchlist, or a template you want to start using today. A direct integration is another valid option when you need specific endpoints or control over request scheduling. The useful question is which responsibilities you want to own.
1. Build a small table before a large dashboard
Install CryptoTrackPro from Google Workspace Marketplace, open your spreadsheet, and choose Extensions → CryptoTrackPro → Open CryptoTrackPro. Complete the account connection before adding formulas. If the menu has not appeared after installation, reload the sheet and check that you are using the Google account where you installed the add-on.
Create these columns in a blank tab. Put USD in G1 as the reporting currency, and use plain numeric values in the Units column:
| Row | A: Symbol | B: Units | C: Pair | D: Price | E: Value |
|---|---|---|---|---|---|
| 2 | BTC | 0.01 | =A2&"-"&$G$1 | =cryptotrackpro(C2) | =B2*D2 |
| 3 | ETH | 0.2 | Copy the row 2 formulas down | ||
| 4 | SOL | 2 | Copy the row 2 formulas down | ||
The pair column makes the request visible: BTC-USD, ETH-USD, and SOL-USD. You can inspect a wrong symbol or reporting currency without opening a formula. Keep a single price cell for each pair and reference it from other tabs instead of repeating the same external lookup throughout the workbook.
To check the calculations before fetching quotes, enter invented prices of 60,000, 3,000, and 150 in D2:D4. The resulting values should be $600, $600, and $300. Replace those sample prices with the add-on formulas afterward; the actual results will differ.
2. Know what changes with each approach
| Task | CryptoTrackPro | Your own API integration |
|---|---|---|
| Credentials | Connect your add-on account; no provider key to enter | Configure the authentication required by the chosen endpoint |
| Formula behavior | Use the add-on's documented functions | Write or maintain code that transforms the response into cells |
| Coverage | Assets and fields supported by the add-on | Endpoints and fields supported by your provider and access plan |
| Limits | Your add-on plan and service constraints | Your provider plan plus the spreadsheet execution environment |
| Maintenance | Provider connection maintained by the add-on developer | You handle credential changes, response changes, errors, and retries |
Some alternatives occupy the middle ground. CoinGecko's official Sheets add-on supplies the formulas but asks the user to configure a CoinGecko API key. Its official setup documentation describes that process. It is an available option, not evidence that crypto spreadsheet formulas have stopped working generally.
For a direct CoinMarketCap Pro API integration, its authentication documentation specifies how to supply a key and track credits. Keep those credentials out of public template cells or shared examples.
3. Plan around refresh and usage
A visible price formula does not mean the cell streams every market update. In CryptoTrackPro, use Extensions → CryptoTrackPro → Refresh All Prices when you need an updated review. Base timed updates run every 30 minutes and Pro updates every 5 minutes while the sheet and sidebar stay open; closing the sidebar stops the timer.
Free includes 50 daily calls. Base costs $3.99 per month for 500 daily calls, and Pro costs $11.99 per month with unlimited daily calls. First-time users receive a 30-day Base trial with no card and move to Free unless they subscribe. The plans page explains the current options.
As a rough workload estimate, 20 price cells refreshed 10 times means up to 200 price lookups before other uses. Caching and the way you refresh can affect counted usage, so check the sidebar counter instead of assuming that opening a sheet always costs exactly one call per row.
4. Handle an unavailable price honestly
Do not replace a failed lookup with zero just to make a dashboard look tidy. With the table above, use =IF(COUNT(D2:D4)=3,SUM(E2:E4),NA()) for the total. If a price is missing, inspect that cell and the sidebar usage before trusting the valuation.
A direct API also needs error handling. CoinMarketCap distinguishes invalid requests, authentication problems, unavailable plan access, and rate-limit errors in its troubleshooting documentation. Repeating a failing request faster is not a general solution.
Start with this three-asset check or copy the free portfolio template. Once your symbols, refresh routine, and daily usage work, expand the dashboard. If you distribute spreadsheets to customers, the template creator checklist covers onboarding and keeping the price inputs separate from your product's calculations.
Start with a working portfolio sheet
Copy the free template, install CryptoTrackPro, and adapt the layout to your workflow. First-time users get a 30-day Base trial with no card required.
Get the free portfolio template