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:

Trigger → Run every X minutes/hours (scheduler).
Action → Use HTTP module to call CoinGecko API.
Parse → Extract token price from JSON.
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 the token moves ±5%.

🛠 Fix – CoinGecko Price Tracker

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