Ribbon Leads
API & CSV

Pull the feed into your own tools

Every paid plan gets a CSV link. National plans also get a JSON API and webhook delivery. Your key is on your account page and in your welcome email.

CSV export Market + National

GET https://ribbon.srv1748596.hstgr.cloud/csv/<your-key>?days=30
GET https://ribbon.srv1748596.hstgr.cloud/csv/<your-key>?days=7&category=bar

Columns: id, state, stage, stage_label, category, category_label, name, owner, address, city, county, zip, phone, email, website, status, licence_type, event_date, first_seen, source, source_url, url, lat, lng, google_rating. Market plans are limited to their state.

JSON API National

GET https://ribbon.srv1748596.hstgr.cloud/api/v1/venues?key=<your-key>&days=7
GET https://ribbon.srv1748596.hstgr.cloud/api/v1/venues?key=<your-key>&state=TX&category=restaurant&limit=200
GET https://ribbon.srv1748596.hstgr.cloud/api/v1/states
{
  "count": 2,
  "days": 7,
  "venues": [
    {
      "id": 18231, "state": "TX", "stage": "issued", "stage_label": "Licence issued",
      "category": "bar", "category_label": "Bar / nightlife",
      "name": "Southern Yankee Crafthouse", "owner": "The Nelson Team LLC",
      "address": "1312 West Alabama Street", "city": "Houston", "county": "Harris", "zip": "77006",
      "phone": "(713) 555-0142", "email": "", "website": "https://…",
      "status": "Active", "licence_type": "MB", "event_date": "2026-08-31",
      "first_seen": "2026-09-01T11:02:44Z", "source": "tx_tabc_issued",
      "source_url": "https://…", "url": "https://ribbon.srv1748596.hstgr.cloud/venue/southern-yankee-crafthouse-houston-tx",
      "lat": 29.74, "lng": -95.39, "google_rating": null
    }
  ]
}

Limits: days up to 365, limit up to 5000, please no more than one request a minute — the data changes once a day. Keys are revoked when a subscription ends.

Webhook National

Set an https:// URL on your account page. Every morning after the daily digest we POST {"event":"venues.new","count":N,"venues":[…]} with the same objects as the API. We don't retry; the API is the source of truth if a delivery is missed.

Zapier, Make, Sheets

Point a scheduled HTTP step at the API URL, or import the CSV link directly into Google Sheets with =IMPORTDATA("https://ribbon.srv1748596.hstgr.cloud/csv/<key>?days=30"). Both refresh every morning.

Get a key