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
30 Employees
analysts, data scientists, and crypto engineers
30 Employees
analysts, data scientists, and crypto engineers
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

DeFi and AI Tokens Dominate as Crypto Market Nears $4 Trillion

Token Metrics Team
6 min

The cryptocurrency market continues to show resilience, with total market capitalization maintaining a strong foothold near $4 trillion. While Bitcoin remains the cornerstone of this cycle, the spotlight is shifting toward altcoins — especially those at the forefront of decentralized finance (DeFi) and artificial intelligence (AI) integration.

In this blog, we’ll explore the top narratives shaping today’s market, focusing on DeFi protocols like Blackhole DEX and PancakeSwap, alongside emerging AI projects such as Sahara AI and Moby AI.

Why DeFi Is Surging Again

DeFi has staged an impressive comeback in 2025. After a period of stagnation, several protocols have redefined their models to prioritize community engagement and sustainable growth.

Black Hole DEX:
Launched on Avalanche, Blackhole DEX has quickly become the network’s largest decentralized exchange, overtaking Trader Joe. The platform uses a community-first approach: no team allocation, weekly token emissions to liquidity providers, and a bribe-based voting mechanism for rewards distribution.

Impact:
This design has created a powerful flywheel effect. As token prices rise, APYs increase, attracting more liquidity, which in turn boosts trading volume and revenue. Within days, Blackhole DEX grew its TVL from $7 million to $193 million — a staggering feat.

PancakeSwap: A Sleeping Giant?

PancakeSwap, the dominant DEX on Binance Smart Chain (BSC), has been quietly outperforming its competitors in trading volumes and fee generation. Recent data shows PancakeSwap generating more than 4x the daily fees of Uniswap, yet its fully diluted valuation remains significantly lower.

Growth Catalysts:

  • Integration with the Binance Wallet ecosystem.
  • Expansion into other ecosystems like Solana.
  • All-time-high trading volumes despite broader market corrections.

For investors seeking a large-cap DeFi protocol with strong fundamentals and potential upside, PancakeSwap’s metrics warrant attention.

AI Meets Crypto: The Next Frontier

Artificial intelligence continues to transform multiple industries, and crypto is no exception.

Sahara AI:
Sahara AI is building a full-stack AI infrastructure for decentralized applications. Backed by heavyweights like Binance and Polychain, its mission is to bridge Web3 and AI — a theme that’s likely to dominate innovation cycles in the coming years.

Moby AI:
Initially launched as an AI trading agent, Moby AI has expanded into building tools like Moby Screener, a competitor to Dexscreener. Its unique tokenomics link user engagement directly to the platform’s utility, making it an experiment worth watching.

The Broader Altcoin Landscape

Beyond DeFi and AI, other notable projects are also gaining ground:

  • Graphite Protocol: The developer behind LetsBonk.Fun, sharing revenue with its ecosystem tokens through buyback strategies.

‍

  • Zora: A social media-meets-crypto platform allowing creators to monetize their content directly on-chain.

‍

  • Project X: A cross-chain DEX on Hyperliquid, amassing $28 million in TVL within 24 hours of launch.

These projects underscore the diversity of innovation happening outside Bitcoin’s shadow.

Risk Management in a Volatile Market

The excitement around DeFi and AI tokens comes with elevated risk. Here are some best practices:

  • Allocate wisely: Keep high-risk allocations (like low-cap “moonshots”) small — no more than 1% per trade.
  • Monitor narratives: Rapid shifts in market sentiment can create both opportunities and pitfalls.
  • Stay updated: Protocol changes, tokenomics adjustments, and ecosystem partnerships can significantly impact valuations.

Conclusion

As the crypto market edges closer to $4 trillion, the narratives driving growth are evolving. DeFi is proving its staying power with innovative models like Black Hole DEX, while AI-focused projects like Sahara AI are pushing the boundaries of what blockchain can achieve.

For market participants, the challenge lies in identifying which of these trends have lasting potential — and positioning themselves accordingly.

Research

Altcoins on the Rise: How Bitcoin’s Stability Is Fueling the Next Market Wave

Token Metrics Team
6 min

