Sheetcoin

Bring real-time crypto metrics into Google Sheets

Use simple functions like =COIN_PRICE("BTC") to fetch live price, market cap, and 24h volume. Privacy-first and easy to integrate.

No analytics. No tracking. Only necessary data sent to Stripe during checkout.

Example usage

=COIN_PRICE("BTC")
=COIN_PRICE("ETH/BTC")
=COIN_METRIC("BTC","market_cap")
=COIN_METRIC("ETH","volume")

These are examples — Google Apps Script will call the Sheetcoin API to power these functions.

Features

Live market data

Price (USD), market cap (USD), and 24h volume for 3000+ coins.

Google Sheets integration

Use simple custom functions in Sheets. The collector keeps a Redis cache and sheet updated in near real-time.

Subscription gating

Optional paid tier unlocks higher limits and faster refresh via Stripe Checkout and webhook-verified subscriptions.

Privacy-first

No analytics. Minimal required information exchanged only for payments.

Pricing

Free

Free

  • Basic rate limits
  • Access to price, market cap, volume
  • Community support

Pro

Paid (via Stripe)

  • Higher rate limits
  • Priority support
  • Faster Redis TTL refresh

All payments processed through Stripe. You will receive a receipt at the email you provide for checkout.

Quick demo

Embed this in Google Apps Script to call the Sheetcoin API from custom functions. Example Apps Script (simplified):

function COIN_PRICE(ticker) {
  const url = 'https://sheetcoin.net/coins/resolve?ticker=' + encodeURIComponent(ticker);
  // call backend to resolve coin id, then /coins/{id}/metrics?metrics=price
  // return latest price
}

Full docs and Apps Script snippets available in the repository & docs page.