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

Rise of AI Coins: How AI Narratives Are Fueling the Next Bull Run

Token Metrics Team
4 min

Introduction
AI is no longer just a tech buzzword — it’s a dominant force driving the next wave of crypto innovation. In 2025, artificial intelligence has found a new frontier: blockchain. From infrastructure protocols to AI-native tokens, the market is seeing a surge in interest, investment, and returns for coins tied to the AI narrative. Token Metrics is at the forefront, helping users identify these explosive opportunities.

Why AI Coins Are Surging
The intersection of AI and crypto isn’t random. Three forces are converging to power this narrative:

  1. Mainstream AI Adoption – With tools like ChatGPT and Claude going mainstream, interest in AI has exploded.
  2. Decentralized Intelligence – Blockchain offers a secure, transparent way to distribute AI models and datasets.
  3. Speculative Momentum – The hype around AI is creating high-risk, high-reward token launches with strong upside potential.

Token Metrics’ AI Token Detection Strategy
Token Metrics uses its proprietary AI to identify early momentum in the market. Here's how it helped surface the best-performing AI tokens:

  • Volume spikes and unusual trading patterns
  • Token grades showing >80 Trader Score
  • Bold signals based on narrative tracking
  • Cross-chain analysis for upcoming projects

Ian Balina noted during the recent webinar that several AI coins have already delivered outsized returns — and this is just the beginning.

Examples of AI Tokens to Watch

  • Launch Coin – While not an AI token itself, its virality shows how fast narratives spread.
  • AI Infrastructure Projects – Platforms building decentralized compute for training and deploying models.
  • AI DeFi Hybrids – Tokens merging machine learning with trading, risk management, or yield optimization.

How to Ride the AI Wave
Using the Token Metrics platform, here’s how to position your portfolio:

  • Use Bold Signals: Sort by AI narrative to find breakout projects.
  • Set Alerts: Monitor new signal generation across top AI narratives.
  • Filter by Grade: Combine high Trader Grade with AI tag for high-conviction trades.

What This Means for Investors
The AI narrative is not a flash in the pan. It represents a paradigm shift in both technology and finance. Tokens that combine utility, vision, and timing will thrive. As always, early entry is key — and that’s where Token Metrics’ daily insights give users the edge.

Conclusion
AI tokens are fueling the next crypto bull run — and the smartest investors are already positioned. With real-time signals, narrative filters, and AI-powered grading, Token Metrics is your map through the chaos. The next big opportunity may already be on the Market Page.

Research

📈 Launch Coin’s Wild Ride: From 54 SOL to $4 Million

Token Metrics Team
4 min

The crypto world thrives on narratives, and few have captured attention in recent weeks like Launchcoin. Born from a blend of SocialFi innovation and meme-driven virality, Launchcoin has surged into the spotlight—offering both eye-popping returns and warnings of extreme volatility. Powered by Token Metrics’ AI insights, here’s a detailed look at where Launchcoin stands today.

🚀 AI Detected the Breakout Early

On April 20, 2025, Token Metrics’ proprietary AI model flipped bullish on Launchcoin. Since then, the token has rallied over 3x, proving the strength of the signal. Backed by machine learning models that track on-chain data, sentiment, and price action across multiple timeframes, the Trader Grade for Launchcoin is currently at a whopping 93.15%, designating it a Strong Buy in the short term.

However, after such an exponential surge, the platform’s analysts expect natural pullbacks as early buyers and whales begin to take profits. These corrections are healthy and expected in any meteoric price run—and should not be confused with a loss of fundamental strength.

🧠 Token Metrics Investor Grade: A Balanced Perspective

While short-term indicators are overwhelmingly bullish, the Investor Grade remains neutral, pointing to a more measured view on Launchcoin’s long-term potential. This signals that while there’s momentum, there are still structural risks—particularly due to its meme coin characteristics and reliance on hype cycles.

Still, a neutral long-term grade isn’t bearish. It suggests Launchcoin is currently stable at its elevated valuation, but investors should monitor developments carefully—especially as new features and ecosystem growth unfold.

