📌 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

📊 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

Module 2 – HTTP: Make a Request

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

Module 3 – JSON Parsing (Inbuilt)

Optional Module 4 – Google Sheets: Add Row

Optional Module 5 – Gmail / SMS Alert

🧩 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:

TimestampBitcoin (USD)Ethereum (USD)Cardano (USD)

🚀 Benefits

🌟 Pro Tips

🛠 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.

No-Code Alternative (Free)

Make’s HTTP module can be used to poll CoinGecko APIs and store or notify price updates without writing custom code. It offers a free tier and allows you to design automation with simple drag-and-drop modules—useful if you want to add filters, branching, or additional app integrations later.

You can explore it here (free account): https://www.make.com/en/register?pc=rohit9910

📌 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.