Automatically enrich prospect data from HubSpot using Explorium and create leads in Salesforce This n8n workflow streamlines the process of enriching prospect information by automatically pulling data from HubSpot, processing it through Explorium's AI-powered tools, and creating new leads in Salesforce with enhanced prospect details. Credentials Required To use this workflow, set up the following credentials in your n8n environment: HubSpot - Type: App Token (or OAuth2 for broader compatibility) - Used for: triggering on new contacts, fetching contact data Explorium API - Type: Generic Header Auth - Header: Authorization - Value: Bearer YOURAPIKEY Get explorium api key Salesforce - Type: OAuth2 or Username/Password - Used for: creating new lead records Go to Settings → Credentials, create these three credentials, and assign them in the respective nodes before running the workflow. Workflow Overview Node 1: HubSpot Trigger This node listens for real-time events from the connected HubSpot account. Once triggered, the node passes metadata about the event to the next step in the flow. Node 2: HubSpot This node fetches contact details from HubSpot after the trigger event. - Credential: Connected using a HubSpot App Token - Resource: Contact - Operation: Get Contact - Return All: Disabled This node retrieves the full contact details needed for further processing and enrichment. Node 3: Match prospect This node sends each contact's data to Explorium's AI-powered prospect matching API in real time. - Method: POST - Endpoint: - Authentication: Generic Header Auth (using a configured credential) - Headers: Content-Type: application/json The request body is dynamically built from contact data, typically including: fullname, companyname, email, phonenumber, linkedin. These fields are matched against Explorium's intelligence graph to return enriched or validated profiles. Response Output: totalmatches, matchedprospects, and a prospectid. Each response is used downstream to enrich, validate, or create lead information. Node 4: Filter This node filters the output from the Match prospect step to ensure that only valid, matched results continue in the flow. Only records that contain at least one matched prospect with a non-null prospectid are passed forward. Status: Currently deactivated (as shown by the "Deactivate" label) Node 5: Extract Prospect IDs from Matched Results This node extracts all valid prospectid values from previously matched prospects and compiles them into a flat array. It loops over all matched items, extracts each prospectid from the matchedprospects array and returns a single object with an array of all prospectids. Node 6: Explorium Enrich Contacts Information This node performs bulk enrichment of contacts by querying Explorium with a list of matched prospectids. Node Configuration: - Method: POST - Endpoint: - Authentication: Header Auth (using saved credentials) - Headers: "Content-Type": "application/json", "Accept": "application/json" Returns enriched contact information, such as: - emails: professional/personal email addresses - phonenumbers: mobile and work numbers - professionsemail, professionalemailstatus, mobilephone Node 7: Explorium Enrich Profiles This additional enrichment node provides supplementary contact data enhancement, running in parallel with the primary enrichment process. Node 8: Merge This node combines multiple data streams from the parallel enrichment processes into a single output, allowing you to consolidate data from different Explorium enrichment endpoints. The "combine" setting indicates it will merge the incoming data streams rather than overwriting them. Node 9: Code - flatten This custom code node processes and transforms the merged enrichment data before creating the Salesforce lead. It can be used to: - Flatten nested data structures - Format data according to Salesforce field requirements - Apply business logic or data validation - Map Explorium fields to Salesforce lead properties - Handle data type conversions Node 10: Salesforce This final node creates new leads in Salesforce using the enriched data returned by Explorium. - Credential: Salesforce OAuth2 or Username/Password - Resource: Lead - Operation: Create Lead The node creates new lead records with enriched information including contact details, company information, and professional data obtained through the Explorium enrichment process. Workflow Flow Summary 1. Trigger: HubSpot webhook triggers on new/updated contacts 2. Fetch: Retrieve contact details from HubSpot 3. Match: Find prospect matches using Explorium 4. Filter: Keep only successfully matched prospects (currently deactivated) 5. Extract: Compile prospect IDs for bulk enrichment 6. Enrich: Parallel enrichment of contact information through multiple Explorium endpoints 7. Merge: Combine enrichment results 8. Transform: Flatten and prepare data for Salesforce (Code node) 9. Create: Create new lead records in Salesforce This workflow ensures comprehensive data enrichment while maintaining data quality and providing a seamless integration between HubSpot prospect data and Salesforce lead creation. The parallel enrichment structure maximizes data collection efficiency before creating high-quality leads in your CRM system.
