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

Andrena and the Rise of DePIN: Decentralized Internet in 2025

Token Metrics Team
8 min

Introduction:
Decentralized Physical Infrastructure Networks (DePINs) are rapidly emerging as one of the most transformative sectors in the blockchain space. In 2025, projects like Andrena are pushing the boundaries of what’s possible by bridging real-world hardware with decentralized protocols. This blog takes a closer look at the DePIN thesis, Andrena’s approach, and why this project is on the radar of top investors and analysts.

What Is DePIN?

DePIN stands for Decentralized Physical Infrastructure Networks. It refers to blockchain-powered networks that coordinate real-world infrastructure using token-based incentives. Use cases include:

  • Wireless internet (e.g., Helium)
  • Sensor networks (e.g., WeatherXM)
  • Storage and compute (e.g., Filecoin, Akash, Arweave)
  • Energy grids (e.g., PowerPod)

In short, DePINs decentralize infrastructure deployment and management using blockchain-based coordination tools.

Why DePIN Matters in 2025

  1. Infrastructure Gaps: Billions remain unconnected to the internet or lack access to basic digital services. DePINs offer a way to close these gaps without reliance on centralized telecoms.
  2. Token Incentives for Network Participation: Hardware operators are rewarded for contributing bandwidth, compute, or coverage—creating a new economic model.
  3. Real-World Utility: Unlike speculative tokens, DePIN projects often provide visible, tangible value from day one.

Introducing Andrena: The Helium of the Internet?

Andrena is a DePIN project building a decentralized internet backbone through a combination of physical devices and blockchain protocols. The project is developing a hardware device called Black Box, expected to launch in July.

Key features:

  • Distributed, peer-to-peer wireless coverage
  • Web3 native incentives for node operators
  • No reliance on centralized ISPs
  • Tentative deployments in New York City, Mexico City, and Accra
  • Deep integration with Helium Network and its infrastructure

Andrena aims to give individuals and communities the power to run their own internet access points and be compensated in a decentralized system.

Why It’s Generating Buzz

Token Metrics researchers flagged Andrena as a top pick for long-term infrastructure exposure. Here's why:

  • Backed by Top VCs: In its upcoming Series B, Andrena is reportedly raising funds from major firms including Polychain Capital, Archetype, Wintermute, and Coinbase Ventures.
  • Mass Market Vision: The goal is not just to serve crypto-native users, but also everyday consumers who simply want affordable, decentralized internet access.
  • Multi-layered Integration: Andrena will offer both physical routers and a browser extension, enabling different levels of participation.

Strategic Partnerships and Rollout

The project is currently in soft-launch mode with localized pilots and is pursuing exchange listings later this year. While details remain limited, the focus is on building a global decentralized ISP layer—a radical shift from the existing internet access model.

Why Andrena Could Succeed Where Others Struggled

Previous attempts at decentralized internet often failed due to:

  • Poor hardware UX
  • Limited adoption outside of crypto users
  • Unclear monetization models

Andrena appears to be addressing these pain points with:

  • Consumer-grade devices
  • Partner integrations (e.g., Helium)
  • Clear token utility tied to network usage and coverage
  • A well-capitalized, experienced founding team

Risks and Unknowns

As with all early-stage infrastructure projects, there are risks:

  • Uncertain regulatory frameworks around ISPs
  • Capital intensity of hardware production and distribution
  • Network growth dependent on physical deployment
  • Limited token utility details at this stage

Investors and builders should stay informed as more information becomes public.

How Token Metrics Is Tracking DePIN Growth

The Token Metrics platform is actively monitoring the DePIN space through metrics such as:

  • TVL (Total Value Locked) in related ecosystems
  • Developer activity and GitHub velocity
  • On-chain signal strength and token accumulation
  • Fundamental and technical ratings

Projects like Andrena and its ecosystem partners are closely watched for early indicators of momentum.

Final Thoughts

DePIN is one of the most compelling frontiers in crypto. It offers real-world, real-time applications that go far beyond speculation. Andrena is at the center of this movement, blending telecom hardware, Web3 incentives, and global deployment.

While it's still early, the signs are promising. From reputable backers to ambitious global plans, Andrena is a project worth watching in 2025 and beyond.

Research

Meme Coins in 2025: Why They’re Still Outperforming the Crypto Market

Token Metrics Team
8 min

