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
30 Employees
analysts, data scientists, and crypto engineers
30 Employees
analysts, data scientists, and crypto engineers
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

What Are Trading Fees and How Do They Work?

Token Metrics Team
8 min

If you’ve ever bought or sold cryptocurrency, you’ve likely noticed that exchanges charge trading fees. While these fees may seem small at first glance, they can add up significantly over time, especially for frequent traders.

Understanding how trading fees work is essential for maximizing your profits and choosing the right platform and strategy. In this guide, we’ll explain what trading fees are, how they’re calculated, the different types of fees, and how Token Metrics can help you minimize costs while optimizing your trades.

What Are Trading Fees?

Trading fees are charges imposed by cryptocurrency exchanges whenever you execute a trade—whether you’re buying, selling, or swapping digital assets.

  • Purpose:

    • They compensate exchanges for providing liquidity, security, and order-matching services.
    • They discourage spam orders that could overload the exchange.

Example:
If you buy $1,000 worth of Bitcoin with a 0.1% trading fee, you’ll pay $1 in fees for that transaction.

How Are Trading Fees Calculated?

Most crypto exchanges calculate fees based on:

  1. Trade Value (Percentage):

    • The most common model.
    • Fees are a percentage of the total trade amount (e.g., 0.1% per trade).

  2. Flat Fees:

    • Some platforms charge a fixed fee per trade, regardless of trade size.

  3. Tiered Fee Structures:

    • Frequent traders often benefit from lower fees when they reach certain monthly trading volumes.

Maker vs. Taker Fees

Many exchanges use a maker-taker model to incentivize liquidity:

  • Maker Fees:

    • You pay a lower fee (or sometimes nothing) when you add liquidity by placing a limit order that isn’t immediately matched.

  • Taker Fees:

    • You pay a higher fee when you remove liquidity by placing a market order that is filled instantly.

Example:
On Binance, makers might pay 0.08%, while takers pay 0.1%.

Types of Crypto Trading Fees

When trading crypto, you’ll encounter more than just trading fees:

1. Trading (Transaction) Fees

  • Charged when buying or selling crypto.
  • Often range from 0.05%–0.5% depending on the exchange.

2. Deposit Fees

  • Some exchanges charge when funding accounts via credit card, PayPal, or bank transfers.
  • Crypto deposits are typically free.

3. Withdrawal Fees

  • Charged when moving funds off the exchange.
  • Often fixed per withdrawal (e.g., 0.0005 BTC).

4. Network (Gas) Fees

  • Separate from exchange fees, paid to blockchain validators.
  • Ethereum and other networks can have high gas fees during peak demand.

Why Do Trading Fees Matter?

Even small fees can significantly impact your profits, especially if you trade often.

Example:

  • A day trader making 50 trades/month with a 0.1% fee per trade on $1,000 positions will pay $50/month in fees.
  • Over a year, that’s $600 lost to fees—before considering withdrawal or gas costs.

This is why reducing fees is crucial for active traders.

How to Minimize Trading Fees

1. Use Low-Fee Exchanges

Compare platforms—Binance, Bybit, and Kraken often offer competitive rates for high-volume traders.

2. Increase Your Trading Volume

Many exchanges lower fees as your monthly trading volume increases.

3. Use Limit Orders

Save on fees by acting as a maker instead of a taker whenever possible.

4. Pay with Exchange Tokens

Some exchanges offer discounts when fees are paid with their native token (e.g., BNB on Binance).

5. Optimize Your Trading Strategy with AI

Instead of making dozens of small trades, use data-driven insights from Token Metrics to make high-probability trades—reducing overall fee impact.

How Token Metrics Helps You Save on Fees

Token Metrics isn’t an exchange—it’s an AI-powered crypto research and trading platform designed to maximize your profits.

Here’s how it helps with trading fees:

1. AI-Powered Trade Optimization

Token Metrics provides bullish/bearish trading signals based on 80+ technical indicators, helping you enter fewer but higher-quality trades—minimizing unnecessary fees.

2. Trader & Investor Grades

