Back to blog
Research

Crypto API to Google Sheets in 5 Minutes: How to Use Token Metrics API with Apps Script

If you're a trader, data analyst, or crypto enthusiast, chances are you've wanted to pull live crypto data directly into Google Sheets. Whether you're tracking prices, building custom dashboards, or backtesting strategies, having real-time data at your fingertips can give you an edge.
Token Metrics Team
6 min
Want Smarter Crypto Picks—Free?
See unbiased Token Metrics Ratings for BTC, ETH, and top alts.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
 No credit card | 1-click unsubscribe

If you're a trader, data analyst, or crypto enthusiast, chances are you've wanted to pull live crypto data directly into Google Sheets. Whether you're tracking prices, building custom dashboards, or backtesting strategies, having real-time data at your fingertips can give you an edge.

In this guide, we'll show you how to integrate the Token Metrics API — a powerful crypto API with free access to AI-powered signals — directly into Google Sheets in under 5 minutes using Google Apps Script.

📌 Why Use Google Sheets for Crypto Data?

Google Sheets is a flexible, cloud-based spreadsheet that:

  • Requires no coding to visualize data
  • Can be shared and updated in real time
  • Offers formulas, charts, and conditional formatting
  • Supports live API connections with Apps Script

When combined with the Token Metrics API, it becomes a powerful dashboard that updates live with Trader Grades, Bull/Bear Signals, historical OHLCV data, and more.

🚀 What Is Token Metrics API?

The Token Metrics API provides real-time and historical crypto data powered by AI. It includes:

  • Trader Grade: A score from 0 to 100 showing bullish/bearish potential
  • Bull/Bear Signal: A binary signal showing market direction
  • OHLCV: Open-High-Low-Close-Volume price history
  • Token Metadata: Symbol, name, category, market cap, and more

The best part? The free Basic Plan includes:

  • 5,000 API calls/month
  • Access to core endpoints
  • Hourly data refresh
  • No credit card required

👉 Sign up for free here

🛠️ What You’ll Need

  • A free Token Metrics API key
  • A Google account
  • Basic familiarity with Google Sheets

⚙️ How to Connect Token Metrics API to Google Sheets

Here’s how to get live AI-powered crypto data into Sheets using Google Apps Script.

🔑 Step 1: Generate Your API Key

  1. Visit: https://app.tokenmetrics.com/en/api
  2. Click “Generate API Key”
  3. Copy it — you’ll use this in the script

📄 Step 2: Create a New Google Sheet

  1. Go to Google Sheets
  2. Create a new spreadsheet
  3. Click Extensions > Apps Script

💻 Step 3: Paste This Apps Script

const TOKEN_METRICS_API_KEY = 'YOUR_API_KEY_HERE';

async function getTraderGrade(symbol) {

  const url = `https://api.tokenmetrics.com/v2/trader-grades?symbol=${symbol.toUpperCase()}`;

  const options = {

    method: 'GET',

    contentType: 'application/json',

    headers: {

      'accept': 'application/json',

      'x-api-key': TOKEN_METRICS_API_KEY,

    },

    muteHttpExceptions: true

  };

  

  const response = UrlFetchApp.fetch(url, options);

  const data = JSON.parse(response.getContentText() || "{}")

  

  if (data.success && data.data.length) {

    const coin = data.data[0];

    return [

      coin.TOKEN_NAME,

      coin.TOKEN_SYMBOL,

      coin.TA_GRADE,

      coin.DATE

    ];

  } else {

    return ['No data', '-', '-', '-'];

  }

}

async function getSheetData() {

  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

  const symbols = sheet.getRange('A2:A').getValues().flat().filter(Boolean);

  const results = [];

  results.push(['Name', 'Symbol', 'Trader Grade', 'Date']);

  for (const symbol of symbols) {

    if (symbol) {

      const row = await getTraderGrade(symbol);

      results.push(row);

    }

  }

  sheet.getRange(2, 2, results.length, results[0].length).setValues(results);

}

