Kommo to Google Sheets automatically
Automatically export Kommo to Google Sheets: deals, contacts, companies, custom fields, and UTM. API v4 — no code.
LightLead exports Kommo (formerly amoCRM) deals to Google Sheets: title, value, status, pipeline, owner, and dates. The first contact and company attach to each deal, and custom fields are available as cf_{id}. Connect via your account subdomain and OAuth on API v4.
Read more
What gets exported
- Deals: id, title, value, status, pipeline, created and closed dates
- Responsible manager per deal
- First contact: name, phone, email
- First company: name
- Deal custom fields as cf_{id}
Fields & metrics
- Entities: lead, contact, company, pipeline
- Fields: lead_id, lead_name, lead_price, lead_status, lead_pipeline, lead_created_at, lead_closed_at, lead_responsible
- Metrics: lead_price (currency), 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 or stage changes, re-run discovery; history for deleted stages is preserved.
Example sheet
| Deal | Status | Pipeline | Value | Owner | Created |
|---|---|---|---|---|---|
| Lead 1 | Won | Main | $1,450 | Ivan P. | 2026-07-20 |
| Lead 2 | In progress | Main | $540 | Maria K. | 2026-07-28 |
The values illustrate the report structure. Real data comes from your Kommo account.
Setup in 4 steps
- Start with LightLead and go to Integrations → CRM → Kommo
- Enter your account subdomain and authorize via OAuth
- LightLead discovers pipelines, statuses, and custom fields
- Add a report: fields, filters, and schedule
Specifics & limitations
- API limit of 7 requests per second; maximum page size of 250 records
- No built-in deal-level UTM — use custom fields or notes
- UTM values and field codes are case-sensitive
- Read-only: no CRM writes, real-time, files, notes, or tasks
- Contacts and companies attach as the first record from deal includes
Who it fits
- Sales: linking deals to ads via Ads → CRM attribution
- Customer-success teams: statuses and pipelines by manager
- E-commerce: deal values and conversions in one sheet
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 Kommo to Google Sheets?
Start with LightLead, enter your Kommo subdomain, and authorize via OAuth. Data appears after you add a report.
What is cf_{id}?
Custom fields on Kommo deals. LightLead discovers them automatically and lets you use them in reports, filters, and groupings.
Can I export UTM tags?
Yes, if they are configured as custom fields or stored in notes — Kommo has no standard deal-level UTM fields.
How often do reports update?
On a schedule: hourly, daily, or weekly.
What permissions does LightLead need in Kommo?
Read access (crm_read) via API v4 is enough.
Full Kommo connector reference: https://docs.lightlead.space/integrations/crm/kommo/
Read next
Start with LightLead free
Create your first report — spend, leads, and attribution in Google Sheets.
Create your first report