Our proprietary grading system helps you identify top-performing cryptos, reducing guesswork and avoiding costly trial-and-error trading.

3. AI-Managed Indices

Instead of manually rebalancing portfolios (and paying multiple trading fees), use Token Metrics AI-driven crypto indices, which rebalance intelligently while keeping transaction costs low.

4. Narrative Tracking

Our AI detects emerging crypto narratives early, helping you position yourself before the market gets crowded—reducing the need for excessive short-term trading.

Practical Example: Using Token Metrics to Reduce Fees

Imagine you’re trading altcoins manually and make 20 trades/month.

  • At 0.2% per trade on $1,000 positions, you pay $40/month in fees.
  • With Token Metrics AI signals, you cut this down to 8 high-probability trades per month—reducing your fees by 60% while increasing win rates.

This is how data-driven trading saves both money and stress.

Final Thoughts

So, what are trading fees and how do they work? They’re the charges exchanges take for facilitating trades, withdrawals, and transactions—and while they may seem small, they can eat into your profits quickly.

The good news? You can minimize trading fees with the right strategies—and Token Metrics can help.

By providing AI-powered trading signals, long-term Investor Grades, and automated crypto indices, Token Metrics helps you reduce unnecessary trades, make smarter decisions, and maximize your returns—all while minimizing the impact of trading fees.

Whether you’re a beginner or advanced trader, using Token Metrics means trading smarter, not harder.

Research

Should I Use Leverage When Trading Crypto?

Token Metrics Team
8 min

Leverage trading has become a hot topic in the crypto world. Many traders are attracted by the promise of amplified profits—but fail to realize it also magnifies losses. If you’ve been wondering, “Should I use leverage when trading crypto?” the short answer is: only if you fully understand the risks and have a solid strategy.

In this guide, we’ll break down what leverage trading is, how it works, its pros and cons, and how AI-powered tools like Token Metrics can help you make smarter decisions when trading with leverage.

What Is Leverage Trading in Crypto?

Leverage trading lets you borrow funds from an exchange to increase your position size, allowing you to control more capital than you actually own.

For example:

  • If you have $1,000 and use 10x leverage, you’re trading with $10,000.
  • A 10% price increase can give you a 100% profit on your original investment.
  • But a 10% price drop could wipe out your position completely.

Popular platforms like Binance, Bybit, and OKX offer leverage levels from 2x to 125x for certain assets.

Pros of Leverage Trading

Leverage isn’t all bad. When used responsibly, it offers several benefits:

1. Higher Profit Potential

Even small price movements can generate significant returns when using leverage.

2. Portfolio Efficiency

Traders can free up capital for other positions while maintaining large exposure in a leveraged trade.

3. Opportunities in Bear Markets

Leverage allows for short selling, enabling you to profit when prices go down.

Cons of Leverage Trading

The same factors that make leverage attractive also make it high-risk:

1. Amplified Losses

Just as leverage magnifies profits, it magnifies losses. A minor price drop could liquidate your entire position.

2. Liquidation Risk

When your collateral falls below a certain threshold, the exchange automatically closes your position, locking in your losses.

3. Emotional Stress

Leverage trading is fast-paced and stressful, often leading to panic selling or revenge trading after losses.

Should Beginners Use Leverage?

No.
If you’re new to trading, avoid leverage until you have:

  • A proven strategy with consistent results in spot trading.
  • Strong risk management skills (e.g., using stop-loss orders).
  • The ability to stay disciplined under pressure.

For beginners, leveraged trading can be a fast track to losing your capital.

When Does It Make Sense to Use Leverage?

For experienced traders, leverage can make sense when:

  • You’re hedging your portfolio against downside risk.
  • You have high conviction in a trade and want to maximize gains.
  • You’re trading high-liquidity assets like BTC or ETH with well-defined stop-losses.

How Token Metrics Helps You Trade Smarter with Leverage

Leverage trading requires precision, and that’s where Token Metrics gives you an edge.

1. AI-Powered Bullish & Bearish Signals

