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

Fundamental Grade Crypto API: Real Crypto Fundamentals in One Score

Token Metrics Team
3

Most traders chase price action; Fundamental Grade Crypto API helps you see the business behind the token—community traction, tokenomics design, exchange presence, VC signals, and DeFi health—consolidated into one score you can query in code. In a few minutes, you’ll fetch Fundamental Grade, render it in your product, and ship a due-diligence UX that drives trust. Start by grabbing your key at the Get API Key page, Run Hello-TM to verify your first call, then Clone a Template to go live fast.

What You’ll Build in 2 Minutes

A minimal script to fetch Fundamental Grade from /v2/fundamental-grade for any symbol (e.g., BTC).

  • Optional curl to smoke-test your key in seconds.
  • A drop-in pattern to display the grade + key drivers in dashboards, screeners, and research tools.

Endpoints to consider next

  • /v2/tm-grade (technical/sentiment/momentum)
  • /v2/price-prediction (scenario planning)
  • /v2/resistance-support (risk levels)
  • /v2/quantmetrics (risk/return stats)

Why This Matters

Beyond price, toward quality. Markets are noisy—hype rises and fades. Fundamental Grade consolidates hard-to-track signals (community growth, token distribution, liquidity venues, investor quality, DeFi integrations) into a clear, comparable score. You get a fast “is this worth time and capital?” answer for screening, allocation, and monitoring.

Build trust into your product. Whether you run an investor terminal, exchange research tab, or a portfolio tool, Token Metrics discovery helps users justify positions. Pair it with TM Grade or Quantmetrics for a balanced picture: what to buy (fundamentals) and when to act (signals/levels).

Where to Find

The Fundamental Grade is easily accessible in the top right of the API Reference. Grab the cURL request for seamless access!

Ready to build?

  • Get API Key — generate a key and start free.
  • Run Hello-TM — verify your first successful call.
  • Clone a Template — deploy a screener or token page today.

Watch the demo: VIDEO_URL_HERE. Compare plans: Scale confidently with API plans.

FAQs

1) What does the Fundamental Grade API return?

A JSON payload with the overall score/grade plus component scores (e.g., community, tokenomics, exchange presence, VC backing, DeFi health) and timestamps. Use the overall grade for ranking and component scores for explanations.

2) How fast is the endpoint? Do you publish SLOs?

The API is engineered for predictable latency. For high-traffic dashboards, add short-TTL caching and batch requests; for alerts, use jobs/webhooks to minimize round-trips.

3) Can I combine Fundamental Grade with TM Grade or signals?

Yes. A common pattern is Fundamental Grade for quality filter + TM Grade for technical/sentiment context + Trading Signals for timing and Support/Resistance for risk placement.

4) How “accurate” is the grade?

It’s an opinionated synthesis of multiple inputs—not financial advice. Historical studies can inform usage, but past performance doesn’t guarantee future results. Always layer risk management and testing.

5) Do you offer SDKs and examples?

You can use REST directly (see JS/Python above). The docs include quickstarts, Postman, and ready-to-clone templates—start with Run Hello-TM.

6) Polling vs webhooks for fundamentals updates?

For UI pages, cached polling works well. For event-style notifications (upgrades/downgrades), prefer webhooks or scheduled jobs to avoid spiky traffic.

7) What about pricing, limits, and enterprise SLAs?

Begin free and scale as you grow. See API plans for allowances; enterprise SLAs and support are available—contact us.

Research

Fundamental Grade Crypto API: Invest with Conviction Using Real Project Signals

Token Metrics Team
4

Most traders chase price action; Fundamental Grade Crypto API helps you see the business behind the token—community traction, tokenomics design, exchange presence, VC signals, and DeFi health—consolidated into one score you can query in code. In a few minutes, you’ll fetch Fundamental Grade, render it in your product, and ship a due-diligence UX that drives trust. Start by grabbing your key at the Get API Key page, Run Hello-TM to verify your first call, then Clone a Template to go live fast.

What You’ll Build in 2 Minutes

A minimal script to fetch Fundamental Grade from /v2/fundamental-grade for any symbol (e.g., BTC).

  • Optional curl to smoke-test your key in seconds.
  • A drop-in pattern to display the grade + key drivers in dashboards, screeners, and research tools.

Endpoints to consider next:

  • /v2/tm-grade (technical/sentiment/momentum)
  • /v2/price-prediction (scenario planning)
  • /v2/resistance-support (risk levels)
  • /v2/quantmetrics (risk/return stats)

Why This Matters

Beyond price, toward quality. Markets are noisy—hype rises and fades. Fundamental Grade consolidates hard-to-track signals (community growth, token distribution, liquidity venues, investor quality, DeFi integrations) into a clear, comparable score. You get a fast “is this worth time and capital?” answer for screening, allocation, and monitoring.