🧪 Step 4: Run the Script

  1. Replace 'YOUR_API_KEY_HERE' with your real API key.
  2. Save the project as TokenMetricsCryptoAPI.
  3. In your sheet, enter a list of symbols (e.g., BTC, ETH, SOL) in Column A.
  4. Go to the script editor and run getSheetData() from the dropdown menu.

Note: The first time, Google will ask for permission to access the script.

✅ Step 5: View Your Live Data

After the script runs, you’ll see:

  • Coin name and symbol
  • Trader Grade (0–100)
  • Timestamp

You can now:

  • Sort by Trader Grade
  • Add charts and pivot tables
  • Schedule automatic updates with triggers (e.g., every hour)

🧠 Why Token Metrics API Is Ideal for Google Sheets Users

Unlike basic price APIs, Token Metrics offers AI-driven metrics that help you:

  • Anticipate price action before it happens
  • Build signal-based dashboards or alerts
  • Validate strategies against historical signals
  • Keep your data fresh with hourly updates

And all of this starts for free.

🏗️ Next Steps: Expand Your Sheet

Here’s what else you can build:

  • A portfolio tracker that pulls your top coins’ grades
  • A sentiment dashboard using historical OHLCV
  • A custom screener that filters coins by Trader Grade > 80
  • A Telegram alert system triggered by Sheets + Apps Script + Webhooks

You can also upgrade to the Advanced Plan to unlock 21 endpoints including:

  • Investor Grades
  • Smart Indices
  • Sentiment Metrics
  • Quantitative AI reports
  • 60x API speed

🔐 Security Tip

Never share your API key in a public Google Sheet. Use script-level access and keep the sheet private unless required.

🧩 How-To Schema Markup (for SEO)

{

  "@context": "https://schema.org",

  "@type": "HowTo",

  "name": "Crypto API to Google Sheets in 5 Minutes",

  "description": "Learn how to connect the Token Metrics crypto API to Google Sheets using Google Apps Script and get real-time AI-powered signals and prices.",

  "totalTime": "PT5M",

  "supply": [

    {

      "@type": "HowToSupply",

      "name": "Google Sheets"

    },

    {

      "@type": "HowToSupply",

      "name": "Token Metrics API Key"

    }

  ],

  "tool": [

    {

      "@type": "HowToTool",

      "name": "Google Apps Script"

    }

  ],

  "step": [

    {

      "@type": "HowToStep",

      "name": "Get Your API Key",

      "text": "Sign up at Token Metrics and generate your API key from the API dashboard."

    },

    {

      "@type": "HowToStep",

      "name": "Create a New Google Sheet",

      "text": "Open a new sheet and list crypto symbols in column A."

    },

    {

      "@type": "HowToStep",

      "name": "Add Apps Script",

      "text": "Go to Extensions > Apps Script and paste the provided code, replacing your API key."

    },

    {

      "@type": "HowToStep",

      "name": "Run the Script",

      "text": "Execute the getSheetData function to pull data into the sheet."

    }

  ]

}

✍️ Final Thoughts

If you're serious about crypto trading or app development, integrating live market signals into your workflow can be a game-changer. With the Token Metrics API, you can get institutional-grade AI signals — right inside Google Sheets.

This setup is simple, fast, and completely free to start. Try it today and unlock a smarter way to trade and build in crypto.

👉 Get Your API Key & Start for Free

Build Smarter Crypto Apps &
AI Agents in Minutes, Not Months
Real-time prices, trading signals, and on-chain insights all from one powerful API.
Grab a Free API Key
About Token Metrics
Token Metrics: AI-powered crypto research and ratings platform. We help investors make smarter decisions with unbiased Token Metrics Ratings, on-chain analytics, and editor-curated “Top 10” guides. Our platform distills thousands of data points into clear scores, trends, and alerts you can act on.
30 Employees
analysts, data scientists, and crypto engineers
Daily Briefings
concise market insights and “Top Picks”
Transparent & Compliant
Sponsored ≠ Ratings; research remains independent
Want Smarter Crypto Picks—Free?
See unbiased Token Metrics Ratings for BTC, ETH, and top alts.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
 No credit card | 1-click unsubscribe