📈 Launchcoin’s Wild Ride: From 54 SOL to $4 Million

The Launchcoin story has already minted millionaires. One trader reportedly turned an $8,191 investment (54 SOL) into $4 million after purchasing 14.62 million LAUNCHCOIN tokens when the market cap was below $500,000. This kind of exponential return is rare—even in crypto—and helped drive speculative interest across social media and trading forums.

Within just 22 days, Launchcoin’s market cap crossed $300 million, illustrating how quickly meme-based projects can capture market momentum, especially when they ride the wave of a compelling narrative.

🔄 Listings and Market Access

Launchcoin’s liquidity and accessibility have improved significantly. The token is now trading on major centralized exchanges:

  • Spot listings: Bitget, KuCoin, Gate.io, and MEXC
  • Futures: Recently launched on ByBit

These listings have broadened exposure, attracting a wider investor base and allowing leveraged traders to participate. Increased liquidity also reduces slippage, enabling larger capital inflows while minimizing execution risk.

🎭 From PASTERNAK to LAUNCHCOIN: The Rebranding

Initially launched as PASTERNAK, named after Believe’s founder Ben Pasternak, the project was rebranded to Launchcoin on May 2, 2025. The new name better reflects its core value proposition: empowering creators to launch tokens through a SocialFi model.

The model is simple but revolutionary—anyone can create a token by posting on social media with the “@launchcoin” tag. This lowers the barrier for entry into token creation and adds viral potential to every social interaction.

🧨 Risk and Volatility: A Speculative Bet

Despite its recent success, Launchcoin remains a highly speculative asset. Its meteoric rise is reminiscent of meme coin cycles seen with tokens like PEPE or DOGE. While Launchcoin offers a unique utility layer with its token-creation feature, its current valuation includes a significant hype premium.

Token Metrics encourages traders to stay nimble. With the AI trading signals, users can track grade changes in real-time, ensuring they’re not caught off guard by sharp reversals or cooldowns.

🧠 Final Thoughts

Launchcoin represents a blend of viral marketing, social token innovation, and AI-predicted trading opportunity. With strong short-term momentum, neutral long-term positioning, and significant ecosystem buzz, it’s a token to watch—but not without caution.

Whether you’re a trader riding the momentum or an investor assessing long-term viability, Token Metrics provides the data-driven edge to navigate Launchcoin’s volatility with confidence.

Research

Best Long-Term Crypto Picks for the 2025 Bull Market

Token Metrics Team
4 min

In a market full of noise, value investors are asking one critical question: what should I hold long-term?

Here are some of our top picks, based on fundamentals, traction, and longevity.

1. Grass – AI + Revenue

Grass stands out in the AI space. With over $15M in revenue from its browser extension and data resale model, it’s one of the few protocols generating real-world value. It’s a top AI blue chip we’re confident holding over multiple cycles.

2. Peaq – DePIN Infrastructure

Peaq positions itself as the Chainlink of decentralized physical infrastructure. While still under $1B FDV, it’s been consistent in development and narrative strength.

3. Sui – Consumer-Focused L1

Sui isn’t just another L1. Between Phantom wallet support, SuiPlay hardware, and growing dApp adoption, Sui has the elements to outpace older chains like Solana or Avalanche in user growth.

4. Parcl – Real Estate Derivatives

For exposure to real-world assets, Parcl offers a compelling play. Their UI is retail-friendly, listings are strong, and the market cap remains under $150M. This is one to watch as RWA adoption grows.

5. BitTensor – AI Infrastructure Layer

With a unique emission model and growing subnet usage, BitTensor remains the top AI infra token. Some even compare its long-term potential to early Bitcoin.

Bonus Mentions:

  • Uniswap / Aave / Compound – battle-tested DeFi with upcoming fee-sharing upgrades

  • Chainlink – oracle king still dominating infrastructure

  • Hyperliquid – sustainable revenue, EVM chain, and perps dominance

Final Words

The 2025 bull market will create noise—but also opportunity. These tokens aren’t just trendy—they’re infrastructure plays with real utility and upside. Allocate accordingly.

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