Pipedrive to OneDrive for Business
Automatically sync your Pipedrive data into OneDrive for Business with Flatly's no-code, triggerless, turnkey integration service.
Source: Pipedrive
Pipedrive is a sales-focused CRM that is an attractive option for its ease of use and various tools and integrations.
Auth: OAuth
Available datasets
- 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
Destination: OneDrive for Business
PowerBI reads CSV or XLSX files directly from OneDrive for Business.
Auth: OAuth
Supported file formats
- XLSX (Parsed)
- XLSX (Raw)
- CSV (Parsed)
- CSV (Raw)
- NDJSON
- Markdown (Table)
- Markdown (Key-Value)
How it works
- 1
Connect Pipedrive
Authenticate Pipedrive (OAuth) and OneDrive for Business (OAuth) in the Flatly dashboard. You only have to do this once.
- 2
Choose your datasets
Pick which Pipedrive datasets to sync and set your sync frequency. The frequencies available to you depend on your Flatly plan.
- 3
Data lands in OneDrive for Business
Flatly uploads your Pipedrive data to OneDrive for Business automatically and refreshes it based on your sync frequency.
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.
“The interface is unbelievable. Flatly is so easy to use. After years of struggling with Zapier this is life changing.”
Full data refresh
Maintain up-to-date flat files when any nested or bundled data changes in your source app.
Connection Management
Manage multiple tenants, with connection health monitoring.
Bulk Job Management
Control multiple jobs at the same time, with live progress monitoring.
Merged datasets
Export left-joined combo objects like deals+products.
Write options
Refresh one flat file or create a stack of timestamped versions.
Filterability
Include only the columns or views essential for your reporting.
Notifications
Get alerts about your syncs via email, webhooks or Slack notifications.
Logging
Access up to one thousand log entries for your sync operations.
Custom Field Enrichment
Get useful values in your data instead of identifiers or definitions.
Metadata Attachment
See file statistics alongside your flat files to keep track of their origins.
Dark UI Mode
Reduce eye strain and save energy by using our built in dark mode.
Programmatic Jobs
Queue jobs by making API calls or agent requests.
Time Stamp Enrichment
Get human-readable dates and times from UNIX timestamps.
High frequency
10-minute refresh cycles mean your data store is near real-time.
High capacity
Reliably flatten billions of cells to CSV files without hiccups.
Advanced Security
Two-factor authentication and Destination Lock controls.
Stripe-powered Billing
Reliable payments provider with automatic, familiar invoicing and 1% of Sales to Stripe Climate.
Mobile access
Manage your sync operations from your phone if you are traveling.
Connect Pipedrive to OneDrive for Business
Get started today with a 14-day free trial. No credit card required. Both human and AI support are available.