January 22, 2026

ProspectPro to HubSpot, clean company records

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

You push a new prospect into HubSpot… and later you find three versions of the same company. Different names, different domains, a salesperson assigned to the wrong record. It’s messy, and it keeps happening.

This is the kind of HubSpot dedupe sync headache that hits marketing ops first, but sales managers and small agency teams feel it too. Clean data is supposed to be the easy part. In reality, it turns into hours of “wait, which record is the real one?” every week.

This workflow syncs ProspectPro prospects into HubSpot as company records, checks for matches (ID first, then domain), and tags the result back in ProspectPro so duplicates and repeat failures don’t keep slipping through.

How This Automation Works

Here’s the complete workflow you’ll be setting up:

n8n Workflow Template: ProspectPro to HubSpot, clean company records

Click to explore

flowchart LR

    subgraph sg0["Subflow Trigger Start Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "Subflow Trigger Start", pos: "b", h: 48 }
        n1@{ icon: "mdi:cog", form: "rounded", label: "Fetch Prospect Record", pos: "b", h: 48 }
        n2@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Proceed Check", pos: "b", h: 48 }
        n3@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Validate No Prior Errors", pos: "b", h: 48 }
        n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Lookup Company by Prospect ID"]
        n5@{ icon: "mdi:swap-horizontal", form: "rounded", label: "ID Match Found?", pos: "b", h: 48 }
        n6["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Lookup Company by Domain"]
        n7@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Domain Available?", pos: "b", h: 48 }
        n8@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Domain Match Found?", pos: "b", h: 48 }
        n9["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Select HubSpot Company"]
        n10["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/hubspot.svg' width='40' height='40' /></div><br/>Create HubSpot Company"]
        n11["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/hubspot.svg' width='40' height='40' /></div><br/>Modify HubSpot Company"]
        n12@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Update Completed?", pos: "b", h: 48 }
        n13@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Creation Completed?", pos: "b", h: 48 }
        n14["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Mark Tag Hubspot Failed"]
        n15["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Mark Tag Hubspot Synced"]
        n16["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Return Success Result"]
        n17@{ icon: "mdi:cog", form: "rounded", label: "Apply Tags Success", pos: "b", h: 48 }
        n18["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Return Failure Result"]
        n19@{ icon: "mdi:cog", form: "rounded", label: "Apply Tags Failure", pos: "b", h: 48 }
        n2 --> n4
        n2 --> n14
        n7 --> n6
        n7 --> n10
        n5 --> n9
        n5 --> n7
        n1 --> n3
        n1 --> n18
        n9 --> n11
        n10 --> n13
        n10 --> n14
        n8 --> n9
        n8 --> n10
        n11 --> n12
        n11 --> n14
        n19 --> n18
        n12 --> n15
        n12 --> n14
        n3 --> n2
        n3 --> n18
        n13 --> n15
        n13 --> n14
        n17 --> n16
        n15 --> n17
        n6 --> n8
        n14 --> n19
        n0 --> n1
        n4 --> n5
    end

    subgraph sg1["Utility: ProspectPro Trigger Sample Flow"]
        direction LR
        n20@{ icon: "mdi:play-circle", form: "rounded", label: "Utility: ProspectPro Trigger..", pos: "b", h: 48 }
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n0,n20 trigger
    class n2,n3,n5,n7,n8,n12,n13 decision
    class n4,n6 api
    class n9,n14,n15,n16,n18 code
    classDef customIcon fill:none,stroke:none
    class n4,n6,n9,n10,n11,n14,n15,n16,n18 customIcon

Why This Matters: Duplicate companies quietly break your CRM

Duplicate company records aren’t just “annoying.” They distort pipeline reporting, confuse routing, and make automation rules fire on the wrong data. One person updates a company’s industry field, another edits a different duplicate, and now your segmentation is unreliable. Worse, you usually notice too late: after a rep follows up with the wrong “latest” details, or after a campaign excludes the account you actually wanted. The real cost is the mental load. Everyone starts second-guessing the CRM, which makes adoption drop.

It adds up fast. Here’s where it breaks down.

Manual imports and copy-paste updates create small inconsistencies that turn into full duplicates within a week.
Matching “by name” is fragile, so companies like “ACME BV” and “ACME B.V.” slip through as separate records.
When an integration fails once, teams often retry the same prospect repeatedly, which can create even more junk data.
Without clear success and failure tags, no one knows what synced, what didn’t, or what needs manual cleanup.

What You’ll Build: ProspectPro → HubSpot company sync with smart matching

This n8n workflow takes a ProspectPro prospect record and turns it into a clean, repeatable HubSpot company sync. It starts by pulling the ProspectPro prospect details, then checks whether the prospect has been flagged as a prior sync failure (so you don’t loop forever). Next, it searches HubSpot for an existing company using the ProspectPro ID property you store in HubSpot. If a match exists, it updates that company with the latest ProspectPro data. If there’s no ID match, it tries again using the company’s domain, and only creates a new company when neither match is found. Finally, it tags the ProspectPro record as synced or failed, so the next run is predictable.

The workflow begins when a ProspectPro event triggers it (or when you call it as a sub-workflow). It then runs a two-pass identity check in HubSpot: ID first, domain second. From there, HubSpot gets an update or a create, and ProspectPro gets the “HubspotSynced” or “HubspotSyncFailed” tag as the receipt.

What You’re Building

What Gets Automated

What You’ll Achieve

Pulling the latest ProspectPro prospect record into n8n.
Searching HubSpot companies by ProspectPro ID first, then by domain.
Updating an existing HubSpot company or creating a new one automatically.
Tagging the ProspectPro record as success or failure for clean re-runs.

Most teams get about 2–5 hours back per week from less CRM cleanup.
Fewer duplicate companies, because matching is deterministic (ID/domain), not fuzzy.
A clearer audit trail in ProspectPro, so you can answer “did this sync?” instantly.
Safer retries since failed items are tagged and can be handled intentionally.
Cleaner HubSpot automation downstream, like lists, workflows, and routing rules.

Expected Results

Say you bring in 20 new prospects a day from ProspectPro. Manually checking HubSpot for duplicates (ID check, then domain check, then deciding “update vs create”) is easily about 5 minutes per prospect, so roughly 1.5–2 hours daily. With this workflow, the “human time” is basically just reviewing the occasional HubspotSyncFailed tag, maybe 10 minutes a day. The rest runs on autopilot, and the CRM stays consistent as volume grows.

Before You Start

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
ProspectPro for prospect source data and tagging
HubSpot to create/update company records
ProspectPro API credentials (get them from your ProspectPro account)

Skill level: Intermediate. You’ll connect accounts, map a few fields, and add one HubSpot property for the ProspectPro ID.

Want someone to build this for you? Talk to an automation expert (free 15-minute consultation).

Step by Step

A ProspectPro trigger (or sub-workflow call) starts the sync. You can run it from a “new website visitor” style event, or you can call it from another n8n workflow when a prospect reaches a certain stage.

The workflow fetches the full prospect record and checks if it should proceed. It validates that the input is usable, and it also checks for prior error tags so you don’t keep reprocessing the same problematic record.

HubSpot matching happens in two passes. First it looks up a HubSpot company by the ProspectPro ID (most reliable). If that fails, it checks if a domain exists, then searches HubSpot by domain, which catches cases where the ID was never stored but the company is already in HubSpot.

HubSpot is updated or a new company is created, then ProspectPro gets the result tag. Successful updates and creates are marked “HubspotSynced.” Failures are marked “HubspotSyncFailed,” which makes it obvious what needs attention next.

You can easily modify the HubSpot field mapping to match your pipeline rules based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Subflow Trigger

Set up the subflow entry point so this workflow can be executed with a prospect ID.

Add and open Subflow Trigger Start.
In Workflow Inputs, confirm a single input named id is present.
Keep the trigger connected to Fetch Prospect Record as shown in the canvas.
(Optional utility) If you use Utility: ProspectPro Trigger Sample for testing, set not_tags to ={{ ["HubspotSyncFailed"] }} and keep the polling mode set to everyMinute.

Credential Required: Connect your prospectproApi credentials (for Utility: ProspectPro Trigger Sample, if you enable it).

Step 2: Connect ProspectPro and Fetch the Prospect

Retrieve the full ProspectPro record using the incoming ID before any HubSpot actions run.

Open Fetch Prospect Record.
Set Operation to get.
Set ID to ={{ $json.id }}.

Credential Required: Connect your prospectproApi credentials.

Step 3: Set Up Validation and Routing Logic

Use the IF nodes to prevent reruns, confirm required data, and route between update vs. create paths.

In Validate No Prior Errors, keep the boolean check that blocks prospects already tagged with failure: ={{ !!$json.tags.includes("HubspotSyncFailed") }}.
In Proceed Check, keep both requirements: ={{ !!$json.domain }} and ={{ !!$json.id }}.
In ID Match Found? and Domain Match Found?, keep ={{ $json.total > 0 }} to route to update when a company exists.
In Domain Available?, keep ={{ !!$('Fetch Prospect Record').item.json.domain }} to decide whether to search by domain or create immediately.
In Update Completed? and Creation Completed?, keep the success check ={{ !!$json.companyId }} to branch into success or failure tagging.

The workflow contains multiple IF nodes (7 total). Keep their expressions aligned with the ProspectPro payload and HubSpot responses to avoid misrouting updates vs. creates.

Step 4: Configure HubSpot Search, Create, and Update

Search for existing HubSpot companies by ProspectPro ID or domain, then create or update accordingly.

Open Lookup Company by Prospect ID and confirm URL is https://api.hubapi.com/crm/v3/objects/companies/search, Method is POST, and JSON Body includes the ProspectPro ID filter with {{ $json.id }}.
Open Lookup Company by Domain and confirm the same URL/Method, with the domain filter set to {{ $('Fetch Prospect Record').item.json.domain }}.
In Select HubSpot Company, keep the code that selects the first result: const hsCompany = $json.results[0]; return { ...hsCompany };.
In Create HubSpot Company, set Name to ={{ $('Fetch Prospect Record').item.json.name }} and keep the additional fields mapping (e.g., companyDomainName to ={{ $('Fetch Prospect Record').item.json.domain || undefined }} and custom properties prospectpro_id and kvk).
In Modify HubSpot Company, set Company ID to ={{ $json.id }} and update fields like companyDomainName with ={{ $json.properties.domain || $('Fetch Prospect Record').item.json.domain || undefined }}.

Credential Required: Connect your hubspotOAuth2Api credentials (for Lookup Company by Prospect ID, Lookup Company by Domain, Create HubSpot Company, and Modify HubSpot Company).

⚠️ Common Pitfall: If HubSpot custom properties prospectpro_id or kvk do not exist, creation and update calls can fail. Create these properties in HubSpot before testing.

Step 5: Configure Tagging and Result Outputs

Apply success or failure tags back to ProspectPro and return a simple result object.

Keep the code in Mark Tag Hubspot Synced and Mark Tag Hubspot Failed to append HubspotSynced or HubspotSyncFailed to the tag list.
In Apply Tags Success and Apply Tags Failure, set ID to ={{ $json.id }} and Operation to patch, with tags set to ={{ $json.tags }}.
Leave Return Success Result and Return Failure Result as simple outputs: return { result: true }; and return { result: false };.

Credential Required: Connect your prospectproApi credentials (for Apply Tags Success and Apply Tags Failure).

Step 6: Test and Activate Your Workflow

Run a manual test to confirm records are created/updated and tags are applied correctly.

Click Execute Workflow and provide a sample id input in Subflow Trigger Start (e.g., from pinned data).
Verify Fetch Prospect Record returns a prospect with domain and id.
Confirm the workflow branches through either Modify HubSpot Company or Create HubSpot Company based on matches.
Check that Apply Tags Success or Apply Tags Failure runs, and review the output from Return Success Result or Return Failure Result.
When successful, toggle the workflow to Active for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Troubleshooting Tips

HubSpot credentials can expire or need specific permissions. If things break, check your HubSpot private app/OAuth scopes and the n8n credential connection status first.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
ProspectPro tagging depends on the community node and valid API credentials. If tags aren’t applying, verify the ProspectPro API key and confirm the record ID exists in the ProspectPro environment you’re hitting.

Quick Answers

What’s the setup time for this HubSpot dedupe sync automation?

About 30 minutes if your ProspectPro and HubSpot credentials are ready.

Is coding required for this dedupe sync automation?

No. You will mainly connect accounts and map fields. The workflow already includes the logic for selecting the right HubSpot company.

Is n8n free to use for this HubSpot dedupe sync workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in HubSpot and ProspectPro plan/API limits (most teams stay within normal usage).

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I modify this HubSpot dedupe sync workflow for different use cases?

Yes, and you probably should. You can change the matching rules in the HubSpot lookup HTTP Request steps, and adjust which fields get written in the “Create HubSpot Company” and “Modify HubSpot Company” nodes. Common tweaks include mapping extra firmographics, changing which domain field you trust, and adding a Slack alert on the “HubspotSyncFailed” branch.

Why is my HubSpot connection failing in this workflow?

Usually it’s an expired OAuth connection or missing scopes for companies read/write. Reconnect HubSpot in n8n and confirm the app has permission to search and upsert companies. If it fails only during busy periods, you may be hitting rate limits, so spacing executions or batching lookups helps. Also confirm you created the HubSpot property for the ProspectPro ID and you’re querying the correct internal name.

What volume can this HubSpot dedupe sync workflow process?

On a typical small-team setup, hundreds of prospects per day is fine.

Is this HubSpot dedupe sync automation better than using Zapier or Make?

Often, yes. This workflow relies on conditional logic (ID match, then domain match, then choose update vs create, then tag back), and frankly that branching gets awkward and expensive in tools that price by tasks. n8n is comfortable here because you can add “guardrails” like the prior-error check and structured failure paths without turning the scenario into spaghetti. Zapier or Make can still work if you keep it simple, but you’ll usually end up compromising on matching or on error handling. If your CRM is core revenue infrastructure, those compromises hurt later. Talk to an automation expert if you’re not sure which fits.

Once this is running, HubSpot stops filling up with “almost the same company” records. Your team gets cleaner routing, cleaner reporting, and fewer awkward double-contacts.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"meta": {
"instanceId": "8f9d4c0f12ebcbae6e5c9a1a88d6f0d4c8c931205a786ae6edbaa78c0a772e05",
"templateId": null,
"templateCredsSetupCompleted": null
},
"name": "Automated Prospect Sync to HubSpot",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-8471",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 1680,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "94bc6245-cee2-4028-89d3-9496ac683eb1",
"name": "Subflow Trigger Start",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
60,
120
],
"parameters": {
"workflowInputs": {
"values": [
{
"name": "id"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "75e8d8ed-b1b7-4ea8-ac9c-99a7abf9e6c0",
"name": "Fetch Prospect Record",
"type": "@bedrijfsdatanl/n8n-nodes-prospectpro.prospectpro",
"onError": "continueErrorOutput",
"position": [
360,
160
],
"parameters": {
"id": "={{ $json.id }}",
"operation": "get",
"requestOptions": []
},
"credentials": {
"prospectproApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1,
"alwaysOutputData": false
},
{
"id": "dd7d4d4f-93f6-4cff-82bc-9378e1cc6680",
"name": "Proceed Check",
"type": "n8n-nodes-base.if",
"position": [
940,
170
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "15bc7f88-124b-4ace-9b9b-d211b83dd524",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ !!$json.domain }}",
"rightValue": ""
},
{
"id": "2ab83e0c-e511-4b0a-bb97-c76198116e07",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ !!$json.id }}",
"rightValue": ""
},
{
"id": "7dc88f3a-2aa2-4e17-9b67-1298ba06c27b",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "dcc5f1cf-8aca-46c9-b5c3-ff1bfcc306be",
"name": "Validate No Prior Errors",
"type": "n8n-nodes-base.if",
"position": [
640,
130
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "c3696744-f335-4b14-852c-76a7659f3303",
"operator": {
"type": "boolean",
"operation": "false",
"singleValue": true
},
"leftValue": "={{ !!$json.tags.includes(\"HubspotSyncFailed\") }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "5faecf8e-4528-47a8-ad8c-39757fe32a25",
"name": "Lookup Company by Prospect ID",
"type": "n8n-nodes-base.httpRequest",
"position": [
1260,
140
],
"parameters": {
"url": "https://api.hubapi.com/crm/v3/objects/companies/search",
"method": "POST",
"options": [],
"jsonBody": "={\n  \"properties\": [\"prospectpro_id\", \"domain\", \"name\", \"lifecyclestage\"],\n  \"filterGroups\": [\n    {\n      \"filters\": [\n        {\n          \"propertyName\": \"prospectpro_id\",\n          \"operator\": \"EQ\",\n          \"value\": \"{{ $json.id }}\"\n        }\n      ]\n    }\n  ]\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "hubspotOAuth2Api"
},
"credentials": {
"hubspotOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.2
},
{
"id": "51dc7ba9-c557-4629-9842-d8e71548cea0",
"name": "ID Match Found?",
"type": "n8n-nodes-base.if",
"position": [
1260,
360
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "da65345b-7d49-4576-bbaf-ab23f7e1cdb8",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.total > 0 }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "08d8eaa0-c8bf-48da-8af4-d11b4470a3a4",
"name": "Lookup Company by Domain",
"type": "n8n-nodes-base.httpRequest",
"position": [
700,
360
],
"parameters": {
"url": "https://api.hubapi.com/crm/v3/objects/companies/search",
"method": "POST",
"options": [],
"jsonBody": "={\n  \"properties\": [\"prospectpro_id\", \"domain\", \"name\"],\n  \"filterGroups\": [\n    {\n      \"filters\": [\n        {\n          \"propertyName\": \"domain\",\n          \"operator\": \"EQ\",\n          \"value\": \"{{ $('Fetch Prospect Record').item.json.domain }}\"\n        }\n      ]\n    }\n  ]\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "hubspotOAuth2Api"
},
"credentials": {
"hubspotOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.2
},
{
"id": "35e41246-74d2-4460-8642-659b3ed1c8a5",
"name": "Domain Available?",
"type": "n8n-nodes-base.if",
"position": [
980,
340
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b3a44f7a-7b55-49b0-90e5-c3abb0c9c815",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ !!$('Fetch Prospect Record').item.json.domain }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "a42147a2-e19a-4718-adba-3585c8295684",
"name": "Domain Match Found?",
"type": "n8n-nodes-base.if",
"position": [
420,
340
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "da65345b-7d49-4576-bbaf-ab23f7e1cdb8",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.total > 0 }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "8e579c2a-10c4-4e0b-9563-d286d2ec6aab",
"name": "Select HubSpot Company",
"type": "n8n-nodes-base.code",
"position": [
0,
360
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "const hsCompany = $json.results[0];\n\nreturn { ...hsCompany };"
},
"typeVersion": 2
},
{
"id": "5849f892-d2d7-4a8b-b92e-00e7e731005e",
"name": "Create HubSpot Company",
"type": "n8n-nodes-base.hubspot",
"onError": "continueErrorOutput",
"position": [
720,
480
],
"parameters": {
"name": "={{ $('Fetch Prospect Record').item.json.name }}",
"resource": "company",
"authentication": "oAuth2",
"additionalFields": {
"city": "={{ $('Fetch Prospect Record').item.json.city || undefined }}",
"postalCode": "={{ $('Fetch Prospect Record').item.json.postcode || undefined }}",
"websiteUrl": "={{ $('Fetch Prospect Record').item.json.url || undefined }}",
"phoneNumber": "={{ $('Fetch Prospect Record').item.json.phone_international || undefined }}",
"annualRevenue": "={{ $('Fetch Prospect Record').item.json.revenue || undefined }}",
"countryRegion": "={{ $('Fetch Prospect Record').item.json.country_code || undefined }}",
"streetAddress": "={{ $('Fetch Prospect Record').item.json.address || undefined }}",
"companyDomainName": "={{ $('Fetch Prospect Record').item.json.domain || undefined }}",
"numberOfEmployees": "={{ $('Fetch Prospect Record').item.json.employees || undefined }}",
"customPropertiesUi": {
"customPropertiesValues": [
{
"value": "={{ $('Fetch Prospect Record').item.json.id }}",
"property": "prospectpro_id"
},
{
"value": "={{ $('Fetch Prospect Record').item.json.coc || undefined }}",
"property": "kvk"
}
]
},
"linkedInCompanyPage": "={{ $('Fetch Prospect Record').item.json.linkedin_link || undefined }}"
}
},
"credentials": {
"hubspotOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "f30d8294-8aa0-4b8f-835b-bc311f47d9ed",
"name": "Modify HubSpot Company",
"type": "n8n-nodes-base.hubspot",
"onError": "continueErrorOutput",
"position": [
40,
560
],
"parameters": {
"resource": "company",
"companyId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.id }}"
},
"operation": "update",
"updateFields": {
"companyDomainName": "={{ $json.properties.domain || $('Fetch Prospect Record').item.json.domain || undefined }}",
"customPropertiesUi": {
"customPropertiesValues": [
{
"value": "={{ $('Fetch Prospect Record').item.json.id }}",
"property": "prospectpro_id"
},
{
"value": "={{ $('Fetch Prospect Record').item.json.coc }}",
"property": "kvk"
}
]
}
},
"authentication": "oAuth2"
},
"credentials": {
"hubspotOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "6374e07e-0713-4ba3-9dc3-f42e93ddf93a",
"name": "Update Completed?",
"type": "n8n-nodes-base.if",
"position": [
360,
580
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "239351e0-f10a-4dc2-a47f-b5e0978bcda4",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ !!$json.companyId }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "4acc3119-52f3-4be2-8c85-0e2f3d7b5e46",
"name": "Creation Completed?",
"type": "n8n-nodes-base.if",
"position": [
420,
480
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "239351e0-f10a-4dc2-a47f-b5e0978bcda4",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ !!$json.companyId }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "94b0ece2-3883-4212-9e4f-4c187900853a",
"name": "Mark Tag Hubspot Failed",
"type": "n8n-nodes-base.code",
"position": [
980,
720
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "const prospect = $('Fetch Prospect Record').item.json;\nconst tags = prospect.tags.length > 0 ? prospect.tags.split('|') : [];\n\ntags.push(\"HubspotSyncFailed\");\n\nreturn {\n  ...prospect,\n  tags\n};"
},
"typeVersion": 2
},
{
"id": "d4a76b65-379c-41eb-bf63-081bd80550ca",
"name": "Mark Tag Hubspot Synced",
"type": "n8n-nodes-base.code",
"position": [
660,
560
],
"parameters": {
"jsCode": "const prospect = $('Fetch Prospect Record').first().json;\nconst tags = prospect.tags.length > 0 ? prospect.tags.split('|') : [];\n\ntags.push(\"HubspotSynced\");\n\nreturn [{ json: { \n  ...prospect,\n  tags  \n} }];"
},
"typeVersion": 2
},
{
"id": "a3101321-8e84-4d13-b044-871b15270dc6",
"name": "Return Success Result",
"type": "n8n-nodes-base.code",
"position": [
1280,
560
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "return { result: true };"
},
"typeVersion": 2
},
{
"id": "89d38963-c663-4cb8-88dd-9ee0d27fcb43",
"name": "Apply Tags Success",
"type": "@bedrijfsdatanl/n8n-nodes-prospectpro.prospectpro",
"onError": "continueRegularOutput",
"position": [
980,
580
],
"parameters": {
"id": "={{ $json.id }}",
"operation": "patch",
"updateOptions": {
"tags": "={{ $json.tags }}"
},
"requestOptions": []
},
"credentials": {
"prospectproApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "3a7604d2-33d1-4952-92da-5295fcf21ac9",
"name": "Return Failure Result",
"type": "n8n-nodes-base.code",
"position": [
1580,
720
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "return { result: false };"
},
"typeVersion": 2
},
{
"id": "242c5a58-9892-46f2-b0e5-42211b4abb25",
"name": "Apply Tags Failure",
"type": "@bedrijfsdatanl/n8n-nodes-prospectpro.prospectpro",
"onError": "continueRegularOutput",
"position": [
1280,
740
],
"parameters": {
"id": "={{ $json.id }}",
"operation": "patch",
"updateOptions": {
"tags": "={{ $json.tags }}"
},
"requestOptions": []
},
"credentials": {
"prospectproApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "aa057f0a-e376-4994-81a2-5eedf4dc3dbe",
"name": "Utility: ProspectPro Trigger Sample",
"type": "@bedrijfsdatanl/n8n-nodes-prospectpro.prospectproTrigger",
"position": [
80,
820
],
"parameters": {
"label": -1,
"not_tags": "={{ [\"HubspotSyncFailed\"] }}",
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
}
},
"credentials": {
"prospectproApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
}
],
"active": false,
"pinData": {
"Subflow Trigger Start": [
{
"json": {
"id": "270391080000"
}
}
]
},
"settings": {
"callerPolicy": "workflowsFromSameOwner",
"errorWorkflow": "Mf7KVxCmCYTFgFAd",
"executionOrder": "v1"
},
"versionId": null,
"connections": {
"Proceed Check": {
"main": [
[
{
"node": "Lookup Company by Prospect ID",
"type": "main",
"index": 0
}
],
[
{
"node": "Mark Tag Hubspot Failed",
"type": "main",
"index": 0
}
]
]
},
"Domain Available?": {
"main": [
[
{
"node": "Lookup Company by Domain",
"type": "main",
"index": 0
}
],
[
{
"node": "Create HubSpot Company",
"type": "main",
"index": 0
}
]
]
},
"ID Match Found?": {
"main": [
[
{
"node": "Select HubSpot Company",
"type": "main",
"index": 0
}
],
[
{
"node": "Domain Available?",
"type": "main",
"index": 0
}
]
]
},
"Fetch Prospect Record": {
"main": [
[
{
"node": "Validate No Prior Errors",
"type": "main",
"index": 0
}
],
[
{
"node": "Return Failure Result",
"type": "main",
"index": 0
}
]
]
},
"Select HubSpot Company": {
"main": [
[
{
"node": "Modify HubSpot Company",
"type": "main",
"index": 0
}
]
]
},
"Create HubSpot Company": {
"main": [
[
{
"node": "Creation Completed?",
"type": "main",
"index": 0
}
],
[
{
"node": "Mark Tag Hubspot Failed",
"type": "main",
"index": 0
}
]
]
},
"Domain Match Found?": {
"main": [
[
{
"node": "Select HubSpot Company",
"type": "main",
"index": 0
}
],
[
{
"node": "Create HubSpot Company",
"type": "main",
"index": 0
}
]
]
},
"Modify HubSpot Company": {
"main": [
[
{
"node": "Update Completed?",
"type": "main",
"index": 0
}
],
[
{
"node": "Mark Tag Hubspot Failed",
"type": "main",
"index": 0
}
]
]
},
"Apply Tags Failure": {
"main": [
[
{
"node": "Return Failure Result",
"type": "main",
"index": 0
}
]
]
},
"Update Completed?": {
"main": [
[
{
"node": "Mark Tag Hubspot Synced",
"type": "main",
"index": 0
}
],
[
{
"node": "Mark Tag Hubspot Failed",
"type": "main",
"index": 0
}
]
]
},
"Validate No Prior Errors": {
"main": [
[
{
"node": "Proceed Check",
"type": "main",
"index": 0
}
],
[
{
"node": "Return Failure Result",
"type": "main",
"index": 0
}
]
]
},
"Creation Completed?": {
"main": [
[
{
"node": "Mark Tag Hubspot Synced",
"type": "main",
"index": 0
}
],
[
{
"node": "Mark Tag Hubspot Failed",
"type": "main",
"index": 0
}
]
]
},
"Apply Tags Success": {
"main": [
[
{
"node": "Return Success Result",
"type": "main",
"index": 0
}
]
]
},
"Mark Tag Hubspot Synced": {
"main": [
[
{
"node": "Apply Tags Success",
"type": "main",
"index": 0
}
]
]
},
"Lookup Company by Domain": {
"main": [
[
{
"node": "Domain Match Found?",
"type": "main",
"index": 0
}
]
]
},
"Mark Tag Hubspot Failed": {
"main": [
[
{
"node": "Apply Tags Failure",
"type": "main",
"index": 0
}
]
]
},
"Subflow Trigger Start": {
"main": [
[
{
"node": "Fetch Prospect Record",
"type": "main",
"index": 0
}
]
]
},
"Lookup Company by Prospect ID": {
"main": [
[
{
"node": "ID Match Found?",
"type": "main",
"index": 0
}
]
]
}
}
}