As Bitcoin stabilizes near its recent highs, the crypto market is witnessing a familiar pattern — altcoins are beginning to surge. While Bitcoin often leads during the early phases of a bullish cycle, history shows that capital tends to flow into altcoins as confidence builds. In the past two weeks, this transition has become increasingly evident, with several promising projects capturing significant market attention.

Bitcoin’s Stabilization and What It Means

Since early July, Bitcoin has managed to hold above key resistance levels, cementing its role as the market’s anchor. At the time of writing, total crypto market capitalization hovers near $4 trillion — a level that hasn’t been seen since the previous cycle’s peaks. Historically, when Bitcoin consolidates above its former highs, capital begins rotating into altcoins. This shift often marks the start of a broader rally across the market.

Key takeaway: The current market appears to be in the early stages of this altcoin rotation.

Altcoins Leading the Charge

Several altcoins have emerged as strong contenders in recent weeks.

1. Zora: The Social Token Platform
Zora, an on-chain social platform that allows creators to tokenize posts and earn from their content, has seen exponential growth following its integration into the Base App (Coinbase’s rebranded wallet). Creator activity and transaction volumes have surged, driving up demand for the Zora token. With each creator post paired to the Zora token, this integration has created a direct link between platform usage and token utility.

Why it matters: The combination of Web3 social media and creator monetization is a powerful narrative, and Zora appears well-positioned to capitalize on this trend.

2. Spark: A MakerDAO-Connected Lending Platform
Spark, a DeFi lending protocol linked to Sky Protocol, has also been a standout performer. It recently experienced a sharp increase in liquidity and price action, fueled by its integration with CookieDAO’s campaign and ongoing airdrop programs.

Why it matters: With DeFi gaining renewed interest, protocols offering sustainable yields through established ecosystems like Sky Protocol (formerly MakerDAO) are likely to remain attractive to both retail and institutional participants.

3. Sahara AI: Building the AI-Crypto Intersection
Sahara AI has positioned itself at the intersection of AI and blockchain. Backed by Binance, Polychain, and Foresight Ventures, this project offers a full-stack AI solution tailored for decentralized applications. Its long-term vision of creating AI-enabled Web3 services is attracting both developers and investors.

Why it matters: AI and crypto remain two of the most dominant narratives in tech, and projects combining these sectors could drive the next wave of innovation.

4. PancakeSwap: Undervalued Giant?
Despite being one of the largest DEXs by trading volume and daily fee generation, PancakeSwap appears significantly undervalued compared to peers like Uniswap. The platform recently expanded its operations to other chains, including Solana, and benefits from strong integration with the Binance Wallet ecosystem.

Why it matters: Fundamentals suggest PancakeSwap has room for growth if the market re-rates its value relative to competitors.

Market Themes to Watch

Bitcoin vs. Altcoin Season:
Our analysis shows we are still in a Bitcoin-dominant phase. Historically, altcoins outperform when Bitcoin consolidates or cools off. This implies that the current rotation into altcoins could continue as capital flows down the risk curve.

DeFi Revival:
Protocols like Blackhole DEX on Avalanche — which has grown its TVL from $7 million to $193 million in less than 2 weeks — highlight a renewed interest in decentralized finance. Unlike VC-backed models, Blackhole’s community-first tokenomics have resonated with users seeking fairer distribution.

Social Tokens & AI Integration:
Platforms like Zora and Sahara AI are tapping into major growth narratives: decentralized social media and artificial intelligence. Both sectors are likely to see continued experimentation and adoption.

Managing Risk in Altcoin Investing

While the upside potential in altcoins is high, so is the volatility. For high-risk trades, such as “moonshots” (low-cap tokens under $50 million market cap), we recommend:

  • Position sizing: Limit exposure to 1% per trade.
  • Diversification: Spread investments across multiple projects to reduce single-token risk.
  • Exit planning: Pre-define take-profit and stop-loss levels.

Conclusion

The crypto market is entering an exciting phase. Bitcoin’s consolidation above key levels suggests a healthy backdrop for risk assets, and altcoins are beginning to benefit. From creator monetization platforms like Zora to cross-chain DeFi protocols like Spark and Black Hole, this new wave of projects represents the diversity and innovation driving the next cycle.

