CoinAPI.io Blog - CoinAPI Google sheets integration

In the world of cryptocurrencies, having access to accurate and up-to-date data is crucial. You can integrate crypto data into Google Sheets with CoinAPI to create a simple environment for tracking exchange rates, analyzing historical data, comparing assets, and building reports.

This combination can be useful for cryptocurrency enthusiasts, developers, researchers, brokers, and financial teams that want to work with crypto data without building a separate application.

In this tutorial, we’ll use CoinAPI Exchange Rates to retrieve a current BTC/USD rate directly from Google Sheets.

What you will learn

In this blog post, we will guide you through the process of integrating CoinAPI with Google Sheets.

By the end of the tutorial, you’ll be able to:

Connect Google Sheets to CoinAPI using Google Apps Script
Retrieve the current BTC/USD exchange rate
Store your CoinAPI key more securely
Work with supported CoinAPI asset IDs
Refresh data when needed
Use CoinAPI data for basic analysis and visualization

For continuous streaming data, CoinAPI also supports WebSocket. Google Sheets, however, works better with REST requests that run on demand or according to a scheduled trigger.

Other tutorials you may like:

How to Create Cryptocurrency Charts with Python and CoinAPI: A Step-by-Step Guide for Developers

Benefits of CoinAPI and Google Sheets Integration

Here are some of the potential benefits of integrating CoinAPI with Google Sheets.

Current Data Access

Crypto prices can change quickly, so having access to current exchange rates is useful for dashboards, reporting, portfolio valuation, and market analysis.

CoinAPI Exchange Rates provides standardized crypto/crypto, crypto/fiat, and fiat/fiat rates across supported assets.

In this tutorial, Google Sheets requests the latest available rate whenever the Apps Script function executes.

This distinction is important: the sheet is not receiving a continuous real-time stream. It is requesting the current rate from CoinAPI at a particular moment. For continuously updated streams, WebSocket is more appropriate.

No Need for Advanced Programming Skills

One of the biggest advantages of this integration is accessibility.

You don’t need to build a complete application or maintain exchange integrations yourself. However, this tutorial does use a small amount of Google Apps Script, which is based on JavaScript.

Once the script is configured, the resulting function can be used directly from your spreadsheet.

For some simpler spreadsheet workflows, CoinAPI also supports CSV-based approaches that can be imported into Google Sheets.

How to Set Up CoinAPI Google Sheets Integration

To begin, you need a CoinAPI account and API key.

Create your account through the API BRICKS Console and generate an API key for your CoinAPI product.

New accounts can start with $25 in free credits after the required account setup and payment-method verification. After those credits are used, consumption is billed according to the relevant product's metered pricing.

Because this tutorial retrieves exchange rates, usage is based on the pricing rules for the exchange-rate data being requested.

Before continuing, make sure you have:

A Google account
A Google Sheet
Access to the API BRICKS Console
A CoinAPI API key
Permission to use Google Apps Script

Store Your CoinAPI Key Securely

Avoid placing your API key directly inside a spreadsheet cell or hardcoding it into a script that other people can access.

Instead, you can store it using Apps Script Properties.

Open your Google Sheet and select:

Extensions → Apps Script

In the Apps Script editor, open Project Settings → Script Properties and create a property:

1COINAPI_KEY

Set its value to your CoinAPI API key.

Your script can then retrieve the key using:

1const apiKey = PropertiesService
2  .getScriptProperties()
3  .getProperty('COINAPI_KEY');

This keeps the key out of spreadsheet cells and the main script source.

You should still control who can access or edit the Apps Script project and avoid exposing credentials in shared code.

Integrating CoinAPI with Google Sheets

Now you can create a custom Google Sheets function.

In the Apps Script editor, add:

1function getCryptoRate(baseAsset, quoteAsset) {
2  const apiKey = PropertiesService
3    .getScriptProperties()
4    .getProperty('COINAPI_KEY');
5
6  if (!apiKey) {
7    throw new Error('COINAPI_KEY is not configured.');
8  }
9
10  baseAsset = String(baseAsset).toUpperCase();
11  quoteAsset = String(quoteAsset).toUpperCase();
12
13  const url =
14    'https://rest.coinapi.io/v1/exchangerate/' +
15    encodeURIComponent(baseAsset) +
16    '/' +
17    encodeURIComponent(quoteAsset);
18
19  const options = {
20    method: 'get',
21    headers: {
22      'X-CoinAPI-Key': apiKey
23    },
24    muteHttpExceptions: true
25  };
26
27  const response = UrlFetchApp.fetch(url, options);
28  const status = response.getResponseCode();
29
30  if (status === 429) {
31    throw new Error(
32      'Usage or request limit reached. Check your usage in the API BRICKS Console.'
33    );
34  }
35
36  if (status < 200 || status >= 300) {
37    throw new Error(
38      'CoinAPI request failed with HTTP status ' + status
39    );
40  }
41
42  const data = JSON.parse(response.getContentText());
43
44  if (data.rate === undefined) {
45    throw new Error('No exchange rate returned.');
46  }
47
48  return data.rate;
49}

Save the script.

Back in your Google Sheet, you can now enter:

1=getCryptoRate("BTC","USD")

The function requests the current BTC/USD exchange rate from CoinAPI and returns the rate value to the cell.

You could also use:

1=getCryptoRate("ETH","EUR")

or another supported pair of CoinAPI asset IDs.

Not every arbitrary string represents a valid asset, so applications should use supported CoinAPI asset identifiers.

Current Exchange Rate Data with CoinAPI

The request used in the example corresponds to:

