Pipedrive
Pipedrive is a sales CRM and pipeline management platform.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | ACTIVITY, ACTIVITY_TYPE, DEAL, NOTE, ORGANIZATION, PERSON, PIPELINE, PRODUCT, STAGE, and USER tables. |
| History mode | check | DEAL_HISTORY, LEAD_HISORY, and LEAD_LABEL_HISTORY tables. |
| Custom data | check | |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Supported deployment models
We support the SaaS Deployment model for the connector.
Setup guide
Follow our step-by-step Pipedrive setup guide to connect Pipedrive with your destination using Fivetran connectors.
Sync overview
We sync mail_messages associated with a given deals endpoint.
Due to Pipedrive email privacy policy:
- Unless the authenticated Pipedrive user has Admin access, we only sync email messages associated with the authenticated user;
- Through the
dealsendpoint, we don't have access to emails owned by a different user if their email privacy settings are set to Private.
Pipedrive does not include milliseconds in its timestamps. If a deal in Pipedrive is updated multiple times within 1 second, all the modifications have the same timestamp. Due to this limitation with Pipedrive, if a deal is updated multiple times within 1 second, we sync only the latest modification while performing historical syncs for the DEAL_HISTORY table.
For more information, see the Pipedrive documentation.
Automatic reimport of tables
The Recents endpoint returns data only from the last 30 days, leading to data gaps if a connection is paused or tables remain deselected for over 30 days. To maintain data integrity, we re-import the following tables if they are selected again or the connection is unpaused:
ACTIVITYACTIVITY_TYPEFILENOTEORGANIZATIONPERSONPIPELINESTAGEDEALPRODUCTFILTERUSER
Schema information
This schema applies to all Pipedrive connections.