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

How to Build On-Chain Crypto Trading Bots Using Token Metrics Crypto API and Chainlink Functions

Token Metrics Team
8 min

In the evolving world of Web3 development, the need for real-time, reliable, and institutional-grade crypto data has never been greater. Whether you’re building decentralized trading bots, DeFi apps, or smart contract platforms, accessing powerful off-chain data is key to creating intelligent and profitable on-chain systems.

That’s where the Token Metrics Crypto API comes in.

In this guide, we’ll walk you through how to integrate the Token Metrics API with Chainlink Functions, enabling you to deploy live smart contracts that interact with real-time crypto signals, token prices, and trader grades. You’ll learn how to use more than 20 API endpoints and smart contract adapters to power decentralized apps with actionable data.

If you’re searching for the best crypto API for smart contract development, or you need a free crypto API to start testing on testnets, this article is your ultimate resource.

What Is the Token Metrics Crypto API?

The Token Metrics API is an advanced data interface designed for traders, developers, and Web3 builders. It provides access to over 20 endpoints covering everything from:

  • Token prices
  • AI-powered trading signals (bullish/bearish)
  • Trader and Investor Grades (0–100 scoring system)
  • Quant metrics
  • Support and resistance levels
  • Sentiment analysis

Built by a team of quant analysts, machine learning engineers, and crypto-native researchers, the Token Metrics Crypto API brings hedge-fund-grade intelligence into the hands of everyday builders.

Why Use the Token Metrics API with Chainlink Functions?

Chainlink Functions enable smart contracts to securely retrieve off-chain data from any API. By integrating with the Token Metrics Crypto API, you can bridge institutional-grade analytics into fully decentralized apps—something not possible with basic or unreliable data sources.

Here’s why this combo is so powerful:

  • 🔗 Chainlink decentralizes your execution
  • 🧠 Token Metrics powers your logic with predictive analytics
  • ⚙️ Smart contracts can now act on real market intelligence

This integration enables the creation of intelligent trading bots, dynamic token allocations, and governance proposals backed by hard data—not speculation.

Step-by-Step: How to Integrate Token Metrics API with Chainlink Functions

Let’s walk through how to connect the best crypto API—Token Metrics—with Chainlink Functions to build and deploy a live smart contract.

1. Clone the GitHub Repo

Start by cloning the GitHub repository that contains the full codebase. This includes:

  • A set of ~20 pre-built smart contracts
  • API adapter logic
  • Sample scripts to interact with the contracts
  • A detailed README with setup instructions

Each smart contract is tailored to one Token Metrics API endpoint—meaning you can plug and play any dataset, from prices to sentiment scores.

2. Set Up Your Environment

The README provides a full list of recommended environment variables, including:

  • API_KEY for Token Metrics
  • LINK_TOKEN_ADDRESS
  • CHAINLINK_SUBSCRIPTION_ID
  • ORACLE_ADDRESS

Once your .env is ready, you can start compiling and deploying.

3. Build and Deploy a Sample Trading Bot Smart Contract

In this walkthrough, the developer built a Solidity smart contract that:

  • Pulls live data from Token Metrics (price, signal, grade)
  • Evaluates the signal (e.g., bullish)
  • Executes a buy trade if the signal is positive

The contract is compiled in Remix IDE, connected via MetaMask (on testnet), and deployed using testnet ETH and LINK tokens.

After deployment, you’ll receive a contract address that can be added to your Chainlink subscription.

4. Create a Chainlink Subscription

To fund your contract for data requests:

  1. Go to the Chainlink portal
  2. Create a new subscription (testnet or mainnet)
  3. Fund it with some LINK
  4. Add your deployed smart contract as a consumer

This allows your contract to make external data calls using Chainlink’s decentralized oracle network.

5. Run a Script to Invoke Real-Time Token Metrics Data

Using the provided JavaScript scripts, you can interact with the smart contract and test data flow:

  • Check the bot’s active status
  • Retrieve token price, trading signal, and grade
  • See how the smart contract responds to live market conditions

In the demo, the bot received a bullish signal, saw that the grade was high, and executed a buy trade accordingly. This logic can be expanded into full-scale trading strategies, rebalancing rules, or even on-chain governance triggers.

Why Token Metrics API Is the Best Crypto API for Smart Contracts

Here’s what makes the Token Metrics Crypto API the best crypto API for building advanced, data-driven dApps:

✅ Institutional-Grade Signals

Get access to proprietary AI trading signals, used by hedge funds and institutional desks.

