CRM migration
Field-level mapping, validation, and rollback between Workbooks and Pipedrive. We move data and schema; workflows are rebuilt natively in Pipedrive.
Workbooks
Source
Pipedrive
Destination
Compatibility
7 of 12
objects map 1:1 between Workbooks and Pipedrive.
Complexity
BStandard
Timeline
2-4 weeks
Overview
Workbooks and Pipedrive share the same core account-contact-opportunity model, but the terminology and relationship structures differ enough to require careful mapping. Workbooks Organisations and People map directly to Pipedrive Organizations and People, and Workbooks Opportunities map to Pipedrive Deals with pipeline and stage mapping resolved upfront. Cases are migrated as custom activity threads or into Pipedrive's Projects object depending on the destination tier. We handle Workbooks custom fields—including file-upload fields and iFrame URL fields—by mapping their stored values into equivalent Pipedrive custom fields, and we flag the absence of Quotation, Invoice, and Order objects if the source subscription is on the CRM or CRM Pro tier rather than Business. Workbooks Workflows and Automation rules do not migrate as code; we deliver a written inventory for the admin to rebuild in Pipedrive's automation tools.
Every standard and custom field arrives verified.
AI proposes the map; you confirm before any record moves.
Parent–child, lookups, and ownership stay linked.
Calls, emails, meetings — with original timestamps.
Documents, uploads, and inline notes move with the record.
Why teams make this switch
Leaving
What's pushing teams away
Choosing
What's pulling them in
Object mapping
Each row shows how a Workbooks object lands in Pipedrive, including any object-level transformations, lookup resolution, or schema-design dependencies.
Typical mapping — final map is confirmed during the sample migration step.
Workbooks
Organisation
Pipedrive
Organization
1:1Workbooks Organisation records map directly to Pipedrive Organization. The Organisation Name maps to Organization name, and the Organisation's primary address fields map to address line 1, line 2, city, state, postal code, and country fields in Pipedrive. Industry classification, website, and annual revenue map to equivalent Organization fields. Any Organisation-level custom fields migrate as Organization custom fields created in Pipedrive before import. The Organisation-to-Person linkage is preserved as a Pipedrive Organization-Person relationship.
Workbooks
Person
Pipedrive
Person
1:1Workbooks Person records map to Pipedrive Person. The Person-Organisation link is preserved by resolving the Organisation lookup and creating a Pipedrive Person-Organization relationship during import. Name, email, phone, title, and address map directly. Marketing opt-in status from Workbooks Person maps to Pipedrive's email_status_cf or a custom field. Any Person-level custom fields require pre-creation in Pipedrive before migration.
Workbooks
Opportunity
Pipedrive
Deal
1:1Workbooks Opportunities map to Pipedrive Deals with the pipeline and stage assignment resolved during scoping. The Workbooks pipeline name becomes a Pipedrive pipeline, and each Workbooks stage maps to a Pipedrive stage in the same sequence. Stage probabilities migrate as percentage values against the corresponding Pipedrive stage. Expected Close Date and Opportunity value migrate as close_date and value fields. Owner assignment resolves by email match against Pipedrive Users.
Workbooks
Opportunity Stage
Pipedrive
Deal Stage + Pipeline
lossyEach Workbooks pipeline becomes a Pipedrive pipeline. Stage names and probabilities migrate to corresponding Pipedrive stage entries within the pipeline. If the customer has multiple pipelines in Workbooks (available on Business tier), each pipeline becomes a separate Pipedrive pipeline with its own stage set. The pipeline order and default flag are set during Pipedrive configuration before deals are imported.
Workbooks
Quotation
Pipedrive
Deal (with Products)
1:manyWorkbooks Quotations contain a header (related Organisation, owner, validity date) and line items (product, quantity, unit price, discount). The quotation header migrates as a Pipedrive Deal with a validity date stored in a custom field. Quotation line items migrate as Deal Products linked to the Deal. If the customer uses Pipedrive's Products feature, we create Product2 records and link them via Deal Product entries. Quotation status (Draft, Sent, Accepted, Lost) maps to a custom field or deal label. Note: Quotation and Invoice objects exist only on Workbooks CRM Business and Business Pro tiers; we confirm the source tier during scoping.
Workbooks
Invoice
Pipedrive
Note (with attachment)
1:1Workbooks Invoices (Business tier and above) contain header data, line items, payment status, and optional credit note associations. Pipedrive has no native Invoice object. We migrate invoice data as a Note attached to the related Organization or Deal, with invoice number, date, amount, status, and line item summary stored in structured fields within the Note body. PDF invoices stored as attachments against the Workbooks Invoice are downloaded separately and reattached to the Pipedrive Note as file attachments. Payment status is preserved in a custom field on the Note.
Workbooks
Sales Order / Purchase Order
Pipedrive
Note (with attachment)
1:1Workbooks Sales Orders and Purchase Orders are tied to an Organisation and quotation. Pipedrive has no native order object. We extract order header data (order number, date, status, related Organisation) and line items as a structured Note attached to the relevant Organisation. Any attached documents are downloaded and reattached to the Pipedrive Note. Order-to-invoice linkage is preserved as a text reference within the Note body. Customers requiring full order management in Pipedrive should consider the Pipedrive Invoices add-on or a third-party integration post-migration.
Workbooks
Case
Pipedrive
Activity or Note
lossyWorkbooks Cases do not have a direct Pipedrive equivalent. Pipedrive has no native Cases object on any standard tier. We evaluate two migration paths during scoping: (1) Cases map to Pipedrive Activities (task type with subject, description, and due date) linked to the Organisation or Person, with case status and priority stored in custom fields; (2) Cases map to Notes attached to the Organisation with a structured template for case number, status, priority, and description. The customer's Pipedrive tier and use case determine which path applies. Pipedrive's Projects object is also available on Premium tier and can serve as a case tracking container if the customer licenses that tier.
Workbooks
Lead
Pipedrive
Lead or Person
1:manyWorkbooks Lead records hold pre-conversion prospect data with lead source, status, rating, and assigned owner. We map Leads to Pipedrive's Lead inbox or directly to Person records depending on whether the customer intends to use Pipedrive's Lead qualification flow. If Pipedrive's Lead feature is active, Leads import as Pipedrive Leads with source and status preserved. If Leads are fully qualified in Workbooks before migration, they map to Person records with Organisation linkage. The original Workbooks Lead status is preserved in a custom field for audit.
Workbooks
Activity
Pipedrive
Activity
1:1Workbooks Activities (calls, emails, meetings, tasks) linked to an Organisation or Person migrate to Pipedrive Activities. Activity type maps to Pipedrive activity_type (call, email, meeting, task). Date, duration, subject, and description migrate directly. Owner assignment resolves by email against Pipedrive Users. Activity association links to the migrated Organisation or Person ID. Call disposition and duration are stored in custom fields if the customer requires that metadata in Pipedrive.
Workbooks
Campaign
Pipedrive
Label or Note
1:1Workbooks Campaigns track marketing initiatives with associated leads and persons. Pipedrive has no native Campaign object. Campaign name, status, and start/end dates migrate as a Label on the associated Person records, or as a Note on the Organisation. Campaign membership data (which persons and leads were in which campaign) is preserved by applying the campaign name as a label to the relevant Person records. Marketing attribution data is preserved in a custom field on each Person.
Workbooks
Custom Field
Pipedrive
Custom Field
lossyWorkbooks custom fields of types text, number, date, dropdown, and checkbox map to equivalent Pipedrive custom field types. We request a read-only Workbooks login and enumerate every custom field per object type before writing the migration spec, since Workbooks deployments vary significantly in which custom fields exist and what they are called. iFrame fields export as URL strings and map to Pipedrive text fields. File-upload fields require a separate binary extraction step with files reattached to the destination record. Multi-select checkbox fields in Workbooks map to Pipedrive multi-checkbox custom fields.
| Workbooks | Pipedrive | Compatibility | |
|---|---|---|---|
| Organisation | Organization1:1 | Fully supported | |
| Person | Person1:1 | Fully supported | |
| Opportunity | Deal1:1 | Fully supported | |
| Opportunity Stage | Deal Stage + Pipelinelossy | Fully supported | |
| Quotation | Deal (with Products)1:many | Fully supported | |
| Invoice | Note (with attachment)1:1 | Fully supported | |
| Sales Order / Purchase Order | Note (with attachment)1:1 | Fully supported | |
| Case | Activity or Notelossy | Fully supported | |
| Lead | Lead or Person1:many | Fully supported | |
| Activity | Activity1:1 | Fully supported | |
| Campaign | Label or Note1:1 | Fully supported | |
| Custom Field | Custom Fieldlossy | Fully supported |
Gotchas + challenges
Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.
Workbooks gotchas
Record save latency on large datasets
Custom Fields require manual field-level mapping
Quotation and Invoice exports require Business tier
iFrame custom fields export as URL strings only
Pipedrive gotchas
Custom field hash keys differ per account
Export access gated by visibility groups
Token-based API rate limits since December 2024
Sequences and Automations not exposed via REST API
Cost escalates via workflow caps and add-ons
Pair-specific challenges
Migration approach
Tier confirmation and scoping
We confirm the Workbooks subscription tier to determine which objects are present in the export: CRM and CRM Pro tiers contain Organisations, People, Opportunities, Cases, Activities, Leads, and Campaigns; Business and Business Pro tiers additionally include Quotations, Invoices, Sales Orders, and Purchase Orders. We request a read-only Workbooks login and enumerate every custom field per object type. We also count records per object, identify any iFrame or file-upload fields, and review the pipeline and stage structure used in Workbooks to prepare the Pipedrive pipeline configuration before any data moves.
Data export and deduplication
We run Workbooks data exports using the MS Excel export layer for bulk record extraction, supplemented by the API for real-time validation of record counts. We export in batches of 5,000 records to avoid triggering the save-latency throttling that Workbooks exhibits under bulk operations. During export, we run deduplication checks on Organisations (by company name and domain) and People (by email address) to prevent duplicate records from entering Pipedrive. We flag any records with missing required fields and resolve them with the customer's admin before import.
Pipedrive schema configuration
We configure Pipedrive before migration begins. This includes creating all custom fields (matching Workbooks field types to Pipedrive field types), setting up the Pipedrive pipeline and stages to match the Workbooks pipeline structure, configuring deal probability percentages per stage, and creating any required Labels for Campaign data. We create Organisation records first, then Person records with Organisation linkage, then Deal records with pipeline, stage, and owner assignment resolved. If Cases are migrating, we set up either Activity templates or Note structures depending on the customer's chosen approach.
Quotation and invoice transform
If Workbooks Business tier objects (Quotations, Invoices, Orders) are present, we transform them during this phase. Quotation headers become Deals with Products; quotation line items become Deal Products. Invoice and Order data becomes structured Notes attached to the relevant Organisation or Deal, with PDF attachments downloaded separately and re-uploaded. Multi-currency values are normalized using the exchange rate and currency approach agreed during scoping. This phase runs as a separate batch with its own reconciliation report before the main migration phase.
Production migration and reconciliation
We run production migration in dependency order: Organisations first, then People with Organisation linkage resolved, then Deals with pipeline, stage, owner, and Organisation linkage, then Activities, then Cases, then Leads or Persons, then Campaign labels, then custom field values on all objects. Each phase emits a row-count reconciliation report comparing the Workbooks export count to the Pipedrive import count. We investigate any discrepancy above 0.5 percent before proceeding to the next phase. Pipedrive's API rate limits are managed with exponential backoff and batch chunking to avoid 429 errors during import.
Cutover, validation, and workflow inventory delivery
We freeze Workbooks write access during cutover, run a final delta migration of any records modified during the migration window, then enable Pipedrive as the system of record. We deliver a validation report showing record counts, spot-check comparisons of 25-50 records against the Workbooks source, and attachment confirmation for all migrated files. We deliver the Workflow and Automation inventory document to the customer's admin team for rebuild in Pipedrive Smart Campaigns. We offer a one-week hypercare window for reconciliation issues reported in the first days of live use.
Platform deep dives
Workbooks
Source
Strengths
Weaknesses
Pipedrive
Destination
Strengths
Weaknesses
Complexity grading
Standard CRM migration. 3 of 8 objects need a mapping; the rest are 1:1.
Overall complexity
Standard migration
Derived from compatibility, mapping clarity, API constraints, and data volume across Workbooks and Pipedrive.
Object compatibility
3 of 8 objects need a mapping; the rest are 1:1.
Field mapping clarity
Field mapping is derived from defaults — final spec confirmed during the sample migration.
Timeline complexity
8-object category — typical timelines run 2–7 days end-to-end.
API constraints
Workbooks: Workbooks imposes rate limits and result-set size caps. Excessive calls are throttled by being delayed or redirected via a delaying URL; clients are expected to follow these redirects as normal operation. Specific request-per-minute thresholds are not publicly published..
Data volume sensitivity
Workbooks exposes a bulk API — large-volume migrations stream efficiently.
Estimator
Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.
Step 1
Pick a category, then your source and destination platforms.
Category
FAQ
Answers to the questions buyers ask most during Workbooks to Pipedrive migration scoping. Not seeing yours? Book a call.
Walk through your Workbooks to Pipedrive migration with a real engineer — 30 minutes, free, written quote within 24 hours.
Book a free 30 minute consultationAdjacent paths
Other ways to leave Workbooks
Other ways to arrive at Pipedrive
Ready when you are
Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.