Pipedrive to Google Sheets automatically
Automatically export Pipedrive to Google Sheets: deals, people, organizations, and custom fields. No code.
LightLead exports Pipedrive deals to Google Sheets: title, value, currency, status (open/won/lost), pipeline, stage, and dates. The linked person and organization attach to each deal, and custom fields are available per object: deal.custom.*, person.custom.*, organization.custom.*.
Read more
What gets exported
- Deals: title, value, currency, status, pipeline_id, stage_id, add_time, won_time, lost_time
- Person: name, email, phone
- Organization: name, address
- Custom fields for deals, people, and organizations
- 17 base deal fields
Fields & metrics
- Entities: deal, person, organization
- Fields: deal.id, deal.title, deal.value, deal.currency, deal.status, deal.add_time, deal.won_time
- Custom fields: deal.custom.*, person.custom.*, organization.custom.*
- Metrics: deal.value (currency)
Auto-refresh
Reports refresh on a schedule — hourly, daily, or weekly. After pipeline or stage changes, re-run discovery; deleted stages are marked "unknown" and history is preserved.
Example sheet
| Deal | Status | Pipeline | Value | Person | Won |
|---|---|---|---|---|---|
| Deal 1 | won | Main | $2,400 | Ivan P. | 2026-07-21 |
| Deal 2 | open | Main | $900 | Maria K. | — |
The values illustrate the report structure. Real data comes from your Pipedrive account.
Setup in 4 steps
- Start with LightLead and go to Integrations → CRM → Pipedrive
- Authorize via OAuth (API v2 for core access)
- LightLead discovers pipelines, stages, and custom fields
- Add a report: fields, filters, and schedule
Specifics & limitations
- Queued rate limiter: 4 requests per second with 250 ms jitter
- Maximum page size of 500 records; exceeding the page budget returns provider_error
- More than 100 custom fields can slow sync
- Pipelines/stages come from API v2, field discovery from v1
- Read-only: no writes, real-time, files, notes, or tasks
Who it fits
- Sales teams: pipelines, stages, and deal velocity
- Agencies: multi-client reports across pipelines
- E-commerce: linking deal value to ads
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 Pipedrive to Google Sheets?
Start with LightLead, authorize via OAuth, and pick the source. Data appears in the sheet after you add a report.
What is deal.custom.*?
Custom fields on Pipedrive deals. LightLead discovers them via three separate endpoints — dealFields, personFields, and organizationFields.
Can I export people and organizations?
Yes — person and organization attach to a deal via person_id and organization_id.
How often do reports update?
On a schedule: hourly, daily, or weekly.
Why does provider_error occur?
When the cursor pagination page budget is exhausted — narrow the selection with filters.
Full Pipedrive connector reference: https://docs.lightlead.space/integrations/crm/pipedrive/
Read next
Start with LightLead free
Create your first report — spend, leads, and attribution in Google Sheets.
Create your first report