✅ 20+ Endpoints for Every Use Case

Whether you need sentiment data, grades, price trends, or quant models, it’s all there.

✅ Real-Time and Back-Tested

The data is not just live—it’s tested. Token Metrics backtests every signal against market conditions.

✅ Easy to Integrate

Pre-built smart contract adapters make it easy to use the API in Chainlink, Remix, or any EVM-compatible environment.

✅ Free Crypto API Tier Available

Start testing on testnets with a free crypto API key. Upgrade later for full production access.

Real-World Use Cases for Token Metrics + Chainlink Functions

Here are some examples of what you can build using this integration:

  • On-Chain Trading Bots: React to bullish or bearish signals in real time
  • Decentralized Rebalancing Strategies: Adjust token allocations based on trader grades
  • Token Governance: Trigger proposal alerts when sentiment crosses a threshold
  • Risk Management Contracts: Move funds to stablecoins when volatility spikes
  • NFT Floor Price Triggers: Use sentiment and price data for automated mint/pass logic

Final Thoughts: The Future of Crypto Intelligence Is On-Chain

As Web3 matures, the ability to combine decentralized execution with centralized intelligence will define the next generation of dApps. The integration of Token Metrics Crypto API with Chainlink Functions is a major step in that direction.

Developers can now build on-chain applications that make smarter, faster, and more profitable decisions—powered by data that was once out of reach.

Whether you're a DeFi developer, a DAO engineer, or just exploring your first smart contract, this setup gives you a free crypto API to experiment with and the power of the best crypto API when you're ready to scale.

🚀 Ready to Get Started?

  • Get your free Token Metrics API key
  • ✅ Clone the GitHub repo and install the smart contracts
  • ✅ Join the Token Metrics Dev Telegram community
  • ✅ Start building intelligent, AI-powered crypto applications today

Your next-generation crypto trading bot starts here.

Crypto Basics

How Risky Are Moonshot Investments?

Token Metrics Team
8 min

 Introduction: The High Stakes of Moonshot Crypto

Moonshot investing in crypto is a double-edged sword. On one side, you have tokens that can 10x, 50x, or even 100x your portfolio. On the other side? Complete capital loss. While these asymmetric bets can lead to explosive profits, they also carry extreme risk—especially for uninformed or impulsive investors.

This guide will break down the risk landscape of moonshots: what makes them so volatile, common pitfalls to avoid, risk management strategies, and how tools like Token Metrics help reduce blind spots when betting on the next big thing.

What Makes Moonshot Investments So Risky?

Moonshots live in the outer rim of the crypto market. They are typically:

  • Low market cap (<$20M)
  • Light on liquidity
  • Not listed on major exchanges
  • Lacking product-market fit
  • Speculative or narrative-driven

These factors create an environment where price moves fast—but fundamentals are often thin. You're betting more on potential than proof.

Common Risks in Moonshot Investing

You must assume every moonshot has some of these risk factors — and plan accordingly.

Risk Profile: Moonshots vs. Blue Chips

Moonshots = high variance. Don’t treat them like stable assets.

🛡️ How to Manage Moonshot Risk (and Stay Sane)

  1. Use Proper Position Sizing
    Never allocate more than 1–3% of your total portfolio to a single moonshot.

  2. Diversify Your Moonshots
    Build a “moonshot basket” of 5–10 different bets across categories (AI, DePIN, L1s, Meme, etc).

  3. Set Clear Entry and Exit Plans
    Know your take-profit and stop-loss targets before entering.

  4. Track Vesting & Unlock Schedules
    Use tools like Token Unlocks to avoid buying before big token dumps.

  5. Don’t Fall in Love With Your Bags
    Stay objective. Exit when the narrative fades or fundamentals change.

🧪 Risk Evaluation Checklist

If you answer “no” to 2 or more of these, tread cautiously.

How Token Metrics Minimizes Risk Exposure

Token Metrics helps de-risk moonshots by analyzing over 80+ data points using AI and quant models:

  • Risk-adjusted momentum scores
  • Tokenomics evaluations
  • On-chain behavior analysis
  • Contract audit status
  • Community health signals
  • Bullish/Bearish alerts based on AI

You get a comprehensive view of upside and downside before making a decision.

Mental Models for Risky Investing

  • “Play with house money” – Take profits early and only risk profits.
  • “Barbell strategy” – Majority in stable assets, small % in high-risk/high-reward.
  • “Expected Value (EV)” – Even if 8/10 fail, 1 big win covers losses.
  • “Don’t chase losses” – Accept failures quickly and move on.

