How to Add Live Crypto Prices in Google Sheets: A Simple Guide

How to Add Live Crypto Prices in Google Sheets: A Simple Guide

This is what a crypto-tracking Google sheet looks like.

Google Sheets is a great tool for tracking live cryptocurrency prices. Whether you are tracking Bitcoin, Ethereum, or any other coin, you can set up your sheet to fetch the latest data automatically. Here is a detailed tutorial to get you started.

Method 1: Using the GOOGLEFINANCE Function (For Bitcoin Only)

1. Open Google Sheets: Start with a new spreadsheet.

Enter the Formula: In a cell, type:

Copy code
=GOOGLEFINANCE(“BTCUSD”)

2. This will display the price of Bitcoin in US dollars right now. Keep in mind that this works only for Bitcoin and a few other coins.

Method 2: Using Cryptosheets Add-On (For More Coins)

1. Install Cryptosheets:
   • Go to Extensions > Add-ons > Get add-ons in Google Sheets.
   • Search for Cryptosheets and click “Install.”
2. Connect to Cryptosheets:
   After installing, open Cryptosheets from the Extensions menu and sign up or log in to connect it to your Google Sheets.

Fetch Prices:
Use the formula provided by Cryptosheets to get live prices, like:
arduino
Copy code
=CS(“price”, “BTC”, “USD”)

3. This will display the price of Bitcoin in US dollars right now. You can change the coin symbol (e.g., ETH for Ethereum) to track other cryptocurrencies.

Method 3: Using API and IMPORTDATA (For Custom Coins)

1. Get an API Key:
   • Go to websites like CoinGecko or CoinMarketCap and get a free API key.

Use IMPORTDATA to Fetch Prices:
In your Google Sheets cell, enter the following formula:
scss
Copy code
=IMPORTDATA(“https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=usd”)

2. This will pull the Bitcoin price in USD from CoinGecko. You can replace “bitcoin” with other coins like “ethereum” or “dogecoin.”

Method 4: Using Google Apps Script (For Advanced Users)

1. Open Google Apps Script:
   Go to Extensions > Apps Script.

Write the Script:
Copy and paste this code:
javascript
Copy code
function getCryptoPrice(crypto, currency) {

  const url = `https://api.coingecko.com/api/v3/simple/price?ids=${crypto}&vs_currencies=${currency}`;

  const response = UrlFetchApp.fetch(url);

  const json = JSON.parse(response.getContentText());

  return json[crypto][currency];

}

Save the script and use this formula in your Google Sheet:
arduino
Copy code
=getCryptoPrice(“bitcoin”, “usd”)

Extra Tips

• Create a Crypto Dashboard: Track multiple cryptocurrencies in one sheet.
• Use Conditional Formatting: Color-code prices to easily spot price changes.
• Refresh Data Carefully: Be aware of API limits, and avoid refreshing too often.

Conclusion

Now you can easily track live crypto prices in Google Sheets. Whether you use simple formulas or advanced scripts, Google Sheets offers flexibility for both beginners and experienced users. Stay updated with real-time data and make smarter trading decisions.