Token Metrics Team
Token Metrics Team

Recent Posts

Research

SUI Price Analysis: Short-Term Momentum Builds Amid Long-Term Uncertainty

Token Metrics Team
4 min

SUI, a rising Layer 1 blockchain network, has been gaining traction recently—and Token Metrics' AI-powered tools were ahead of the curve in identifying its bullish momentum. On April 24th, the Token Metrics Trader Grade issued a bullish signal for SUI, and since then, the price has climbed nearly 22%, confirming the strength of the short-term trend.

But there’s more to this move than just price action. Token Metrics offers a unique perspective by analyzing both short-term and long-term signals through its proprietary Trader Grade and Investor Grade ratings. These grades offer a layered view of an asset's potential by using machine learning to evaluate over 80 on-chain, off-chain, and technical indicators.

Token Metrics AI: Bullish for Traders, Bearish for Investors

As of the latest data, SUI holds a “Strong Buy” rating on the Token Metrics Trader Grade, signaling powerful momentum for short-term traders. This suggests that swing traders and scalpers could benefit from the current trend, particularly if the price can decisively break through the immediate resistance at $4.25.

However, the Investor Grade tells a different story. While the short-term outlook is bullish, the long-term view remains cautious. The Investor Grade currently recommends a Sell, suggesting SUI may face challenges in sustaining gains over a multi-month time frame. This divergence highlights the importance of aligning your investment strategy with the appropriate time horizon.

TVL Growth Validates SUI’s Ecosystem Expansion

Beyond AI ratings, Token Metrics also factors in fundamental metrics—and one of the strongest tailwinds for SUI right now is its rapidly growing Total Value Locked (TVL). According to DeFi Llama, SUI’s TVL has surged to a new all-time high of $2.11 billion, cementing its position as the 8th largest blockchain by TVL.

This growth in TVL indicates that more capital is being deployed in the SUI ecosystem. It reflects increased user engagement with decentralized applications (dApps) on the network and signals rising confidence among DeFi participants. From a fundamental standpoint, this bodes well for SUI’s long-term utility—even if its price action hasn't yet caught up to the full extent of this growth.

Key Technical Levels: Breakout or Pullback?

From a technical analysis standpoint, SUI is now testing a major resistance at $4.25. A confirmed breakout above this level could send the asset surging toward new all-time highs, potentially igniting a new wave of momentum-driven buying.

However, if the price fails to breach this resistance zone, a pullback is likely. In that scenario, the $3.00 to $3.20 range should act as a solid support area. These levels will be critical for traders to monitor, and Token Metrics' real-time alerts can help users stay on top of such breakouts or reversals.

Trading Smarter with Token Metrics

Whether you're trading short-term breakouts or evaluating long-term positions, Token Metrics helps crypto investors make data-driven decisions. The platform’s dual-grade system—Trader Grade for momentum-based insights and Investor Grade for long-term trends—equips users with nuanced information to act with confidence.

Moreover, Token Metrics integrates this data directly into its AI Trading Agent and custom alerts system, ensuring you never miss an opportunity or warning signal. With instant access to heatmaps, technical breakdowns, and AI-based predictions, SUI traders can manage risk more efficiently and capitalize on emerging trends before the rest of the market catches on.

Final Thoughts

SUI is showing promising signs, especially with its network fundamentals improving rapidly and short-term momentum turning bullish. Still, the cautious long-term outlook suggests that traders should proceed with a balanced approach—watching both breakout levels and support zones, while leveraging tools like Token Metrics for real-time decision-making support.

As always, combining AI-driven insights with strong risk management is the key to navigating volatile markets like crypto. SUI is one to watch—and Token Metrics helps you stay one step ahead.

Announcements

AI Tokens and DeFi 2.0: Where Smart Capital is Flowing

Token Metrics Team
4 min

The crypto market is cyclical—not just in price, but in narrative. In recent months, attention has rotated from AI to DeFi, creating new opportunities for savvy investors. Let’s break down the trends.

AI Momentum Remains Strong

