⚡ The only add-on with native Auto-Refresh  ·  300+ active users

The crypto price tracker
built for Google Sheets.

⚡ Auto-Refresh every 30 min (Base) or 5 min (Pro)
📊 1,000+ cryptocurrencies via CoinMarketCap
🔑 No API key needed — works out of the box

The only Google Sheets add-on with a native Auto-Refresh button and Unlimited PRO calls. One formula fetches any price from CoinMarketCap — no API keys, no code, no limits.

Install Free → View Plans
✓ Auto-Refresh (Base: 30 min · Pro: 5 min)  ·  ✓ Unlimited calls (Pro)  ·  ✓ No API key needed

One formula to fetch any crypto price

=cryptotrackpro("BTC-USD")

Returns the live USD price of Bitcoin. Works with any symbol — ETH, SOL, XRP, and 1,000+ more.

Everything you need to track crypto in Google Sheets

The only Google Sheets crypto add-on with Auto-Refresh and Unlimited PRO calls.

🔄

Native Auto-Refresh

The only Google Sheets crypto add-on with a built-in Auto-Refresh button. Base subscribers refresh every 30 minutes; Pro subscribers every 5 minutes — no manual action, no workarounds.

⚡

Unlimited PRO Calls

No daily cap, no throttling, no surprises. PRO subscribers get unlimited price fetches — ideal for large portfolios, frequent refreshes, and bulk tracking across multiple sheets.

🔗

1,000+ Cryptocurrencies

Prices sourced live from CoinMarketCap. Supports BTC, ETH, SOL, XRP, and 1,000+ altcoins. Cross-currency pairs too — BTC-USD, ETH-EUR, SOL-BTC, and more.

🛡️

Linked to Your Account

Your subscription is tied to your Google account email. Log in from any device and your plan follows automatically.

📈

Flexible Plans

Start free with 50 calls/day — enough for casual tracking. Upgrade to Base (500/day) or PRO (unlimited) as your needs grow.

🔒

Privacy First

We only store your email and daily usage counts. No spreadsheet data is ever read or stored. Payment details go directly to Stripe.

Free Template

Pre-built Portfolio Tracker

Skip the setup. Get a fully formatted crypto portfolio spreadsheet with live prices, automatic P&L, and colour-coded gains & losses — ready in seconds.

  • ✓ Live prices via =cryptotrackpro()
  • ✓ Automatic P&L in dollars and percent
  • ✓ Green & red conditional formatting
  • ✓ Portfolio % allocation per asset
  • ✓ Pre-loaded with 10 popular coins
Get Free Template →

Opens a copy in your own Google Drive. Requires the free CryptoTrackPro add-on for live prices.

📊 Portfolio
Asset Live Price P&L
BTC $97,450 +12.4%
ETH $2,680 −4.2%
SOL $182 +8.1%
XRP $2.18 +31.2%
+ 6 more assets…
Total Value $24,830.00

Up and running in minutes

No configuration, no API keys, no developer setup.

1

Install the Add-On

Find CryptoTrackPro in the Google Workspace Marketplace and click Install. Free to install.

2

Authorize Permissions

Grant the required Google permissions. We only request access to the current spreadsheet and your email — nothing else.

3

Use the Formula

Type =cryptotrackpro("BTC-USD") in any cell. The live price appears instantly.

Full Installation Guide →

Simple, transparent pricing for every trader

Start free. Upgrade when you need more.

Free
$0/month
Perfect for getting started and casual tracking.
  • 50 price refreshes per day
  • All cryptocurrencies
  • Cross-currency pairs
  • Manual refresh
Install Free
Base
$3.99/month
Ideal for active traders monitoring multiple positions.
  • 500 price refreshes per day
  • All cryptocurrencies & currencies
  • Cross-currency pairs (EUR, GBP, BTC…)
  • Auto-refresh every 30 min + on open
  • RSI, MACD & OHLCV history
  • Historical price lookup (tax)
Subscribe to Base →
⭐ Recommended
Pro
$11.99/month
Comprehensive coverage for professional traders and power users.
  • Unlimited refreshes per day
  • No daily limits, ever
  • Auto-refresh every 5 min + on open
  • Fastest refresh — every 5 minutes
  • All currencies supported
  • RSI, MACD & price history
  • Historical price lookup (tax)
Get Pro →

Subscriptions billed monthly via Stripe. Cancel any time. Manage existing subscription.

Frequently asked questions

Everything you need to know before you install.

