Question 1

Which Pipedrive objects can I write to?

Accepted Answer

Deals, persons and organizations. Everything else is source only, which covers activities and activity types, leads with their labels and sources, pipelines, projects, stages, users, and the field metadata objects. Those can all be read into your warehouse for analysis, but they are not destinations. In practice the three writable objects cover what teams want from this direction, which is keeping records current and scored.

Question 2

How do custom fields work when writing to Pipedrive?

Accepted Answer

They are discovered for you. Polytomic reads Pipedrive's object specific field metadata and exposes custom fields alongside the standard ones, with only those Pipedrive marks writable available as mapping targets. Internally the Pipedrive field hash is used rather than the label, so renaming a custom field in Pipedrive does not break an existing mapping, which is a genuinely useful property when several people administer the account.

Question 3

How are dropdown and compound field values formatted?

Accepted Answer

As Pipedrive's own identifiers rather than labels. Enum and reference values use numeric option or object IDs, and a multi option field expects an array of those numeric IDs, so your model needs to carry the ID rather than the display text. Compound fields such as monetary values, date ranges and addresses are represented as objects. It is worth pulling the field metadata into ClickHouse first so you can join labels to IDs when building the model.

Question 4

Can I clear a custom field by sending an empty value?

Accepted Answer

Not on this path today, and it is worth knowing before you design around it. Nulls and empty arrays are omitted from the write body rather than sent, so a field cannot be emptied by mapping a null to it. If clearing values matters for your workflow, the practical approach is to write a sentinel value your team recognises, or handle the clearing in Pipedrive itself rather than expecting the sync to do it.

Question 5

What does this give a sales team?

Accepted Answer

A CRM that reflects what the product data actually says. Usage trends, health scores and account level signals get built in the warehouse from several systems, and without reverse ETL they stay there. Writing them onto the deal or organization means the person deciding who to call sees the same numbers as the dashboard, without anyone maintaining a parallel spreadsheet that drifts within a fortnight.

Sync ClickHouse to Pipedrive

Sync ClickHouse to Pipedrive with Polytomic

Deals, persons, organizations

Custom fields discovered

Renames do not break it

Or sync Pipedrive to ClickHouse

Trusted by businesses worldwide

Step-by-step integration guide

Connect ClickHouse in Polytomic

Connect Pipedrive in Polytomic

Create a sync between ClickHouse and Pipedrive

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect ClickHouse with Pipedrive?