Export API
Pull your leads into Google Sheets, Looker Studio, or anything that reads CSV or JSON — one URL, always current.
Every organisation has a read-only export endpoint serving its leads in a flat, reporting-ready shape:
GET https://YOUR-INSTANCE/api/export/leads?key=YOUR-API-KEYReady-made URLs (JSON, CSV, and CSV-qualified-only) with your API key filled in are in Settings → Setup Guide → section 6. The API key is generated in Settings → Integrations & export — anyone with the key can read your lead export, so treat it like a password.
Query parameters
| Parameter | What it does |
|---|---|
key | Your export API key (required outside the app) |
format | json (default) or csv |
status | Filter by qualification status: QUALIFIED, NOT_QUALIFIED, or JUNK |
since | ISO date — only leads updated after this moment. Use for incremental syncs |
limit | Max rows (default 1,000, max 10,000) |
Google Sheets
Paste into cell A1 of a sheet — the data refreshes automatically:
=IMPORTDATA("https://YOUR-INSTANCE/api/export/leads?key=YOUR-API-KEY&format=csv")Qualified leads only:
=IMPORTDATA("https://YOUR-INSTANCE/api/export/leads?key=YOUR-API-KEY&format=csv&status=QUALIFIED")These formulas are also pre-built (with your key) in Settings → Integrations & export.
Looker Studio
Use the CSV URL as a data source (via a Sheets bridge or a community CSV connector). The schema is deliberately flat and stable so charts don’t break.
What’s in the export
One row per lead:
| Column | What it is |
|---|---|
lead_code, org_slug | Lead reference (e.g. ACME-000123) and organisation |
name, company, email, phone | Contact details (email/phone normalised) |
bant_score | The 0–100 score from form/email/transcript answers |
ctm_score | The call score from call tracking (the column keeps its legacy header for downstream compatibility) |
mql_status | QUALIFIED, NOT_QUALIFIED, or JUNK |
lead_category, source_label, source | What kind of enquiry, and which door it came in through |
qualified_at, qualified_sent_at, sheet_sent_at | Qualification and hand-off timestamps |
assigned_to, override_reason | Review outcomes |
gclid, utm_source, utm_medium, utm_campaign | Attribution |
landing_url, page_url | First-touch and enquiry pages |
created_at, updated_at | Record timestamps |
Exporting from the app
The same export powers the Export button on the Leads page — no API key needed there; it uses your logged-in session and respects the filters you have applied.