Build trust into your product. Whether you run an investor terminal, exchange research tab, or a portfolio tool, Fundamental Grade lets users justify positions. Pair it with TM Grade or Quantmetrics for a balanced picture: what to buy (fundamentals) and when to act (signals/levels).

Where to Find The Fundamental Grade

The Fundamental Grade is easily accessible in the top right of the API Reference. Grab the cURL request for seamless access!

Build Smarter Crypto Apps & AI Agents with Token Metrics

Token Metrics provides real-time prices, trading signals, and on-chain insights all from one powerful API. Grab a Free API Key

How It Works (Under the Hood)

Fundamental Grade aggregates multiple project-quality signals into a normalized score and label (e.g., Strong / Average / Weak). Typical sub-signals include:

  • Community: momentum across channels (dev activity/user traction signals where applicable).
  • Tokenomics: supply schedule, distribution, unlock dynamics, incentives.
  • Exchange Presence: venue coverage, depth/liquidity proxies.
  • VC/Investor Signals: quality/durability of backing and ecosystem support.
  • DeFi Health: integrations, TVL context, composability footprint.

At query time, you call /v2/fundamental-grade with a symbol; responses include the overall score plus component scores you can visualize. For dashboards with many assets, batch fetches and short-TTL caching keep pages responsive. If you push alerts (e.g., “Fundamental Grade upgraded”), prefer webhooks or queued jobs to avoid hammering the API.

Production Checklist

  • Rate limits: Know plan caps; add client throttling and request queues.
  • Retries/backoff: Exponential backoff + jitter; surface actionable error messages.
  • Idempotency: Prevent duplicate downstream actions on retried calls.
  • Caching: Use memory/Redis/KV with short TTLs; pre-warm popular symbols.
  • Webhooks & jobs: For alerts, use signed webhooks or scheduled jobs; log delivery outcomes.
  • Pagination/Bulk: When covering many tokens, paginate or process in batches.
  • Error catalog: Map 4xx/5xx to user-visible fixes; log request IDs.
  • Observability: Track p95/p99 and error rate per endpoint; alert on spikes.
  • Security: Keep API keys in secrets managers; rotate regularly.

Use Cases & Patterns

  • Screener Maker: Rank tokens by Fundamental Grade, filter by market cap/sector, and add “rising fundamentals” badges for discovery.
  • Dashboard Builder: On each token page, show the headline grade with a component chart; link to methodology for transparency.
  • Research & PM Tools: Flag downgrades/upgrades to prompt re-evaluation; attach notes to component changes (e.g., DeFi health drop).
  • Allocator / Risk: Require a minimum Fundamental Grade before inclusion; rebalance only when grade crosses thresholds.
  • Community/Discord: Post weekly upgrades as digest messages with links back to your app.

Next Steps

  • Get API Key — generate a key and start free.
  • Run Hello-TM — verify your first successful call.
  • Clone a Template — deploy a screener or token page today.
  • Watch the demo: VIDEO_URL_HERE
  • Compare plans: Scale confidently with API plans.

FAQs

1) What does the Fundamental Grade API return?

A JSON payload with the overall score/grade plus component scores (e.g., community, tokenomics, exchange presence, VC backing, DeFi health) and timestamps. Use the overall grade for ranking and component scores for explanations.

2) How fast is the endpoint? Do you publish SLOs?

The API is engineered for predictable latency. For high-traffic dashboards, add short-TTL caching and batch requests; for alerts, use jobs/webhooks to minimize round-trips.

3) Can I combine Fundamental Grade with TM Grade or signals?

Yes. A common pattern is Fundamental Grade for quality filter + TM Grade for technical/sentiment context + Trading Signals for timing and Support/Resistance for risk placement.

4) How “accurate” is the grade?

It’s an opinionated synthesis of multiple inputs—not financial advice. Historical studies can inform usage, but past performance doesn’t guarantee future results. Always layer risk management and testing.

5) Do you offer SDKs and examples?

You can use REST directly (see JS/Python above). The docs include quickstarts, Postman, and ready-to-clone templates—start with Run Hello-TM.

Research

Indices Hub: Join the Waitlist for TM Global 100 (2025)

Token Metrics Team
5

If you’ve been waiting for a simple, rules-based way to own the Token Metrics Global 100—without micromanaging tokens—this hub is for you. The TM Global 100 is a rules-based crypto index that holds the top 100 assets in bull markets and moves to stablecoins in bear markets, with weekly rebalancing and transparent holdings/transaction logs you can verify at any time. It’s designed for hands-off allocators who want disciplined exposure and for active traders who want a core that adapts to regimes—without guesswork or endless rebalancing. Below you’ll find how it works, who it’s for, and exactly how to join the waitlist so you’re first in line when trading opens.

Join the waitlist to be first to trade TM Global 100.

Why Indices Matter in October 2025

Search intent right now: investors want credible, rules-based crypto exposure that can participate in upside while reducing drawdown pain. A crypto index is a basket of assets selected and maintained by rules—so you avoid one-off bets and constant manual rebalancing.

