Bitrix24 to Google Sheets automatically
Automatically export Bitrix24 to Google Sheets: deals, leads, pipelines, UTM, and UF_CRM_ fields. No code.
LightLead exports Bitrix24 to Google Sheets: deals and leads with native field names (ID, TITLE, OPPORTUNITY, STAGE_ID, ASSIGNED_BY_ID), pipelines and stages, CF_ and UF_CRM_ custom fields, plus built-in UTM on deals. Multiple portals connect as separate sources.
Read more
What gets exported
- Deals: ID, TITLE, OPPORTUNITY, CURRENCY_ID, STAGE_ID, ASSIGNED_BY_ID, DATE_CREATE
- Pre-conversion leads: STATUS_ID, amount, UTM
- Pipelines (categories) and their stages
- Built-in deal UTM tags
- Custom fields: new CF_ and legacy UF_CRM_ formats
Fields & metrics
- Entities: deal, lead
- Fields: ID, TITLE, DATE_CREATE, OPPORTUNITY, CURRENCY_ID, STAGE_ID, STATUS_ID, ASSIGNED_BY_ID, utm_*
- Metrics: OPPORTUNITY (currency), deals_count, leads_count
- Custom field types: text, number, date, select, checkbox, phone, email; files are not supported
Auto-refresh
Reports refresh on a schedule — hourly, daily, or weekly. After pipeline changes, re-run discovery; deleted pipelines preserve history.
Example sheet
| Deal | Stage | Pipeline | Amount | Owner | Created |
|---|---|---|---|---|---|
| Deal 1 | Won | Sales pipeline | $3,000 | Ivan P. | 2026-07-19 |
| Deal 2 | In progress | Sales pipeline | $960 | Olga S. | 2026-07-27 |
The values illustrate the report structure. Real data comes from your Bitrix24 portal.
Setup in 4 steps
- Start with LightLead and go to Integrations → CRM → Bitrix24
- Enter your portal address and authorize
- LightLead discovers pipelines, stages, and custom fields
- Add a report: fields, filters, and schedule
Specifics & limitations
- Limit of 2 requests per second per webhook, batches of up to 50 methods
- UTM tags are only available on Bitrix24 CRM+ plans
- Custom fields: new CF_ and legacy UF_CRM_ formats
- Read-only: no writes, real-time, files, notes, or tasks
- Large result sets can return payload_too_large — narrow the period or add filters
Who it fits
- Bitrix24 teams: pipelines, stages, and deal amounts
- Sales departments: Ads → CRM attribution via built-in UTM
- Multi-portal agencies: separate sources per portal
Pricing
LightLead starts free (1 Meta Ads account + Instagram Insights). CRM and Ads → CRM attribution start with the Solo plan at $19/month; multiple CRMs come with Agency plans from $49/month.
FAQ
How do I connect Bitrix24 to Google Sheets?
Start with LightLead, enter your portal address, and authorize. Data appears in the sheet after you add a report.
What do CF_ and UF_CRM_ mean?
Bitrix24 custom field formats. LightLead discovers both — the new CF_ and the legacy UF_CRM_ — and lets you use them.
Can I export UTM?
Yes — Bitrix24 stores UTM on deals. Note that built-in UTM requires a CRM+ plan.
How often do reports update?
On a schedule: hourly, daily, or weekly.
Why does payload too large occur?
The API cannot return a very large result at once — narrow the period or add filters.
Full Bitrix24 connector reference: https://docs.lightlead.space/integrations/crm/bitrix24/
Read next
Start with LightLead free
Create your first report — spend, leads, and attribution in Google Sheets.
Create your first report