Projects like Vader AI, BitTensor, and Grass continue to dominate the conversation. Vader AI, part of the Virtua ecosystem, gained momentum from staking programs and Genesis Launchpad allocations. Grass, a data-layer AI protocol, claims $15M+ in revenue and recently flipped bullish on technical indicators.

BitTensor remains the leading infrastructure play in the AI space, drawing parallels to Bitcoin in its community enthusiasm and decentralization ethos. It has rebounded over 150% from its lows and is showing resilience in the current market cycle.

DeFi’s Comeback: Aerodrome and Beyond

Meanwhile, DeFi is showing signs of resurgence. Aerodrome, a DEX on the Base chain, is gaining traction through strong liquidity incentives and revenue-sharing mechanisms. Its user incentives echo the early days of Curve or Uniswap but on a chain optimized for scalability.

Virtua’s staking model is also driving a hybrid DeFi/AI strategy, blurring the lines between token utility, participation, and value capture.

Narrative Rotation: What It Means

Crypto narratives are rarely zero-sum. What we’re seeing now is a healthy diversification: AI remains dominant, but DeFi is catching a second wind. For investors, this means exploring tokens that sit at the intersection—offering strong tech, compelling incentives, and infrastructure integrations.

Closing Thoughts

Whether you’re riding the AI wave or positioning for the DeFi rebound, it’s clear that smart capital is flowing into ecosystems with tangible traction. Watch the flows, track the signals, and always be ready to pivot.

Track the Trends with Token Metrics

Token Metrics is your edge in navigating the ever-shifting landscape of crypto narratives. Our AI-powered research platform helps you spot bullish trends early, evaluate project fundamentals, and make data-driven investment decisions. Whether you're interested in AI tokens, DeFi protocols, or hybrid plays, Token Metrics provides real-time signals, technical grades, and curated indices to guide your next move.

Explore the platform at www.tokenmetrics.com and discover where smart capital is heading next.

Research

How Hyperliquid is Redefining Decentralized Perpetuals in 2025

Token Metrics Team
4 min

While most exchanges compete on liquidity or UI, Hyperliquid is rewriting the rules entirely.
This decentralized perps exchange has not only survived the bear market—it’s thriving. Backed by real revenue, a growing user base, and a unique listing model, Hyperliquid is emerging as the “Uniswap of Perps.”

The Reverse Auction Listing System

Hyperliquid introduces a novel reverse auction system for listing tokens. Bidders compete for tickers, with starting prices set at 2x the previous auction. Some tickers have fetched over $1 million, with the fees used for buybacks and burns—driving long-term value to the ecosystem.

This model isn’t just a gimmick. It introduces scarcity and gamification into token listings—something no other exchange is doing at this level.

Sustainable Revenue and Strong UX

Unlike many DEXs, Hyperliquid generates consistent trading fees, even in sideways markets. Its EVM-compatible L1 is coming soon, which could further cement it as the go-to perps exchange for serious traders.

Product-Market Fit in Action

In a space where hype often outpaces adoption, Hyperliquid offers both. It's not trying to be first—it's trying to be the best. The community listing process, upcoming L1, and high trading volumes all suggest it’s built for long-term relevance.

Smarter Trading with Token Metrics

To navigate emerging platforms like Hyperliquid, sophisticated analytics are key. Token Metrics provides a powerful suite of tools—AI-driven trading signals, token grades, on-chain data, and market indicators—to help traders make confident, data-backed decisions. Whether you're evaluating new token listings, monitoring market sentiment, or comparing DEX performance, Token Metrics equips you with everything you need to stay ahead of the curve.

Final Take

Hyperliquid is more than just another DEX—it’s a case study in how to build sustainable tokenomics and community alignment. If you’re looking for the next big infrastructure play in trading, don’t sleep on this one. And if you want to trade smarter, platforms like Token Metrics can be your secret weapon in decoding the market's next moves.

Choose from Platinum, Gold, and Silver packages
Reach with 25–30% open rates and 0.5–1% CTR
Craft your own custom ad—from banners to tailored copy
Perfect for Crypto Exchanges, SaaS Tools, DeFi, and AI Products