CRM

Approved-Merge Executor: Collapse HubSpot Records into the Salesforce Survivor

When a reviewer marks a queued duplicate pair as approved in Coda, this workflow merges the agreed fields into the Salesforce survivor record, archives the HubSpot loser.

CategoryCRM
Enginesim
Difficultyadvanced
Triggerwebhook
Steps5
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerCoda row marked Approved (webhook)HTTP webhook
  • LogicValidate both records exist and resolution map is complete
  • ActionApply winning field values to Salesforce survivorSalesforce
  • ActionArchive HubSpot duplicate with merged-into referenceHubSpotHubSpot
  • OutputPost field-diff audit trail to SlackSlack

What it does

This is the execution half of a human-in-the-loop dedupe process. Once a reviewer approves a merge in the Coda queue, it copies the chosen field values into the designated survivor company in Salesforce, marks the duplicate in HubSpot as merged-and-archived, and records exactly what changed.

When to use it

Pair this with a detection workflow that fills the review queue. Use it when you have decided Salesforce is your system of record post-acquisition and want approved merges applied consistently, with a clean audit log instead of manual copy-paste.

How it works

  1. 1A webhook fires when a Coda row's status flips to Approved, carrying the survivor ID, loser ID, and the field-resolution map.
  2. 2A logic step validates that both records still exist and the resolution map is complete.
  3. 3The flow updates the Salesforce survivor company with the approved winning field values.
  4. 4It updates the HubSpot duplicate to set a merged-into reference and archive flag so it stops appearing in active views.
  5. 5A Slack message posts the before-and-after field diff to the audit channel for traceability.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect CodaDocs, packs, automations.
  2. 2
    Connect SalesforceAccounts, opportunities, cases.
  3. 3
    Connect HubSpotCRM, deals, marketing, support.
  4. 4
    Connect SlackChannels, DMs, threads, mentions.
  5. 5
    Connect HTTP webhookTrigger any URL on agent actions.
  6. 6
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  7. 7
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  8. 8
    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.