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

Moonshot Tokens in 2025: High-Risk, High-Reward Plays in the Crypto Market

Token Metrics Team
6 min

Introduction

The crypto market has always been fertile ground for high-risk, high-reward opportunities. While blue-chip assets like Bitcoin and Ethereum dominate headlines, the real thrill — and sometimes the highest returns — often comes from what the industry calls moonshots.”

These are small-cap tokens, often under $50 million in market cap, with explosive potential and equally high volatility. In 2025, moonshots remain a core part of speculative trading strategies. But what exactly are they? How do you find them? And most importantly, how can you manage the outsized risks they carry?

Let’s dive into the world of moonshots, drawing insights from recent market trends and real-world data.

What Are Moonshot Tokens?

Moonshot tokens are early-stage, low-cap cryptocurrencies that carry massive upside potential. They often represent experimental ideas or emerging narratives — think AI integration, meme culture, or social tokens — that haven’t yet been fully recognized by the broader market.

Because they trade at relatively low valuations, even small inflows of capital can cause outsized price swings. It’s not uncommon for a moonshot to deliver 10x or even 50x gains within a short time. But the flip side is brutal: these same tokens can plummet to zero just as quickly.

Key characteristics of moonshots:

  • Market cap: Typically under $50 million.
  • Narrative-driven: Often tied to strong trends like AI, gaming, or DeFi experiments.
  • Volatility: Sharp, frequent price swings.
  • Liquidity: Thin order books, making large trades difficult without impacting price.

Why Are Moonshots Gaining Traction in 2025?

The current market environment — with crypto market capitalization hovering around $4 trillion — has created room for risk-taking. Investors who missed early gains on Bitcoin or Ethereum are now searching for the next big thing, leading to renewed interest in small-cap tokens.

Emerging narratives also fuel the fire:

  • AI-Crypto Fusion: Projects like Sahara AI and Mobi AI are proving that the AI narrative isn’t slowing down.
  • Social Tokens & Web3 Platforms: Zora’s creator-focused token model demonstrates how social media and crypto can intersect.
  • Community-First DeFi: Protocols like Blackhole DEX show the power of grassroots tokenomics.

These narratives often spill over into the moonshot arena, as smaller projects attempt to replicate the success of these headline-grabbing platforms.

How to Identify Promising Moonshots

Identifying moonshots is part research, part intuition, and part risk tolerance. Here’s what to look for:

1. Strong Narrative Alignment

The most successful moonshots ride on current narratives. In this cycle, AI agents, decentralized social platforms, and community-owned DeFi projects are leading themes. Projects in these categories often experience rapid hype-driven adoption.

2. On-Chain Data

Tools like Dune Analytics and on-chain scanners can reveal whale accumulation, new liquidity pools, or spikes in active addresses — all early indicators of growing interest.

3. Tokenomics

Evaluate supply schedules:

  • How many tokens are in circulation?
  • Are there large unlocks coming soon?
  • Does the project have mechanisms like buybacks or burns to support price stability?

4. Developer & Investor Backing

While many moonshots are grassroots projects, strong teams or backing from reputable funds (e.g., Polychain, Binance Labs) can boost credibility.

Case Studies: Recent Moonshots to Watch

1. Vine (Meme Token):
A meme coin leveraging the Vine brand, this token has gained traction despite limited documentation. Its appeal lies largely in nostalgia and speculative hype.

2. Moby AI: What started as an AI-driven whale-tracking agent has evolved into Mobi Screener, a Dexscreener competitor with integrated social features. The token model ties platform usage to token value — a promising experiment in utility-driven moonshots.

3. Graphite Protocol:
Developers behind Bonk Fun (a leading meme token platform), Graphite has created a buyback and burn model linked to Bonk’s success, aligning token value directly with ecosystem growth.

4. CookieDAO:
Initially positioned as an AI agent platform, CookieDAO is now expanding into proof-of-belief systems, adding new utilities and campaign features for Web3 projects.

The Risk Side: Why Moonshots Can Go to Zero

Moonshots are inherently speculative. Common pitfalls include:

  • Team Abandonment or Rug Pulls: Some projects vanish overnight.
  • Unsustainable Hype: Many moonshots rely on short-term narratives that fade.
  • Low Liquidity: Thin markets make it difficult to enter or exit without significant slippage.

A recent example is SpaceMesh, once hyped as a “next Bitcoin.” Despite strong tech, internal disputes and poor execution led to a near-total collapse — a stark reminder that good code doesn’t always equal good investment.

Managing Risk: A Practical Approach

If you’re trading moonshots, risk management is everything.

1. Position Sizing:
Never allocate more than 1% of your portfolio to any single moonshot. Spreading capital across multiple small positions reduces the impact of one token collapsing.

2. Diversification:
Balance moonshots with higher-cap tokens to stabilize overall portfolio performance.

3. Predefined Exits:
Set clear take-profit and stop-loss levels before entering a trade. Emotional decisions often lead to losses.

4. Time Your Entries:
Consider entering after initial hype cools but before major announcements or roadmap milestones.

The Future of Moonshots: Are They Worth It?

While moonshots can be risky, they remain an integral part of crypto’s DNA. For many traders, they serve as lottery tickets in a market where early discovery can lead to life-changing gains.

In 2025, moonshots are evolving. They’re no longer just meme-driven gambles. Increasingly, they represent experimental innovation — blending DeFi models, AI integrations, and community governance in ways that push the boundaries of blockchain technology.

Conclusion

Moonshots are not for the faint-hearted. They require research, timing, and above all, discipline. In 2025, with themes like AI-driven platforms, decentralized social networks, and community-focused DeFi reshaping the market, the next breakout token could be hiding in plain sight.

Whether you’re a seasoned trader or a curious newcomer, understanding the dynamics of moonshots — and respecting their risks — is essential for navigating this volatile but potentially rewarding segment of crypto.

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.

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