Introduction:
Even in a sluggish crypto market, meme coins continue to outperform many other asset classes. In 2025, these highly speculative assets are not only surviving—some are thriving. This blog examines the current state of the meme coin market, what’s driving the activity, and how on-chain data and crypto analytics can help decode the chaos.

Meme Coins: Still Relevant in 2025?

Despite a broadly bearish macro environment, meme coins remain among the few bright spots in the crypto market. In the latest Token Metrics research webinar, several meme tokens showed outsized returns, including:

  • Gorbagana – up over 50% in a day
  • Useless Coin – jumped 40% in 24 hours
  • Startup Coin – nearly 9x returns over the past month

These tokens operate at low market caps and often launch with little or no formal whitepaper or utility. However, the power of narrative, social engagement, and rapid speculation continues to drive short-term gains.

Why Meme Coins Are Performing in a Bear Market

1. Low Liquidity, High Volatility:
Small-cap meme tokens can easily generate parabolic moves with modest capital inflows.

2. Community-Led Narratives:
Tokens like Useless Coin and Startup thrive on viral momentum from crypto-native communities, particularly on X (Twitter) and Telegram.

3. Whale Activity as a Signal:
Token Metrics analysts observed that whales have been accumulating select meme coins. This isn’t an endorsement—but it’s a data point. Monitoring on-chain whale behavior offers clues about where smart money is moving.

The Gobagana Case Study

Gobagana was cited as a high-risk Solana fork with minimal public information, yet it rapidly gained traction. On-chain analysis revealed:

  • Whale wallets accumulating in the early phase
  • Early VC insiders (e.g., those connected to Big Brain VC) engaging with the token
  • Rapid social engagement despite a small follower base

The takeaway? Even opaque meme coins can trigger major rallies—particularly if accumulation patterns align with social volume.

Risk Management and Red Flags

The meme coin market is not without risk. The Token Metrics team emphasized several cautions:

  • Illiquidity: Many meme tokens have low volume and limited exchange listings.
  • Exit scams or soft rugs: Teams can abandon the project after price pumps.
  • Price discovery volatility: Tokens may have no clear valuation baseline and can retrace sharply.

As such, these assets are often best approached with a high-risk tolerance and clear entry/exit rules.

How to Track Meme Coins Like a Quant

Using crypto analytics platforms like Token Metrics can help make sense of meme coin volatility. Tools that help include:

  • Real-time sentiment analysis
  • Whale wallet tracking
  • Price-to-volume anomaly detection
  • Bullish/bearish signal tracking

In 2025, data is more important than hype. While memes may dominate the narrative, only data reveals when the momentum shifts.

Meme Coins vs. Infrastructure Projects

Interestingly, while meme coins have been surging, many infrastructure or protocol tokens remain flat. This divergence suggests that retail attention is still focused on short-term speculation.

That said, once Bitcoin breaks key resistance levels, we could see capital rotate into AI, DeFi, and infrastructure themes. Meme coins may be the “canary in the coal mine” indicating renewed retail appetite.

Final Thoughts

Meme coins remain the wild west of crypto—but they aren’t going away. In fact, they’re becoming more sophisticated, with deeper liquidity pools, faster launches, and increased integration with social media bots and automated token creators.

As always, meme coin trading demands discipline, skepticism, and a robust toolkit. Watch the whales, follow the data, and never trade what you don’t understand.

Research

How to Find Hidden Crypto Gems with 100x Potential (Step-by-Step Guide) | Token Metrics Moonshots

Token Metrics Team
8 min

In the fast-paced world of cryptocurrency, discovering hidden gems—often called moonshots—can lead to life-changing returns. But the real challenge lies in separating hype from actual potential. In this guide, we’ll break down what crypto moonshots are, how they work, and how you can use Token Metrics to reliably find tokens with 100x upside.

What Are Moonshot Tokens?

The term moonshot comes from the idea of a crypto token “going to the moon,” or rapidly increasing in price. These are usually low-cap tokens with a compelling narrative, innovative technology, or early-stage market presence that give them high upside potential.

Key Characteristics of Moonshot Tokens:

  • Market Cap Below $50M – Smaller market caps have more room to grow.
  • High Risk / High Reward – Volatility is expected, but the upside can be enormous.
  • Early Entry – Timing matters. Getting in early before mainstream awareness is key.
  • Backed by Fundamentals – Even moonshots need solid technology, use cases, or backing.

How Do Crypto Moonshots Work?