Identify high-probability trades with real-time AI signals based on 80+ technical indicators. This helps you avoid entering positions blindly.

2. Trader & Investor Grades

Use Trader Grades for short-term trading opportunities and Investor Grades for long-term positions—helping you decide when to scale up or reduce leverage.

3. Risk Assessment Tools

Token Metrics evaluates crypto projects and market trends to reduce exposure to high-risk assets—a must for leveraged positions.

4. AI-Driven Indices

Don’t want to trade manually? Use our AI-managed crypto indices to gain diversified exposure without taking unnecessary leveraged risks.

5. Narrative Detection

Our AI identifies emerging narratives before they hit mainstream attention, giving you a strategic edge in timing trades—crucial when using leverage.

Best Practices for Using Leverage in Crypto

If you decide to use leverage, follow these rules:

  1. Start Small: Use low leverage (2x–3x) instead of going all in at 20x or 50x.
  2. Set Stop-Loss Orders: Always predetermine your maximum loss tolerance.
  3. Trade Liquid Assets: Stick to high-volume coins like BTC and ETH to avoid slippage.
  4. Don’t Overtrade: Only use leverage on trades with strong conviction and proper analysis.
  5. Use AI Tools: Let Token Metrics guide your entries and exits with data-driven insights.

Why Overleveraging Is Dangerous

Many traders lose money by overleveraging, which leads to:

  • Margin calls and forced liquidations.
  • Revenge trading, where losses push traders into reckless decisions.
  • Complete portfolio wipeouts from one bad trade.

Pro Tip: Only trade with leverage on funds you can afford to lose.

Final Thoughts

So, should you use leverage when trading crypto?

For beginners, the answer is no—focus on mastering spot trading first. For experienced traders, leverage can be a powerful tool when used with strict risk management and data-driven insights.

That’s where Token Metrics makes a difference. With AI-powered trading signals, real-time risk analysis, and narrative tracking, Token Metrics helps you trade smarter, reduce emotional mistakes, and optimize your leverage strategy.

Leverage can make you or break you—so don’t go in blind. Use Token Metrics to guide your trades and stay ahead of the market.

Research

What Are the Biggest Risks in Crypto Trading?

Token Metrics Team
8 min

Cryptocurrency trading can be highly rewarding, but it’s also one of the riskiest financial activities you can engage in. Prices can swing wildly within minutes, markets are largely unregulated, and scams remain rampant. Whether you’re a beginner investor or a seasoned trader, understanding these risks is critical for protecting your capital and making informed decisions.

In this guide, we’ll break down the biggest risks in crypto trading, how to recognize them, and how Token Metrics can help you minimize those risks using AI-driven insights.

1. Extreme Volatility

The crypto market is famous for its rapid price fluctuations. Unlike traditional stocks, which typically move in small percentages daily, cryptocurrencies can experience 10–50% swings in a single day.

  • Why it matters:

    • Quick price drops can wipe out profits or even your entire portfolio.
    • Leverage trading amplifies these risks, often leading to liquidations.

  • Example:
    In May 2021, Bitcoin fell from $64,000 to $30,000 in just weeks, catching many traders off guard.

How Token Metrics Helps:
Token Metrics provides AI-powered trading signals and market trend analysis to help you avoid trading blindly. Our Trader Grades let you know when an asset is trending bullish or bearish, giving you data-driven entry and exit points.

2. Lack of Regulation

Unlike traditional finance, cryptocurrency operates in a largely unregulated space. This creates both opportunities and risks.

  • Key risks:

    • Exchanges can shut down or get hacked with little recourse.
    • Bad actors can manipulate prices (pump-and-dump schemes).
    • Regulatory crackdowns in certain regions can cause market crashes.

How Token Metrics Helps:
We track regulatory trends and narratives using AI-driven sentiment analysis, alerting you to shifts that could impact your holdings.

3. Security Risks & Hacking

Crypto traders often store their assets on exchanges or hot wallets—prime targets for hackers.

  • Risks include:

    • Exchange hacks leading to stolen funds.
    • Phishing scams that trick users into giving away private keys.
    • Rug pulls in DeFi projects that drain liquidity.

