How to Use the CRYPTOFINANCE Add-on for Google Sheets

Cryptocurrency investors and analysts are constantly seeking efficient ways to monitor market movements, track portfolio performance, and derive actionable insights. One powerful tool that bridges the gap between real-time crypto data and intuitive analysis is the CRYPTOFINANCE add-on for Google Sheets. This integration allows users to pull live cryptocurrency pricing, exchange rates, and market metrics directly into their spreadsheets—enabling dynamic tracking and reporting without leaving a familiar environment.

Now integrated with Cryptowatch, CRYPTOFINANCE provides access to real-time and historical data from over 988 cryptocurrencies across 29 major exchanges. Whether you're building a personal portfolio tracker or analyzing market trends, this tool streamlines data retrieval through simple formulas.

In this guide, we’ll walk you through how to install, configure, and effectively use the CRYPTOFINANCE add-on—plus tips on creating your own automated crypto dashboard.

Why Use CRYPTOFINANCE in Google Sheets?

Google Sheets is more than just a spreadsheet tool—it’s a lightweight data analytics platform. When enhanced with the CRYPTOFINANCE function, it becomes a powerful resource for cryptocurrency monitoring. Here’s why it stands out:

• Real-time data synchronization: Maintain a live feed of cryptocurrency prices and metrics directly in your sheet.
• Familiar interface: Leverage Google Sheets’ intuitive layout without needing to learn new software.
• Advanced analytics capabilities: Combine live data with built-in functions like QUERY, FILTER, or GOOGLEFINANCE-style formulas to generate charts, calculate returns, or set price alerts.
• Customizable dashboards: Build personalized views for your portfolio, watchlists, or trading strategies.

👉 Discover how to turn live crypto data into smart financial decisions with powerful tools.

To access CRYPTOFINANCE, you’ll need a Cryptowatch account, which offers both free and paid plans. The free tier includes 100 API requests per day, while premium tiers offer higher limits and access to historical data. You can also try the Derivative plan free for two weeks.

How to Install CRYPTOFINANCE on Google Sheets

Since the original add-on has been deprecated, the current method involves embedding a custom script. Follow these steps carefully:

Step 1: Remove Old CRYPTOFINANCE Add-on (If Installed)

If you previously used the legacy version:

1. Open your Google Sheet.
2. Go to Add-ons > Manage add-ons.
3. Find CRYPTOFINANCE, click the three-dot menu (⋮), and select Uninstall.

This ensures no conflicts with the updated script-based version.

Step 2: Add the Custom Script

1. In your Google Sheet, go to Tools > Script editor. A new tab will open.
2. Delete any default code in the editor.
3. Paste the official CRYPTOFINANCE.gs script (available via Cryptowatch documentation).
4. Save the project with a clear name like “Crypto Data Connector” using the floppy disk icon.

Step 3: Run the Script and Reload

1. Click the Run button (▶️) in the toolbar.
2. Grant necessary permissions when prompted—this allows the script to interact with your sheet.
3. Return to your Google Sheet and refresh the page.

A new CRYPTOFINANCE menu should now appear in the top toolbar—indicating successful installation.

How to Use CRYPTOFINANCE in Google Sheets

With the script active, you can start pulling real-time cryptocurrency data using simple formulas. However, first, you must authenticate via an API key from Cryptowatch.

Step 1: Sign In or Create a Cryptowatch Account

Visit cryptowat.ch and sign up or log in. The platform offers a clean interface for managing your API access and monitoring usage.

Step 2: Generate Your API Key

1. After logging in, click your profile icon in the top-right corner.
2. Select API Access from the dropdown.
3. Enter a descriptive name for your key (e.g., “Google Sheets Integration”).
4. Click Generate Key.

Two keys will appear:

• Public Key (required)
• Private Key (keep secure; not needed for CRYPTOFINANCE)

Only the public key is used for this integration.

Step 3: Connect API Key to Google Sheets