As always, measured participation and disciplined risk management remain essential.

Crypto Basics

Types of Stablecoins: A Complete Guide for 2025

Token Metrics Team
8 min

The cryptocurrency market is famous for volatility—Bitcoin can swing by thousands of dollars in a day, and altcoins can rise or crash in hours. But what if you need price stability? That’s where stablecoins come in.

Stablecoins are digital currencies pegged to stable assets like the US dollar, gold, or even algorithmically maintained price levels. They bridge the gap between the speed and efficiency of blockchain technology and the reliability of traditional money.

As of 2025, stablecoins account for over $140 billion in circulating supply, making them essential for traders, investors, and decentralized finance (DeFi) users. But not all stablecoins are the same—different types use different mechanisms to maintain their stability, each with unique pros and cons.

In this guide, we’ll break down the types of stablecoins, how they work, their risks, and which might be best for your needs.

What Are Stablecoins?

A stablecoin is a cryptocurrency designed to maintain a stable value by pegging its price to a reference asset. Most stablecoins are pegged to fiat currencies like the U.S. dollar (e.g., 1 USDT ≈ $1), but some track commodities (like gold) or are algorithmically balanced to hold value.

They are widely used for:

  • Trading: Moving quickly in and out of volatile assets.
  • DeFi: Providing liquidity, borrowing, and earning yields.
  • Remittances: Sending low-cost, fast cross-border payments.
  • Hedging: Protecting against crypto market volatility.

Types of Stablecoins

There are four main types of stablecoins:

  1. Fiat‑Collateralized Stablecoins
  2. Crypto‑Collateralized Stablecoins
  3. Algorithmic (Non‑Collateralized) Stablecoins
  4. Commodity‑Backed Stablecoins

Each has a different method of maintaining its peg. Let’s break them down.

1. Fiat‑Collateralized Stablecoins

Definition:
These are backed 1:1 by traditional currencies like the U.S. dollar, euro, or yen. For every stablecoin issued, an equivalent amount of fiat is held in reserve by a trusted custodian.

How They Work:
If you buy 1 USDC, Circle (its issuer) holds $1 in a regulated bank account or short-term U.S. Treasury securities. When you redeem that stablecoin, the issuer sends you the equivalent amount in fiat and burns the coin.

Examples:

  • Tether (USDT) – Largest stablecoin by market cap; widely used on exchanges.
  • USD Coin (USDC) – Issued by Circle, fully regulated and audited.
  • TrueUSD (TUSD) – Offers real-time attestation of reserves.
  • PayPal USD (PYUSD) – Launched by PayPal for payments and DeFi.

Pros:

  • High stability – Pegged directly to fiat.
  • Transparent – Many provide audits and attestations.
  • Easy adoption – Ideal for traders, merchants, and payment platforms.

Cons:

  • Centralization – Custodians control reserves and can freeze accounts.
  • Regulatory risks – Subject to government oversight.
  • Less transparency for some issuers – (e.g., Tether faced scrutiny over its reserves).

2. Crypto‑Collateralized Stablecoins

Definition:
These are backed by cryptocurrencies like Ethereum or Bitcoin instead of fiat. Because crypto is volatile, these stablecoins are overcollateralized (e.g., $150 in ETH backs $100 in stablecoins).

How They Work:
When you mint a crypto-backed stablecoin like DAI, you deposit collateral (e.g., ETH) into a smart contract. If the collateral value drops too much, the contract automatically liquidates some assets to maintain the peg.

Examples:

  • DAI – Issued by MakerDAO, backed by ETH, USDC, and other assets.

‍

  • sUSD – A synthetic USD issued by Synthetix.
  • MIM (Magic Internet Money) – Collateralized by multiple crypto assets.

Pros:

  • Decentralized – No single company controls reserves.
  • Transparent – All collateral balances are viewable on-chain.
  • Resistant to censorship – Issuers can’t freeze accounts.

Cons:

  • Volatility risk – Collateral can lose value quickly, requiring liquidations.
  • Overcollateralization – Ties up more capital than fiat-backed options.
  • Complexity – Requires understanding of DeFi mechanics.