How Token Metrics Helps:
Token Metrics evaluates crypto projects with AI-based risk scoring, helping you avoid tokens and platforms with poor security practices or suspicious activity.

4. Scams & Fraud

From rug pulls to fake ICOs and Ponzi schemes, crypto has become a hotbed for scams targeting inexperienced traders.

  • Examples of common scams:

    • Pump-and-dump groups on Telegram.
    • Fake airdrops asking for wallet connections.
    • Impersonation scams on social media.

How Token Metrics Helps:
Our Moonshot Finder doesn’t just find hidden gem tokens—it uses AI-driven vetting to filter out high-risk projects, helping you spot potential scams before you invest.

5. Emotional Trading

The fear of missing out (FOMO) and panic selling are two of the biggest psychological pitfalls in crypto trading.

  • How it affects traders:

    • FOMO causes impulsive buying at peaks.
    • Panic selling during dips leads to unnecessary losses.
    • Overtrading erodes profits through excessive fees and bad timing.

How Token Metrics Helps:
By offering objective, AI-driven market insights, Token Metrics removes the emotional bias from trading. Our data-backed signals tell you when to hold, sell, or accumulate—reducing emotionally driven mistakes.

6. Liquidity Risks

Some cryptocurrencies—especially low-cap altcoins—have low liquidity, making it difficult to buy or sell without significantly impacting the price.

  • Why this matters:

    • You may be unable to exit a position when needed.
    • Large trades can cause slippage and losses.

How Token Metrics Helps:
Our platform tracks liquidity metrics for thousands of tokens, ensuring you know the trading conditions before entering or exiting a position.

7. Leverage & Margin Trading Dangers

While leverage trading can amplify profits, it can also wipe out your portfolio quickly.

  • Risks include:

    • Liquidation if prices move against your position.
    • Amplified emotional stress and poor decision-making.

How Token Metrics Helps:
Token Metrics identifies high-probability trades using AI-based technical analysis, reducing the guesswork in leveraged trading.

8. Narrative & Hype Cycles

Crypto prices are often driven by hype, social media trends, and narratives, which can be unpredictable and short-lived.

  • Example:
    The rapid rise and fall of meme tokens like Dogecoin and Shiba Inu, which surged based on social media buzz but saw massive corrections.

How Token Metrics Helps:
Our AI detects emerging narratives early—whether it’s AI tokens, DeFi, or RWA projects—so you can position yourself before the hype cycle peaks.

How to Mitigate These Risks

Here are some best practices for reducing crypto trading risks:

  1. Diversify your portfolio: Don’t put all your funds into one token.
  2. Use AI-powered tools like Token Metrics: Let data, not emotions, guide your trades.
  3. Practice good security hygiene: Use hardware wallets and enable two-factor authentication.
  4. Avoid leverage until experienced: Trade with spot assets before exploring margin.
  5. Stay updated: Monitor news and regulatory developments.

Why Token Metrics Is the Best Tool for Risk Management

Token Metrics is more than a research platform—it’s your AI-powered trading assistant. Here’s why traders trust it:

  • AI-Powered Signals: Get real-time bullish/bearish alerts for smarter trading.
  • Risk Scoring: Avoid scams and unsafe projects with our proprietary evaluations.
  • Moonshot Finder: Discover promising low-cap tokens with AI-vetted potential.
  • Trader & Investor Grades: Balance short-term trading with long-term investing.
  • AI Indices: Use auto-managed portfolios to reduce risk through diversification.


Whether you’re a beginner looking to avoid common pitfalls or an advanced trader seeking data-driven edge, Token Metrics helps you trade smarter and safer.

Final Thoughts

So, what are the biggest risks in crypto trading? From extreme volatility and scams to emotional decision-making and security threats, the dangers are real. But with the right strategies and tools, you can navigate the market with confidence.

By using Token Metrics’ AI-powered insights, you can reduce emotional bias, avoid high-risk tokens, and make smarter, data-driven trades—turning crypto’s volatility from a threat into an opportunity.

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