1. Back in your sheet, go to CRYPTOFINANCE > Enter Cryptowatch Public API Key.
2. Paste your public key and click OK.

Your sheet is now authenticated and ready to fetch data.

Step 4: Enter Formulas to Extract Data

All queries begin with:

=CRYPTOFINANCE("EXCHANGE/SYMBOL")

Example 1: Fetch All Available Cryptocurrency Data

Use:

=CRYPTOFINANCE("CRYPTOWATCH")

This populates a table with real-time data for all supported cryptocurrencies—including symbol, price, volume, and exchange sources.

Example 2: Get Price of Bitcoin in USD

To retrieve BTC’s current USD value:

=CRYPTOFINANCE("BTC/USD")

The cell will display the latest market price from aggregated exchanges.

You can replace BTC with any coin (e.g., ETH, SOL) and USD with other fiat or stablecoins like EUR, USDT, or USDC.

👉 Turn real-time crypto data into powerful investment insights—start analyzing smarter today.

How to Create Your Own Crypto Portfolio Tracker

Once you have raw data flowing in, the next step is building a personalized dashboard.

Step 1: Set Up Your Source Sheet

Run =CRYPTOFINANCE("CRYPTOWATCH") in a dedicated tab named "All Cryptocurrency". This serves as your central data repository.

Step 2: Create a Portfolio Tab

1. Add a new tab titled "My Portfolio".
2. Copy relevant headers from the source sheet (e.g., Name, Symbol, Price, Market Cap).

Step 3: Pull Specific Asset Data

Locate the row of each cryptocurrency in your source sheet. For example:

• Bitcoin might be in cell B4
• Ethereum in B5

Use cell referencing to pull values:

='All Cryptocurrency'!B4

Drag the fill handle across columns to auto-populate adjacent fields (price, change %, volume, etc.).

Repeat for each asset you hold. You can even add columns for:

• Quantity owned
• Total value (=Price * Quantity)
• Profit/loss calculations

This transforms your sheet into a dynamic, self-updating portfolio tracker.

Frequently Asked Questions (FAQ)

Q: Is the CRYPTOFINANCE add-on still available in the Google Workspace Marketplace?
A: No. The original add-on has been discontinued. Users must now use the script-based method via Google Apps Script.

Q: Do I need to pay to use CRYPTOFINANCE?
A: Access depends on your Cryptowatch plan. The free tier allows 100 daily API requests—enough for light personal use. Heavy users should consider paid plans with more credits.

Q: Can I pull historical cryptocurrency data?
A: Yes—but only with higher-tier Cryptowatch subscriptions. The free plan supports real-time data only.

Q: What exchanges does CRYPTOFINANCE support?
A: It pulls aggregated data from major exchanges including Binance, Coinbase, Kraken, Bitstamp, and more—covering over 988 digital assets.

Q: Is my API key safe when used in Google Sheets?
A: The public key is safe to share within trusted sheets. Never expose your private key. Avoid publishing sheets publicly if they contain any API credentials.

Q: Can I automate alerts or notifications based on price changes?
A: Yes! Combine CRYPTOFINANCE with Google Sheets’ IF statements and email triggers via Apps Script to create custom price alerts.

Maximize Your Financial Workflow with Automation

While CRYPTOFINANCE excels at bringing crypto data into spreadsheets, integrating it into broader financial systems unlocks even greater value. Consider combining it with other automation tools to manage budgets, track investments, or reconcile transactions—all within a unified spreadsheet environment.

👉 Explore next-generation financial tools that integrate seamlessly with live market data.

By leveraging real-time data, customizable formulas, and automated workflows, you can stay ahead in the fast-moving world of digital assets—without complex software or coding expertise.

Core Keywords:
cryptocurrency tracker, Google Sheets crypto formula, real-time crypto data, CRYPTOFINANCE add-on, Cryptowatch API, crypto portfolio tracker, automated finance tools, blockchain data integration