Moonshots rely on the combination of innovation, market timing, and community adoption. They often start unnoticed, then experience exponential growth once crypto traders and influencers catch on.

The Lifecycle of a Typical Moonshot:

  1. Discovery Phase – A few savvy investors or analysts spot the token.
  2. Accumulation Phase – Early adopters buy in quietly, keeping prices low.
  3. Breakout Phase – News spreads, and trading volume spikes.
  4. Parabolic Run – FOMO (Fear of Missing Out) kicks in, driving price up rapidly.
  5. Profit-Taking or Collapse – Smart traders exit with gains; latecomers may be left holding the bag.

To avoid the trap of hype-driven tokens, it's essential to use data and analytics, not emotions. That’s where Token Metrics becomes your secret weapon.

How to Use Token Metrics to Find Monshots?

Token Metrics is an AI-powered crypto analytics platform that helps you discover high-potential tokens with real-time data, grades, and backtested indicators. Here’s a step-by-step guide to using Token Metrics to uncover 100x opportunities:

Step 1: Go to the Ratings Page

Start from the main dashboard of the Token Metrics app.

  • Navigate to the “Ratings” tab.
  • This page ranks thousands of tokens using AI-based Trader Grade and Investor Grade, factoring in technical indicators, on-chain metrics, sentiment, and more.

Pro Tip: Look for tokens with rising Trader Grades and strong historical performance.

Step 2: Click on the “Moonshots” Tab

Once you’re in the Ratings section:

  • Click the “Moonshots” tab at the top of the page.
  • This will filter the list down to tokens the AI model flags as having moonshot potential—i.e., tokens likely to perform exceptionally well in the short term.

These are automatically generated by Token Metrics AI models using over 80+ data points, including:

  • Price momentum
  • On-chain activity
  • Sentiment analysis
  • Volume spikes
  • Market structure

Step 3: Review Key Moonshot Metrics

Each Moonshot token is presented with a rich dataset to help you make informed decisions:

  • Trader Grade (with % change in past 24h or 7d)
  • 24H Trading Volume – Gauge market interest
  • Market Cap – Lower caps typically offer more upside
  • Date of Entry – See when the token was first flagged
  • Live ROI Since Moonshot – Know exactly how past picks performed

Bonus Feature: Toggle to “Past Moonshots” to review previous winners and assess the track record of the platform.

Step 4: Choose a Token to Explore

Click on any token in the Moonshots list to open its Token Details Page.

Here, you can:

  • Analyze real-time charts
  • Review fundamentals, like project utility, tokenomics, roadmap, and team
  • See top holders and whale activity
  • Examine price volatility and volume patterns

This is where research and intuition meet. Use the available data to decide if this token fits your risk tolerance and investment thesis.

Step 5: Buy in Seconds

Token Metrics makes the process seamless:

  • Just click the “Buy” button on the Moonshots page.
  • This opens a swap widget powered by integrated DEX aggregators.
  • Choose your wallet, approve the transaction, and you're done—no need to leave the platform.

This integration eliminates the hassle of going to third-party platforms to execute trades, saving time and reducing risk.

Why Use Token Metrics for Finding Moonshots?

Token Metrics isn’t just about flashy picks—it’s about using data science and AI to gain an edge.

Key Benefits:

  • AI-Driven Insights – No emotional bias; just pure data analysis.
  • Transparency – View past moonshot performance, live ROI, and update dates.
  • Speed to Trade – Instant buy options right from the dashboard.
  • Performance Tracking – Evaluate your results based on entry/exit signals.

Real Examples: Token Metrics in Action

  • Euler Finance was flagged as a Moonshot before its 30% rally—validated by a bullish AI signal.
  • Morpho gained traction after appearing in the Moonshots list, later becoming a top TVL gainer.
  • Hyperliquid made the list before capturing major perp trading market share.

By combining early AI alerts with your own due diligence, you can position yourself ahead of the crowd.

Final Thoughts

Finding the next 100x crypto gem doesn’t have to be a guessing game. While the crypto space remains volatile, tools like Token Metrics help stack the odds in your favor. From real-time ratings to instant buy options and performance metrics, you have everything you need to make smart, data-driven bets on the future of crypto.

So if you're serious about turning small investments into big wins, start using Token Metrics to uncover moonshots before they go mainstream.

Try Token Metrics today and unlock the power of AI-driven crypto investing.

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