1GET /v1/exchangerate/BTC/USD

When no historical time parameter is supplied, the endpoint returns the current exchange rate for the requested base and quote assets.

A typical response includes:

1{
2  "time": "2026-09-02T03:50:46.4885936Z",
3  "asset_id_base": "BTC",
4  "asset_id_quote": "USD",
5  "rate": 10000
6}

The value above is only an example response structure. Your request will return the rate and timestamp available when the request is processed.

CoinAPI Exchange Rates are reference rates rather than the latest trade from one specific exchange. They are calculated using CoinAPI's exchange-rate methodology across multiple market-data sources.

How Google Sheets Refreshes CoinAPI Data

A custom Google Sheets function does not behave like a continuous market-data stream.

Google Sheets may cache custom-function results, and recalculation does not guarantee that an API request will run continuously or at an exact market-data frequency.

For dashboards that need periodic updates, you can use a time-driven Apps Script trigger.

For example, instead of relying only on a custom spreadsheet function, you can create a function that writes the latest value into a specific cell and schedule it through:

Apps Script → Triggers → Add Trigger

From there, you can configure an appropriate time-driven refresh schedule.

Be careful with very frequent refreshes. Every API call consumes resources on both Google Apps Script and CoinAPI, and Google also applies its own Apps Script quotas.

For applications requiring continuous real-time updates, CoinAPI WebSocket is a more appropriate architecture than Google Sheets.

Understanding CoinAPI Usage and Pricing

CoinAPI does not use a traditional unlimited free tier.

New accounts can start with free credits, after which usage is billed according to the relevant product's metered pricing. PAYG and committed plans are available depending on the required usage.

For Exchange Rates API, usage is measured in rates. A rate represents a price for a specific asset pair.

This means repeatedly refreshing a spreadsheet can increase usage, so your refresh frequency should match the actual requirements of the spreadsheet.

Check the current CoinAPI Exchange Rates API pricing before implementing a frequently refreshed dashboard.

Working with Historical Data

The same integration can also be extended beyond current rates.

For example, CoinAPI Exchange Rates provides historical rate snapshots and OHLC time-series data. This can support reporting, valuation, volatility analysis, and other historical research.

If you need exchange-specific historical market data rather than standardized exchange rates, Market Data API provides datasets such as OHLCV, trades, quotes, and order books.

For large-scale historical research and backtesting, CoinAPI Flat Files is generally more appropriate than repeatedly downloading large datasets into Google Sheets.

Google Sheets works best for relatively small analytical datasets rather than large tick-level histories.

Exploring Data Analysis Scenarios

Once CoinAPI data is available in Google Sheets, you can use standard spreadsheet functions, charts, and formulas to analyze it.

1. Price and Statistical Analysis

You can calculate average, high, low, percentage changes, and other statistics for historical cryptocurrency data.

This provides a basic view of historical price behavior.

It should not be confused with market sentiment analysis, which normally requires additional inputs such as news, social data, surveys, or other sentiment-related information.

2. Correlation Analysis

If you are tracking historical values for multiple cryptocurrencies, you can use the CORREL function in Google Sheets to measure how two series moved relative to each other during a selected period.

For example:

1=CORREL(B2:B100,C2:C100)

Correlation describes historical statistical relationships. It does not predict how two assets will behave in the future.

3. Volatility Tracking

With a historical price series, you can use spreadsheet functions such as standard deviation to analyze historical volatility.

For more sophisticated research, you may want to work with CoinAPI OHLCV or event-level historical data outside Google Sheets.

4. Price Comparison and Monitoring

CoinAPI data can also support spreadsheet workflows such as:

Asset valuation
Price monitoring
Historical rate comparison
Portfolio reporting
Cross-asset analysis
Volatility tracking
Dashboard creation

For exchange-specific comparisons, use the appropriate CoinAPI Market Data datasets rather than treating a standardized exchange rate as the price from an individual exchange.

Practical Use Cases

Here are a few examples of how CoinAPI and Google Sheets can work together.

Cryptocurrency Portfolio Tracking: Use current or historical exchange rates to calculate portfolio valuations in a selected fiat or cryptocurrency denomination.

Market Analysis: Create tables and charts for historical price behavior, correlations, volatility, and other market statistics.

Reporting: Pull exchange-rate data into financial, accounting, treasury, or research spreadsheets.

Price Monitoring: Periodically update selected asset pairs and use Google Sheets or Apps Script logic to monitor specified conditions.

Research: Combine historical CoinAPI data with spreadsheet formulas and visualization tools for smaller research datasets.

Trading execution is a separate workflow. The integration demonstrated here retrieves data only. Executing orders requires appropriate trading infrastructure, such as CoinAPI EMS Trading API, connected exchange accounts, authentication, and suitable trading and risk controls.

CoinAPI and Google Sheets: Start Building

Integrating CoinAPI with Google Sheets gives you a straightforward way to bring cryptocurrency exchange-rate data into a familiar spreadsheet environment.

For simple dashboards and reporting, you can request current rates through REST and refresh them when needed. Historical endpoints can extend the spreadsheet into basic research and analysis, while more demanding applications can move to CoinAPI WebSocket, Market Data API, or Flat Files depending on the workload.

Start by creating your API key in the API BRICKS Console, add it securely to Apps Script Properties, and try your first:

1=getCryptoRate("BTC","USD")

From there, you can expand the sheet with additional assets, charts, historical data, and scheduled updates.

Note: The information provided in this blog post is for informational and educational purposes only. It should not be considered financial or investment advice.

CoinAPI Google sheets integration