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

Announcements

Inside the Dashboard: How to Monitor API Key Activity and Monthly Usage in Real Time

Token Metrics Team
5 min

The power of any great API isn’t just in the data it provides — it’s also in the control, visibility, and accountability it gives developers. That’s why the Token Metrics API Dashboard is more than just a place to generate keys — it’s your real-time command center for monitoring API key usage, managing access, and optimizing performance.

In this article, we’ll explore how to use the Token Metrics API Dashboard to stay in control of your app’s data usage, track request history, and ensure your integrations remain secure and efficient.

📍 Where to Find It

To access the dashboard:

  1. Log in to your Token Metrics account.
  2. Go to: https://app.tokenmetrics.com/en/api
  3. Navigate to the API Keys and API Usage sections.

🔐 View and Manage API Keys

The API Keys section gives you a complete overview of every active key associated with your account. For each key, you’ll see:

  • Key Name: Descriptive labels like "Bot A" or "Staging Server"
  • Created Date: When the key was generated
  • Last Used: Timestamp of the most recent request
  • Status: Active or inactive toggle
  • Actions: Trash icon to instantly delete a key

💡 Why It Matters:

  • Spot unused or stale keys that may pose a security risk
  • Instantly disable or delete a key if it’s compromised
  • Monitor which app or environment is making the most requests

📊 Monitor API Usage in Real-Time

In the Usage Dashboard, Token Metrics gives you deep insights into how your API credits are being used.

Key metrics include:

  • API Calls Graph
    A daily call volume chart so you can identify peaks in usage, anomalies, or unexpected surges.

  • Total Monthly API Calls
    Example:
    8,750 / 20,000
    See how much of your monthly quota you’ve used — and when it resets.

  • Remaining API Credits
    Know exactly how many calls you have left in your current cycle.

  • API Call Statistics Table
    Each row includes:

    • Endpoint accessed (e.g., /trader-grade)
    • Timestamp of the request
    • Status code (200 = success, 401 = unauthorized, etc.)
    • Originating IP address
    • Success/failure response

🔄 Debugging & Insights Made Easy

This dashboard doesn’t just monitor—it helps you debug and optimize.

  • Quickly identify if your integration is repeatedly hitting 400 or 403 errors
  • Check whether a specific key is being overused or underused
  • Pinpoint spikes in usage that may indicate unauthorized access
  • See which endpoints are called most often — and consider caching results

⚠️ Avoid Rate Limit Surprises

If you’re on a Basic or Advanced plan, you’ll have a rate limit (e.g., 1 req/min for free users, up to 600 req/min for VIPs). The dashboard helps ensure you stay within your limits — and scale appropriately when needed.

🚀 Build Better with Transparency

In a production environment, visibility into API activity is critical. With Token Metrics, you’re never flying blind. You always know:

  • Which app is using which key
  • How many credits you’re using
  • When to optimize or upgrade

From security to scaling, the Token Metrics API Dashboard gives you the insight you need to build with clarity and control.

👉 Launch Your API Dashboard Now → tokenmetrics.com/api

Research

Is the Crypto Market Bullish or Bearish? Why 2025 Is the Year of Neutral Momentum

Token Metrics Team
3 min

The crypto market isn't clearly bullish or bearish in mid-2025 — it's neutral. This article explores why this 'in-between' momentum could signal a maturing market cycle, and what investors should watch for as signals normalize after a sharp $1T rebound in total market cap.

As we navigate through the midpoint of 2025, one question dominates trading desks and Telegram groups alike: Is the crypto market bullish or bearish? Surprisingly, the answer might be neither. Current indicators suggest that we are in a neutral zone — an ambiguous space where the market is no longer surging with euphoric gains but isn’t plunging into panic either.

From January through mid-May, the total crypto market cap has grown from $1 trillion to $2 trillion. This swift rebound signals recovery, but not full-blown optimism. Instead, many analysts — ourselves included — interpret this as a healthy correction and stabilization following intense early-year volatility.

This kind of environment often marks the early stages of a maturing cycle. Unlike the sharp swings we saw in previous bull and bear markets, 2025’s trend suggests more measured growth, driven by fundamentals rather than hype. In other words, the market might finally be learning from its past.

That doesn’t mean the space lacks activity. Sectors like DeFi lending and AI-related tokens continue to gain traction, with significant TVL inflows. Retail interest in meme coins also remains high in select regions. But overall, what we’re seeing is consolidation — not chaos.

In this neutral setting, strategy matters more than sentiment. It's no longer about jumping into trending narratives or panic-selling on dips. Instead, identifying projects with real use cases, sustainable economics, and strong communities has become the foundation of long-term success.

For traders and builders alike, the current landscape offers both challenges and opportunities. Risk-adjusted returns are key, and disciplined portfolio rebalancing could be one of the most underrated strategies right now.

As we continue monitoring market signals, we remain committed to surfacing actionable insights backed by real-time data, not just narratives. Whether the next breakout is weeks or months away, staying informed — and unemotional — may prove to be your best edge.

How Token Metrics Helps in a Neutral Market Environment:

