How To Get Cryptocurrency Prices in Google Sheets Using a Free API

·

Tracking cryptocurrency prices in real time is essential for investors, traders, and analysts who want to stay ahead of fast-moving markets. While many platforms offer price data, integrating that information directly into Google Sheets allows for powerful customization, automated analysis, and portfolio tracking—all within a familiar interface. The best part? You can do it for free using a public API and a simple add-on.

This guide walks you through how to import live cryptocurrency prices into Google Sheets using a free API, without writing a single line of code. Whether you're building a personal dashboard or managing a diversified crypto portfolio, this method streamlines your workflow and enhances decision-making.

Why Pull Crypto Prices Into Google Sheets?

Google Sheets is more than just a spreadsheet tool—it’s a dynamic platform for financial modeling, data visualization, and automated reporting. By connecting it to a real-time cryptocurrency API, you unlock several advantages:

With the right setup, your spreadsheet becomes a live crypto dashboard.

👉 Discover how to turn Google Sheets into a real-time crypto tracker with just one click.

Choosing the Right Free Cryptocurrency API

The first step is selecting an API that provides accurate, up-to-date cryptocurrency pricing data. Look for one that offers:

One reliable option is the CoinGecko API, which is completely free, requires no API key for basic requests, and returns JSON-formatted data ideal for spreadsheet integration.

Other popular choices include:

These APIs allow you to fetch data like:

{
  "bitcoin": { "usd": 67200.45 },
  "ethereum": { "usd": 3580.20 }
}

This structured format makes it easy to parse and display in Google Sheets.

Introducing Apipheny: The No-Code API Connector

Manually fetching and parsing API responses would be time-consuming. That’s where Apipheny comes in—a free Google Sheets add-on that lets you pull data from any REST API with just a few clicks.

Key Benefits of Apipheny:

Once installed, Apipheny appears as a sidebar in your sheet, allowing you to configure API calls without leaving your workbook.

👉 Start pulling live crypto prices into Google Sheets—no coding needed.

Step-by-Step: Importing Live Crypto Prices

Follow these steps to get real-time cryptocurrency prices in your Google Sheet.

Step 1: Install Apipheny

  1. Open Google Sheets.
  2. Click Extensions > Add-ons > Get add-ons.
  3. Search for “Apipheny” and install it.
  4. Restart your sheet and open Apipheny from Extensions > Apipheny > Start.

Step 2: Choose Your API Endpoint

For CoinGecko’s simple price endpoint:

https://api.coingecko.com/api/v3/simple/price?ids=bitcoin,ethereum&vs_currencies=usd&include_market_cap=true&include_24hr_vol=true

This URL retrieves:

You can customize the ids and vs_currencies parameters to include more coins or currencies.

Step 3: Paste the URL into Apipheny

  1. In the Apipheny sidebar, paste the full API URL.
  2. Set the method to GET.
  3. Leave headers blank (not required for CoinGecko).
  4. Choose a destination cell (e.g., A1).

Step 4: Run the Request

Click Run, and within seconds, your sheet will populate with structured JSON data converted into rows and columns.

Example output:

bitcoin.usdbitcoin.market_capbitcoin.total_volumeethereum.usdethereum.market_cap
67200.451328901234567289012345673580.20430123456789

Step 5: Automate Updates

In Apipheny, click Auto-run > Set auto-refresh and choose an interval (e.g., every 5 minutes). Now your data updates automatically.

Enhancing Your Crypto Dashboard

Now that you have live data, take it further:

You can also merge data from multiple API calls—track DeFi tokens, NFT floor prices, or exchange rates—all in one workbook.

Frequently Asked Questions (FAQ)

Can I use a cryptocurrency API without an API key?

Yes, some APIs like CoinGecko allow unauthenticated requests for basic price data. However, APIs like CoinMarketCap require a free key to access their endpoints.

Is Apipheny really free?

Yes, Apipheny has a robust free plan suitable for most personal use cases. Paid plans offer advanced features like faster refresh rates and multi-step workflows.

How often can I update crypto prices?

With Apipheny’s free version, you can auto-refresh every 1–10 minutes depending on your needs and API rate limits.

Can I track my own crypto portfolio value?

Absolutely. Once prices are imported, link them to your holdings column and use formulas like =B2*C2 (price × quantity) to compute asset values and sum totals.

What if the API stops working?

Most issues stem from exceeded rate limits or incorrect URLs. Double-check your endpoint syntax and consider switching to an API with higher free-tier limits if needed.

Is my data secure when using Apipheny?

Yes. Apipheny does not store your spreadsheet data. All requests are made client-side through Google’s secure add-on framework.

👉 Turn your Google Sheet into a powerful crypto analytics tool today.

Core Keywords

By leveraging these keywords naturally throughout your content, you improve search visibility while maintaining readability and user engagement.

With minimal setup and no programming skills, you can transform Google Sheets into a dynamic cryptocurrency tracking system. From real-time pricing to automated portfolio calculations, this method empowers both beginners and experienced investors to make informed decisions—fast.

Whether you're monitoring Bitcoin’s next move or evaluating altcoin performance, integrating a free crypto API with Google Sheets via Apipheny is a smart, scalable solution.