With liquidity rotating quickly across sectors, weekly rebalancing helps maintain alignment with current market-cap leaders, while regime switching provides a disciplined, pre-defined response to bearish conditions. The result is a clear, consistent process that removes emotional decision-making and operational drag.

Definition

A crypto index is a rules-based basket of digital assets that’s constructed, weighted, and rebalanced on a set schedule.

How the TM Global 100 Index Works (Plain English)

  • Regime switching: Bullish: Hold the top-100 crypto assets by market cap.
  • Bearish: Exit all positions into stablecoins and wait for a new bullish signal.
  • Weekly rebalancing: Reflects updated rankings and weights across the market-cap universe.
  • Transparency: Strategy modal shows methodology and thresholds; Gauge → Holdings Treemap → Transactions Log make every change visible.

What you’ll see on launch: Price tile, gauge (“rebalances weekly”), 100 tokens, one-click Buy Index flow, and a 90-second checkout via embedded wallet.‍See the strategy and rules.

Benefits at a Glance (Why This Beats DIY)

  • Time saved: No more manual coin-picking, sizing, and calendar rebalances.
  • Lower execution drag: One click vs. dozens of individual orders that can add slippage.
  • Stay current: Weekly rebalances help you capture market-cap changes without constant monitoring.
  • Discipline in drawdowns: Automatic switch to stablecoins removes panic decisions.
  • Radical visibility: Holdings treemap, table, and transactions log show what you own and what changed—every week.
  • Operational simplicity: Embedded wallet and a unified dashboard; no juggling chains and exchanges.

Step-by-Step: How to Get Early Access (Waitlist)

  1. Open the Indices Hub: Head to the Token Metrics Indices hub.
  2. Choose TM Global 100: Open the index page and review the Gauge → Strategy → Holdings.
  3. Join the Waitlist: Add your email to be notified the moment trading opens.
  4. (Optional) Connect Wallet: Pre-connect your wallet for a faster launch-day checkout.

Launch-Day Flow (~90 seconds): Tap Buy Index, review fees/slippage, confirm, and see your position in My Indices. Track Rebalances: After each weekly rebalance or regime change, check the Transactions Log for updates.

Join the waitlist to be first to trade TM Global 100.

Decision Guide: Is This Right for You?

  • Hands-Off Allocator: Want broad exposure without micromanaging? Yes—rules-based + weekly rebalances.
  • Active Trader: Need a core that sits in stables during bears while you hunt edges elsewhere? Fits.
  • TM Member/Prospect: Already trust Token Metrics research? This is the rules-based version of “own the market.”
  • Risk-Aware Newcomer: Prefer a clear framework over vibes? Methodology is visible and auditable.
  • DIY Basket Builder: Tired of missed rebalances and slippage? One click can reduce execution drag.
  • Data-First Analyst: Want to verify? See the holdings, weights, and transaction history anytime.

FAQs

1) What is a TM Global 100 index?

It’s a rules-based crypto index that holds the top 100 assets by market cap in bullish regimes and moves to stablecoins in bearish regimes. It rebalances weekly and shows transparent holdings and transactions.

2) How often does the index rebalance?

Weekly, with additional full-portfolio switches when the market regime changes.

3) What triggers the move to stablecoins?

A proprietary market signal. When bearish, the index exits all token positions into stablecoins and waits for a bullish re-entry signal.

4) Can I fund with USDC or fiat?

At launch, funding and settlement options surface based on the embedded wallet and supported chains. USDC payouts are supported for selling; additional entry options may be introduced later.

5) Is the wallet custodial?

No. The Embedded Wallet is self-custodial—you control your funds while using a streamlined, on-chain checkout.

6) How are fees shown?

Before you confirm, the Buy flow shows estimated gas, platform fee, maximum slippage, and the minimum expected value.

7) How do I join the waitlist?

Go to the Token Metrics Indices hub or the TM Global 100 strategy page and submit your email. We’ll notify you the moment trading opens.

Security, Risk & Transparency

  • Self-custody: Embedded smart wallet; you hold the keys.
  • 2FA & session hygiene: Use strong auth practices for your TM account.
  • Fee clarity: Gas, platform fee, and slippage are displayed before you confirm.
  • Auditability: Holdings, treemap, and transactions log are always visible.
  • Model limits: Regime logic can be wrong, and markets can gap; rules reduce discretion—not risk.
  • Regional availability: Product surfaces may vary by region as we expand.

Crypto is volatile and can lose value. Past performance is not indicative of future results. This article is for research/education, not financial advice.

Conclusion

If you want a disciplined, rules-based core that adapts to market regimes, Token Metrics Global 100 is built for you. Weekly rebalances, transparent holdings, and one-click buy remove operational friction so you can focus on your strategy.

Click here to get early access to Token Metrics indices.

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