3. Algorithmic (Non‑Collateralized) Stablecoins

Definition:
These don’t use physical reserves. Instead, they maintain their peg via algorithmic supply adjustments—minting or burning tokens to balance price around $1.

How They Work:
If demand increases and the price rises above $1, the protocol mints more coins. If it falls below $1, the protocol burns coins or incentivizes users to buy them back.

Examples:

  • Ampleforth (AMPL) – Elastic supply adjusts daily.
  • UST (TerraUSD) – Infamously collapsed in 2022 after its peg broke.
  • Frax (FRAX) – Uses a hybrid model: partly collateralized, partly algorithmic.

Pros:

  • Highly capital-efficient – Doesn’t require large reserves.
  • Decentralized – Often governed by smart contracts and DAOs.

Cons:

  • Peg instability – Prone to “death spirals” when market confidence drops.
  • Complex mechanisms – Harder for average users to understand.
  • History of failures – UST/LUNA crash eroded trust in algorithmic coins.

4. Commodity‑Backed Stablecoins

Definition:
These stablecoins are pegged to commodities like gold, silver, or oil, giving them intrinsic value beyond fiat.

How They Work:
For every coin issued, an equivalent amount of the commodity is held in a secure vault. For example, owning 1 PAX Gold (PAXG) means you own 1 troy ounce of physical gold stored by the issuer.

Examples:

  • PAX Gold (PAXG) – Backed by physical gold.

‍

  • Tether Gold (XAUT) – Gold-backed token from Tether.
  • Digix Gold (DGX) – Pegged to gold bars in Singapore vaults.

Pros:

  • Hedge against inflation – Commodities like gold retain value during economic uncertainty.
  • Diversification – Offers exposure to both crypto and commodities.

Cons:

  • Low liquidity – Less widely used than fiat-backed stablecoins.
  • Storage & audit challenges – Requires trust in the issuer to maintain reserves.

Why Do Stablecoins Matter?

Stablecoins are the backbone of DeFi and crypto trading.

  • Trading & arbitrage: They provide a quick way to exit volatile positions without converting back to fiat.
  • Cross-border payments: Cheaper and faster than SWIFT or remittance services.
  • DeFi participation: Essential for lending, borrowing, yield farming, and liquidity pools.
  • On-ramp/off-ramp: They simplify converting between traditional finance and blockchain.

Which Type of Stablecoin Should You Use?

If you want simplicity & security: Go with fiat-backed coins like USDC or PYUSD.

If you value decentralization: Choose crypto-collateralized options like DAI.

If you’re comfortable with high risk: Explore algorithmic models like FRAX (but beware of peg risks).

If you want inflation protection: Consider commodity-backed coins like PAXG.

Key Risks of Stablecoins

  • Regulation: Governments are increasing oversight of fiat-backed coins.
  • Centralization: Some issuers can freeze funds or blacklist wallets.
  • Smart contract risks: DeFi-based stablecoins can suffer from bugs or exploits.
  • Peg breaks: Algorithmic models are especially vulnerable to confidence loss.

The Future of Stablecoins

In 2025, stablecoins are evolving to meet regulatory and market demands:

  • Central Bank Digital Currencies (CBDCs): Governments are issuing digital dollars and euros, potentially competing with stablecoins.
  • Regulated issuers: Projects like USDC are working closely with regulators to ensure compliance.
  • Hybrid models: Combining fiat and algorithmic elements (e.g., Frax) to enhance stability.

As DeFi expands and global adoption grows, stablecoins will remain at the heart of crypto finance.

Final Thoughts

Stablecoins are more than just “digital dollars.” They’re a critical bridge between traditional finance and blockchain innovation.

  • Fiat-backed stablecoins bring stability and ease of use.
  • Crypto-collateralized ones offer transparency and decentralization.
  • Algorithmic models push innovation but carry higher risks.
  • Commodity-backed coins provide a hedge against inflation and diversify exposure.

Choosing the right type depends on your risk tolerance, use case, and trust level. Whether for trading, saving, or participating in DeFi, understanding the types of stablecoins can help you navigate the crypto ecosystem with confidence.

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