Moonshot investing is mental warfare. Stick to frameworks, not FOMO.

Final Thoughts: Risk is Inevitable — Manage It, Don’t Fear It

The path to 100x gains in crypto will always be riddled with landmines. But risk isn’t inherently bad — it’s the price of asymmetric upside. The real danger is unmanaged risk, impulsive decisions, and poor research.

With the right approach, the right tools, and a clear head, moonshot investing can be one of the most rewarding strategies in crypto.

Just remember: You only need to be right once.

Crypto Basics

Are Moonshots Only Meme Coins?

Token Metrics Team
8 min

Introduction: The Meme Coin Myth

When most people think “moonshot” in crypto, they think of meme coins like Dogecoin, Shiba Inu, or Pepe — volatile, viral, and often with no utility. While it’s true that meme coins have historically delivered explosive returns, they’re just one type of moonshot. In reality, some of the best moonshots are deeply technical projects with innovative real-world use cases.

In this blog, we’ll explore why moonshots go far beyond memes, the other types of high-potential assets you should be watching, and how to distinguish hype from substance in your moonshot hunt.

Why Meme Coins Became the Face of Moonshots

Meme coins dominate headlines and retail attention for good reason:

  • Low entry barriers – Often priced at fractions of a cent
  • Viral marketing – Driven by memes, humor, and community hype
  • Explosive gains – SHIB, DOGE, and PEPE all had 1,000x+ runs
  • Community-driven – Holders often act as evangelists

Because of these qualities, meme coins are often perceived as the only moonshots. But perception doesn’t equal reality.

The Reality: Many Moonshots Are Utility-Driven

Some of the most successful moonshot investments didn’t begin as memes — they were innovative, under-the-radar projects that grew into billion-dollar ecosystems:

None of these were memes — they were tech-focused moonshots.

Categories of Non-Meme Moonshots

Here are several non-meme sectors producing moonshot-level gains:

  1. AI Coins – e.g., Fetch.ai, Render, Akash
  2. DePIN (Decentralized Physical Infrastructure) – e.g., Helium, IoTeX
  3. RWAs (Real-World Assets) – e.g., Centrifuge, Goldfinch
  4. L2 & Interoperability – e.g., Starknet, Hyperlane, Axelar
  5. Privacy Coins – e.g., Namada, Secret Network
  6. Early-stage L1s – e.g., SEI, Monad

These projects combine visionary ideas with real-world applicability — and many began as stealth moonshots before going mainstream.

How to Spot Utility-Based Moonshots Early

Look for:

  • Unique narrative fit – Aligns with hot macro themes (AI, DeFi 2.0, Web3 infra)
  • Underexposed – Not yet listed on major CEXs or hyped by influencers
  • Backed by smart money – VC involvement or known crypto angels
  • Product roadmap – Testnet/Mainnet imminent or newly launched
  • Active GitHub or whitepaper – Real builders, not marketers

Meme coins may be powered by emotion — but utility moonshots are powered by execution.

Token Metrics Helps Spot Both Meme & Utility Moonshots

Token Metrics doesn’t just chase hype — it grades thousands of tokens using 80+ data points including:

  • Momentum and price trends
  • Community sentiment and buzz
  • GitHub commits and developer activity
  • Market cap ranking
  • AI-generated bull/bear signals
  • Smart contract risk analysis

This means you can discover both emerging meme coins and tech-driven moonshots based on real metrics — not just Twitter noise.

Can Meme Coins Still Be Valid Moonshots?

Yes — but they should be treated like short-term plays with proper risk management. When timed right (early launch, CEX rumor, meme trend), meme coins can 10x fast. But unlike utility tokens, meme coins often lack long-term sustainability unless they evolve (like DogeX or SHIB ecosystem).

Use tools like Token Metrics AI Signals to time entries and exits.

⚠️ Avoiding the Meme Coin Traps

Don’t confuse “meme” with “momentum.” Use data.

Conclusion: The Smart Moonshot Portfolio is Diversified

If your moonshot portfolio is 100% meme coins, you're gambling. If it’s 100% early L1s with no traction, you may be stuck waiting years. Smart investors build a balanced basket that includes:

  • Memes with momentum
  • Mid-cap undervalued alts
  • Undiscovered AI, RWA, and DePIN gems
  • Fundamental plays with strong tokenomics

Meme coins are just one path to the moon — don’t miss the others.

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