CRM

Bidirectional HubSpot ↔ Attio Contact Reconciliation with Merge Audit

On a schedule, matches contacts across HubSpot and Attio by email, reconciles conflicting field values using last-modified-wins, writes the merged record back to both CRMs.

CategoryCRM
Enginesim
Difficultyadvanced
Triggerschedule
Steps7
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerNightly schedule fires
  • ActionFetch changed contacts from HubSpotHubSpotHubSpot
  • ActionFetch changed contacts from AttioAttio
  • LogicJoin on email; split matched vs single-system
  • LogicResolve field conflicts (last-modified-wins)
  • ActionWrite reconciled record to both CRMsAttio
  • OutputLog merges to Postgres audit + Slack summaryPostgreSQLPostgres

What it does

Keeps your HubSpot and Attio contact records in sync by finding the same person in both systems and reconciling field-level differences. When the same email exists in both CRMs with conflicting values (different title, phone, company), it applies a last-modified-wins rule, pushes the winning value back to both, and records exactly what changed and why in an immutable Postgres audit table.

When to use it

When sales runs in HubSpot and the ops/data team works in Attio, and the two drift apart. Run it nightly so neither system holds stale truth and you keep a defensible trail of every automated merge.

How it works

  1. 1A nightly schedule fires the run.
  2. 2Pull the recently-changed contact set from HubSpot and from Attio.
  3. 3Join the two sets on normalized email; branch records into matched, HubSpot-only, and Attio-only.
  4. 4For each matched pair, compare fields and pick the most-recently-modified value per field.
  5. 5Write the reconciled record back to HubSpot and to Attio.
  6. 6Insert one audit row per field change (old value, new value, source-of-truth, timestamp) into Postgres.
  7. 7Post a run summary to Slack.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect HubSpotCRM, deals, marketing, support.
  2. 2
    Connect AttioReal-time CRM with structured data + powerful views.
  3. 3
    Connect PostgresAny Postgres URL — query, write, migrate.
  4. 4
    Connect SlackChannels, DMs, threads, mentions.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.