In times of neutral momentum, making profitable crypto decisions becomes more complex — and that's where Token Metrics shines:

  1. Actionable AI Signals:
    Token Metrics scans thousands of tokens daily, using over 80 data points to identify bullish and bearish trends even when market sentiment is flat. This helps users cut through noise and act on real opportunities.
  2. Investor & Trader Grades:
    When hype fades, fundamentals matter. Our proprietary grades evaluate both short-term momentum and long-term viability, helping users discover tokens with staying power — not just temporary pumps.
  3. Smart Rebalancing Alerts:
    In a consolidating market, maintaining the right portfolio mix is crucial. Token Metrics' indices and alerts help users rebalance regularly to lock in gains and minimize downside risks.
  4. Sector-Based Insights:
    With DeFi, AI, and meme coins behaving differently, Token Metrics allows users to dive deep into sector-specific analytics — so you can position ahead of capital flows.
  5. Sentiment & Volume Monitoring:
    Our platform tracks shifts in on-chain activity, social sentiment, and volume trends to spot early signs of market reversals — especially useful when traditional signals stall.

In a market where being early beats being emotional, Token Metrics equips you with the clarity and tools to trade with confidence.

Announcements

🚀 Announcing the Launch of the Token Metrics API & SDK — Powered by $TMAI

Token Metrics Team
5 min

Introducing the Token Metrics API: Power Your Crypto Tools with AI-Driven Intelligence

We’re thrilled to announce one of our most important product launches to date: the Token Metrics API is now live.

This powerful crypto API gives developers, quant traders, and crypto startups direct access to the core AI infrastructure that powers the Token Metrics platform. Whether you’re building trading agents, investor dashboards, research tools, or mobile apps, our API and SDKs provide everything you need to build with real-time crypto data and intelligence—right out of the box.

For the first time, you can plug into the same AI API that drives our ratings, signals, and predictions—and embed it directly into your products, tools, or internal systems.

🔍 What’s Inside the Token Metrics API?

Our crypto API is designed to give you high-performance access to the exact data models we use in-house:

✅ AI Trading Signals

Access bullish and bearish calls across thousands of tokens. These API endpoints are powered by machine learning models trained on historical price action, sentiment data, and blockchain activity.

✅ Investor & Trader Grades

Through our API, you can pull dynamic 0–100 grades on any token. Designed for long-term or short-term views, these scores factor in volatility, momentum, market cap trends, and our proprietary AI predictions.

✅ AI Reports & Conversation Crypto Agent

Query the API to generate custom reports and insights using our smart crypto assistant. Analyze market trends, token health, and investment opportunities—without writing your own models.

✅ Token Performance Data

Retrieve token-level analytics like ROI, predictive volatility, and asset rankings. Perfect for powering dashboards, investor tools, or internal models.

✅ Market Sentiment Models

Use the API to access our AI-modeled sentiment engine, built from social media, news data, and trend signals—ideal for gauging crowd psychology.

All Token Metrics API endpoints are RESTful, fast, and easy to integrate. SDKs for Python, Node.js, and other environments help developers onboard quickly.

🛠️ What You Can Build With the Token Metrics API

Our users are already building next-gen tools and automation using the Token Metrics API:

  • 🤖 CEX Trading Agents — Automate entries and exits with real-time signals and token grades
  • ⛓️ DEX Arbitrage Engines — Scan price differences across DeFi and act instantly
  • 📊 Analytics Dashboards — Build data-driven tools with predictive metrics and visualizations
  • 💬 Alert Bots for Telegram & Discord — Deliver actionable alerts using our signal API
  • 📱 Web & Mobile Crypto Apps — Enhance portfolios and research apps with AI intelligence

With just a few lines of code and an API key, you can turn static crypto apps into dynamic, intelligent systems.

💸 Affordable Pricing & $TMAI Utility

We’ve designed our crypto API pricing to be flexible and accessible:

  • Plans start at $99/month, with high usage limits
  • Save up to 35% when you pay with our native token, $TMAI
  • All tiers include access to powerful AI tools and real-time crypto data

Whether you're a solo dev or scaling a trading startup, there’s a plan built for you. Paying with $TMAI also deepens your utility in the Token Metrics ecosystem—this is just the beginning of native token perks.

🧪 Try the Token Metrics API for Free

Not ready to commit? Try our free API tier with:

  • Limited endpoints to explore
  • Access to live documentation and test queries
  • Sample code and SDKs for instant implementation

Start exploring at tokenmetrics.com/api

🌐 Why We Built This Crypto API

Token Metrics has always been focused on empowering smarter investing. But as the market evolves, we believe the future lies in infrastructure, automation, and open access.

That’s why we built the Token Metrics API—to give developers access to the exact AI systems we use ourselves. Our models have been fine-tuned over years, and now, that same intelligence can power your platform, tools, or trading agents.

Whether you're building research platforms, signal-based apps, or automated execution tools—this API is your edge.

⚡ Start Building with Token Metrics API for FREE→ tokenmetrics.com/api

The crypto market never sleeps—and with the Token Metrics API, neither do your tools.

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