What is the formula to get crypto prices in Google Sheets?
The formula is =cryptotrackpro("BTC-USD"). Type it into any cell to get the live Bitcoin price in US dollars. Change the pair for any coin or currency — for example =cryptotrackpro("ETH-EUR") for Ethereum in euros, or =cryptotrackpro("SOL-USD") for Solana. The function name is cryptotrackpro (not "cryptoprice"), there is no API key, and no setup — just install the add-on and type the formula.
What makes CryptoTrackPro different from other crypto add-ons for Google Sheets?
CryptoTrackPro is the only Google Sheets add-on with a native Auto-Refresh button — Base plan refreshes every 30 minutes, Pro plan every 5 minutes (plus on every spreadsheet open) without any manual action. It is also the only add-on offering truly Unlimited price calls on Pro, with no daily cap. Base and Pro users get built-in technical indicators (RSI, MACD, OHLCV history) and all plans include historical price lookup by date for tax and cost-basis calculations. No API key required.
How does Auto-Refresh work in Google Sheets?
On a Base or Pro plan, enable Auto-Refresh via the CryptoTrackPro sidebar toggle. Every =cryptotrackpro() formula will automatically recalculate — every 30 minutes on Base, every 5 minutes on Pro — and on every file open. No page reload or manual trigger needed. You can also trigger a one-time refresh at any time via Extensions → CryptoTrackPro → Refresh Data.
How many cryptocurrencies are supported?
CryptoTrackPro supports over 1,000 cryptocurrencies including Bitcoin (BTC), Ethereum (ETH), Solana (SOL), XRP, Cardano (ADA), Dogecoin (DOGE), Avalanche (AVAX), and hundreds of smaller altcoins. Cross-currency pairs are also supported — for example =cryptotrackpro("ETH-EUR") or =cryptotrackpro("SOL-BTC").
Why are prices showing "—" after I install the add-on?
This is normal on first use. Google Sheets needs to initialise the custom function after the add-on is installed. Simply go to Extensions → CryptoTrackPro → Refresh Data to trigger the first price fetch. Prices will load immediately and the formula will work normally from that point forward.
What is the difference between the Free, Base, and Pro plans?
Free — 50 price refreshes per day, manual refresh only. Historical price lookup included. Great for casual tracking.
Base ($3.99/mo) — 500 refreshes per day, auto-refresh every 30 min + on open, RSI, MACD & OHLCV history, 150+ quote currencies, and historical price lookup for tax/cost-basis.
Pro ($11.99/mo) — Unlimited refreshes, no daily cap, auto-refresh every 5 min + on open, plus everything in Base. Built for power users and large portfolios.
Can I get technical indicators like RSI and MACD in Google Sheets?
Yes. Base and Pro plan users can use the built-in indicator formulas directly in any cell:

=cryptotrackproRSI("BTC", 14) — Relative Strength Index
=cryptotrackproMACD("BTC", "line") — MACD line, signal, or histogram
=cryptotrackproHistory("BTC", 30) — 30-day OHLCV table (date, open, high, low, close, volume)

All Free plan users can also look up the price of any coin on a specific past date using =cryptotrackproPrice("BTC", "2025-01-01") — useful for calculating cost basis and tax reports.
Do I need an API key or developer account?
No. CryptoTrackPro requires no API key, no developer account, and no external setup. Install the add-on from the Google Workspace Marketplace, accept the permissions prompt, and the formula works immediately. All connectivity to CoinMarketCap is handled server-side.
Is there a free crypto portfolio tracker template I can use?
Yes — download the free portfolio tracker template. It comes pre-built with live prices, automatic P&L calculations in dollars and percent, colour-coded gains and losses, portfolio allocation bars, and auto-generated charts. Just make a copy to your Google Drive and enter your holdings.

Learn how to track crypto in Google Sheets

Practical, no-code guides — prices, portfolios, tax and more.

How to get live crypto prices in Google Sheets The one-formula method for Bitcoin, Ethereum & 1,000+ coins — no API key. How to get the Bitcoin price in Google Sheets Live & historical BTC prices — dollars, euros, sats. How to get the Ethereum price in Google Sheets Live & historical ETH prices, plus the ETH/BTC ratio. Build a crypto portfolio tracker in Google Sheets Live value, allocation and profit/loss that update themselves. Crypto tax & cost basis in Google Sheets Automatic historical buy prices and per-lot gains for tax time. A simpler crypto add-on for Google Sheets Comparing crypto add-ons? See where CryptoTrackPro fits. Browse all guides → Every tutorial in one place.

Ready to track crypto in Sheets?

Install for free and start using =cryptotrackpro() in seconds.

Install Free → See Paid Plans