Vibe Coding  

Track Crypto Token Prices from CoinGecko Using HTTP Module

📌 Why This Automation?

If you’re a crypto trader, investor, or just a blockchain enthusiast, staying updated on token prices is crucial. Constantly checking prices manually is a productivity killer — and premium market data tools can be expensive.

With Make.com’s free HTTP module and the CoinGecko API, you can track token prices, set alerts, and even log them to a Google Sheet — all without premium modules or paid APIs.

🛠 Tools You’ll Need

  • ✅ Make.com (Free plan)

  • ✅ CoinGecko API (100% free, no API key needed)

  • ✅ Optional: Google Sheets or Email/SMS service for alerts

📊 Step 1: Understand the CoinGecko API

CoinGecko offers free market data. You can get real-time prices in JSON format with just a GET request.

Example API Endpoint:

https://api.coingecko.com/api/v3/simple/price?ids=bitcoin,ethereum,cardano&vs_currencies=usd

Sample JSON Output:

{
  "bitcoin": { "usd": 58932 },
  "ethereum": { "usd": 3120 },
  "cardano": { "usd": 1.23 }
}

⚙ Step 2: Plan the Automation Workflow

Logic:

  1. Trigger → Run every X minutes/hours (scheduler).

  2. Action → Use HTTP module to call CoinGecko API.

  3. Parse → Extract token price from JSON.

  4. Optional Actions →

    • Save price in Google Sheets for tracking history.

    • Send email/SMS if price crosses a set threshold.

🖥 Step 3: Build the Make.com Scenario

Module 1 – Scheduler

  • Run every 30 minutes (or your preferred frequency).

Module 2 – HTTP: Make a Request

  • Method: GET

  • URL:

https://api.coingecko.com/api/v3/simple/price?ids=bitcoin,ethereum,cardano&vs_currencies=usd

Module 3 – JSON Parsing (Inbuilt)

  • Make.com automatically parses JSON, so you can map:

    • Bitcoin price → {{2.bitcoin.usd}}

    • Ethereum price → {{2.ethereum.usd}}

    • Cardano price → {{2.cardano.usd}}

Optional Module 4 – Google Sheets: Add Row

  • Log each token’s price with timestamp.

Optional Module 5 – Gmail / SMS Alert

  • Send message:
    "Bitcoin is now ${{2.bitcoin.usd}}"

🧩 Sample Make.com JSON for This Scenario

{
  "name": "Track Crypto Token Prices",
  "flow": [
    {
      "id": 1,
      "module": "tools:sleep",
      "version": 1,
      "parameters": {
        "interval": 1800
      }
    },
    {
      "id": 2,
      "module": "http:get",
      "version": 1,
      "parameters": {
        "url": "https://api.coingecko.com/api/v3/simple/price?ids=bitcoin,ethereum,cardano&vs_currencies=usd",
        "parseResponse": true
      }
    },
    {
      "id": 3,
      "module": "google-sheets:addRow",
      "version": 1,
      "parameters": {
        "spreadsheetId": "your_google_sheet_id_here",
        "sheetId": "your_sheet_gid_here",
        "values": {
          "Timestamp": "{{now}}",
          "Bitcoin": "{{2.bitcoin.usd}}",
          "Ethereum": "{{2.ethereum.usd}}",
          "Cardano": "{{2.cardano.usd}}"
        }
      }
    }
  ]
}

📈 Step 4: Create a Google Sheet for Logging

Sheet Title: Crypto Price Tracker
Columns:

Timestamp Bitcoin (USD) Ethereum (USD) Cardano (USD)

🚀 Benefits

  • Free forever – No premium APIs.

  • Customizable – Track any token supported by CoinGecko.

  • Extendable – Add charts in Google Sheets for trends.

  • Alerts – Get instant notifications when prices move.

🌟 Pro Tips

  • Track multiple currencies (e.g., USD, EUR, INR) by adding them in vs_currencies.

  • Combine with Google Data Studio for beautiful dashboards.

  • Add a price change trigger: only alert when token moves ±5%.

🛠 Fix – CoinGecko Price Tracker

  1. HTTP Error 429 (Too Many Requests)

    • CoinGecko has rate limits. Reduce scenario run frequency to every 1–5 minutes or track fewer tokens per call.

  2. “Undefined” Price Values in Make.com

    • Run the HTTP module once to fetch live data, then remap the JSON fields to your Google Sheets columns.

  3. Google Sheets Not Updating

    • Verify the correct spreadsheetId and sheetId in the module settings.

    • Ensure the first row in Google Sheets contains headers exactly matching your Make.com mapping.

  4. Scenario Runs but No Data Logged

    • Add a logger module or test with a “Send me an email” step to ensure the HTTP call is returning data before writing to Google Sheets.

  5. Incorrect Token IDs

    • Use the CoinGecko API’s /coins/list endpoint to confirm your token’s exact id (e.g., bitcoin, ethereum, cardano). Wrong IDs return no data.

📌 Final Thoughts

By combining CoinGecko’s free API with Make.com’s HTTP + JSON modules, you can have your very own crypto price tracker without spending a single dollar.

It’s simple, reliable, and can be extended into a full crypto portfolio tracker — all automated.

Membership not found