CRM OAuth
Sync Pipedrive Data
to Flat Files
& Spreadsheets
Automatically sync your Pipedrive data to cloud storage and spreadsheets with Flatly's no-code, triggerless, turnkey integration service.
Historical & Dynamic Data
One-way Sync
For Non-technical Users
About the integration: Pipedrive is a sales-focused CRM that is an attractive option for its ease of use and various tools and integrations. Flatly integrates with Pipedrive's official APIs.
Available Datasets
Flatly can sync the following datasets from Pipedrive.
- Activities-AllUsers Enriched by ActivityFields
- Activities-AllUsers-Last X Date-ranged Enriched by ActivityFields
- Activities-SingleUser Enriched by ActivityFields
- ActivityFields
- Activity Types
- Activities+Details-AllUsers Combo Enriched by ActivityFields
- Activities+Details-AllUsers-Last X Combo Date-ranged Enriched by ActivityFields
- Activities+Details-SingleUser Combo Enriched by ActivityFields
- CallLogs
- Currencies
- Deals Enriched by DealFields
- Deals-Open Enriched by DealFields
- Deals-Won Enriched by DealFields
- Deals-Lost Enriched by DealFields
- Deals+Activities Combo Enriched by DealFields
- Deals-Open+Activities Combo Enriched by DealFields
- Deals+Details Combo Enriched by DealFields
- Deals+Stages Combo Enriched by DealFields
- Deals-Open+Details Combo Enriched by DealFields
- DealFields
- Deals+Files Attached Combo Enriched by DealFields
- Deals-Open+Files Attached Combo Enriched by DealFields
- Deals+Followers Combo Enriched by DealFields
- Deals-Open+Followers Combo Enriched by DealFields
- Deals+MailMessages Combo Enriched by DealFields
- Deals+MailMessages+Bodies Combo Enriched by DealFields
- Deals-Open+MailMessages Combo Enriched by DealFields
- Deals+Participants Combo Enriched by DealFields
- Deals-Open+Participants Combo Enriched by DealFields
- Deals+Permitted Users Combo Enriched by DealFields
- Deals-Open+Permitted Users Combo Enriched by DealFields
- Deals+Persons Combo Enriched by DealFields
- Deals-Open+Persons Combo Enriched by DealFields
- Deals+Products Combo Enriched by DealFields
- Deals-Open+Products Combo Enriched by DealFields
- Deals+Subscriptions+Details Combo Enriched by DealFields
- Deals+Subscriptions+Payments Combo Enriched by DealFields
- Deals+Updates Combo Enriched by DealFields
- Deals-Open+Updates Combo Enriched by DealFields
- Files
- Filters
- Global Messages
- Goals-All
- Goals-All+ResultsLast X days Combo Date-ranged
- Leads
- Notes
- Note Fields
- Organizations Enriched by OrganizationFields
- Organizations+Activities Combo Enriched by OrganizationFields
- Organizations+Deals Combo Enriched by OrganizationFields
- Organizations+Deals-Open Combo Enriched by OrganizationFields
- Organizations+Deals-Lost Combo Enriched by OrganizationFields
- Organizations+Details Combo Enriched by OrganizationFields
- OrganizationFields
- Organizations+Files Attached Combo Enriched by OrganizationFields
- Organizations+Followers Combo Enriched by OrganizationFields
- Organizations+Mail Messages Combo Enriched by OrganizationFields
- Organizations+Persons Combo Enriched by OrganizationFields
- Organizations+PermittedUsers Combo Enriched by OrganizationFields
- Organizations+Relationships Combo Enriched by OrganizationFields
- Organizations+Updates Combo Enriched by OrganizationFields
- Permission Sets
- PermissionSets+Assignments Combo
- Persons Enriched by PersonFields
- Persons+Activities Combo Enriched by PersonFields
- Persons+Deals-All Combo Enriched by PersonFields
- Persons+Deals-Open Combo Enriched by PersonFields
- Persons+Details Combo Enriched by PersonFields
- PersonFields
- Persons+Files Combo Enriched by PersonFields
- Persons+Followers Combo Enriched by PersonFields
- Persons+Messages Combo Enriched by PersonFields
- Persons+Products Combo Enriched by PersonFields
- Persons+Permitted Users Combo Enriched by PersonFields
- Persons+Updates Combo Enriched by PersonFields
- Pipelines
- Pipelines+Conversion Rates-All Combo
- Pipelines+Conversion Rates-Last X Combo Date-ranged
- Pipelines+Deals Combo
- Pipelines+MovementStats-All Combo
- Pipelines+MovementStats-Last X Combo Date-ranged
- Products Enriched by ProductFields
- Products+Deals-All Combo Enriched by ProductFields
- Products+Deals-Open Combo Enriched by ProductFields
- ProductFields
- Products+Files Attached Combo Enriched by ProductFields
- Products+Followers Combo Enriched by ProductFields
- Products+PermittedUsers Combo Enriched by ProductFields
- Recents-All
- Recents-Last X Date-ranged
- Stages
- Stages+Deals-SoleUser Combo
- Stages+Deals-Everyone Combo
- Users
- User Connections
- Users+Followers Combo
- Users+Permissions Combo
- Users+PermissionSetAssignments Combo
- Users+RoleAssignments Combo
- Users+RoleSettings Combo
- UserSettings
Send Pipedrive data to
Flatly can sync Pipedrive data to any of these destinations.
- Airtable Airtable
- Amazon S3 XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Azure Storage XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Box XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- CSV
- ChatGPT Apps
- Cloud Storage
- Dropbox XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Excel
- Excel Online XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- FTP XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google BigQuery NDJSON
- Google Cloud Storage XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google Drive Google Sheets (Parsed) Google Sheets (Raw) XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google Looker Studio
- Google Sheets Google Sheets (Parsed) Google Sheets (Raw) XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Looker NDJSON
- Markdown
- Microsoft Power BI
- OneDrive XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- OneDrive for Business XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- SFTP XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- SharePoint XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Smartsheet Smartsheet
- Zoho Sheet Zoho Sheet
Note: Some destinations are aliased, for intents and purposes they are functionally equivalent.
FAQ: Pipedrive
What is unique about this integration?
Flatly automatically enriches some fields in some Pipedrive data sets if they contain Custom Fields. Your resulting data will contain extra columns, created by Flatly, which are labeled by a combination of the suffix "flatly_enriched" and a prefix derived from your Custom Field's label. The values under these enriched columns will be useful and interpretable by human users, instead of being identifiers meant for computer programs. The original raw, unenriched values for these fields from Pipedrive's API are also included, and you can choose to filter them out or keep them using the Include Only Columns option in your job's Advanced Settings.