Hubspot Apollo Data Enrich

    Shared 10/5/2025

    148 views

    Visual Workflow

    JSON Code

    {
      "meta": {
        "instanceId": "f49bb574138dbca7eca7a10d8b87ca6e1fb30ed1bca739c6237603692c4ce3f6",
        "templateCredsSetupCompleted": true
      },
      "nodes": [
        {
          "id": "c2fa1a97-addd-4d4f-a737-92074f1817a6",
          "name": "When clicking ‘Execute workflow’",
          "type": "n8n-nodes-base.manualTrigger",
          "position": [
            -656,
            -64
          ],
          "parameters": {},
          "typeVersion": 1
        },
        {
          "id": "5e5330b8-2e90-443f-a18b-8c60abf0ebf1",
          "name": "Search contacts",
          "type": "n8n-nodes-base.hubspot",
          "position": [
            -256,
            -64
          ],
          "parameters": {
            "limit": 200,
            "operation": "search",
            "authentication": "appToken",
            "filterGroupsUi": {
              "filterGroupsValues": [
                {
                  "filtersUi": {
                    "filterValues": [
                      {
                        "value": "={{ $json.emailDomain }}",
                        "propertyName": "hs_email_domain|string"
                      }
                    ]
                  }
                }
              ]
            },
            "additionalFields": {
              "properties": [
                "firstname",
                "lastname",
                "email",
                "jobtitle",
                "linkedin_url"
              ]
            }
          },
          "credentials": {
            "hubspotAppToken": {
              "id": "VpdDWF6Ede6oXfEY",
              "name": "HubSpot account"
            }
          },
          "typeVersion": 2.2
        },
        {
          "id": "8346f1ed-8f9c-4bee-b891-4c7509f33557",
          "name": "If",
          "type": "n8n-nodes-base.if",
          "position": [
            -64,
            -64
          ],
          "parameters": {
            "options": {},
            "conditions": {
              "options": {
                "version": 2,
                "leftValue": "",
                "caseSensitive": true,
                "typeValidation": "strict"
              },
              "combinator": "or",
              "conditions": [
                {
                  "id": "3ce8a5f5-b372-4628-bd98-df2072ed6144",
                  "operator": {
                    "type": "string",
                    "operation": "empty",
                    "singleValue": true
                  },
                  "leftValue": "={{ $json.properties.firstname }}",
                  "rightValue": ""
                },
                {
                  "id": "30ef5987-520b-47e7-889e-687376658656",
                  "operator": {
                    "type": "string",
                    "operation": "empty",
                    "singleValue": true
                  },
                  "leftValue": "={{ $json.properties.lastname }}",
                  "rightValue": ""
                },
                {
                  "id": "43cea95d-69bf-4515-9e22-20e93b21f4b0",
                  "operator": {
                    "type": "string",
                    "operation": "empty",
                    "singleValue": true
                  },
                  "leftValue": "={{ $json.properties.jobtitle }}",
                  "rightValue": ""
                },
                {
                  "id": "0c7a0a31-9fdd-436a-9e4f-150d6cf50e7b",
                  "operator": {
                    "type": "string",
                    "operation": "empty",
                    "singleValue": true
                  },
                  "leftValue": "={{ $json.properties.linkedin_url }}",
                  "rightValue": ""
                }
              ]
            }
          },
          "typeVersion": 2.2
        },
        {
          "id": "1f8f95a2-e515-425b-98ab-ff355dbe167e",
          "name": "Get row(s)",
          "type": "n8n-nodes-base.dataTable",
          "position": [
            -448,
            -64
          ],
          "parameters": {
            "matchType": "allConditions",
            "operation": "get",
            "dataTableId": {
              "__rl": true,
              "mode": "list",
              "value": "jgngH5KKzbjFxRGG",
              "cachedResultUrl": "/projects/oAZ0uLvXATqQK43g/datatables/jgngH5KKzbjFxRGG",
              "cachedResultName": "domain data"
            }
          },
          "typeVersion": 1
        },
        {
          "id": "8b438be7-082e-4e47-8180-7ed257c3259a",
          "name": "HTTP Request1",
          "type": "n8n-nodes-base.httpRequest",
          "position": [
            192,
            -176
          ],
          "parameters": {
            "url": "https://api.apollo.io/api/v1/people/match",
            "method": "POST",
            "options": {
              "allowUnauthorizedCerts": true
            },
            "sendBody": true,
            "sendQuery": true,
            "sendHeaders": true,
            "bodyParameters": {
              "parameters": [
                {}
              ]
            },
            "queryParameters": {
              "parameters": [
                {
                  "name": "email",
                  "value": "={{ $json.properties.email }}"
                },
                {
                  "name": "reveal_personal_emails",
                  "value": "false"
                },
                {
                  "name": "reveal_phone_number",
                  "value": "false"
                }
              ]
            },
            "headerParameters": {
              "parameters": [
                {
                  "name": "Cache-Control",
                  "value": "no-cache"
                },
                {
                  "name": "accept",
                  "value": "application/json"
                },
                {
                  "name": "x-api-key",
                  "value": "FR-V6WduoFH4U-25dqJZPQ"
                }
              ]
            }
          },
          "typeVersion": 4.2
        },
        {
          "id": "295560aa-d4d9-4555-90dd-20ed7975121b",
          "name": "Create or update a contact1",
          "type": "n8n-nodes-base.hubspot",
          "position": [
            400,
            -176
          ],
          "parameters": {
            "email": "={{ $json.person.email }}",
            "options": {},
            "authentication": "appToken",
            "additionalFields": {
              "jobTitle": "={{ $json.person.title }}",
              "lastName": "={{ $json.person.last_name }}",
              "firstName": "={{ $json.person.first_name }}",
              "linkedinUrl": "={{ $json.person.linkedin_url }}"
            }
          },
          "credentials": {
            "hubspotAppToken": {
              "id": "VpdDWF6Ede6oXfEY",
              "name": "HubSpot account"
            }
          },
          "typeVersion": 2.2
        }
      ],
      "pinData": {},
      "connections": {
        "If": {
          "main": [
            [
              {
                "node": "HTTP Request1",
                "type": "main",
                "index": 0
              }
            ]
          ]
        },
        "Get row(s)": {
          "main": [
            [
              {
                "node": "Search contacts",
                "type": "main",
                "index": 0
              }
            ]
          ]
        },
        "HTTP Request1": {
          "main": [
            [
              {
                "node": "Create or update a contact1",
                "type": "main",
                "index": 0
              }
            ]
          ]
        },
        "Search contacts": {
          "main": [
            [
              {
                "node": "If",
                "type": "main",
                "index": 0
              }
            ]
          ]
        },
        "When clicking ‘Execute workflow’": {
          "main": [
            [
              {
                "node": "Get row(s)",
                "type": "main",
                "index": 0
              }
            ]
          ]
        }
      }
    }