Comprehensive Contact Enrichment with Apollo, LinkedIn, GPT-4o for HubSpot

This workflow transforms basic contact details (name and email) into comprehensive HubSpot records. It starts by normalizing and deduplicating emails via a JavaScript code node. Next, it queries Apollo.io's /people/match endpoint to find matching persons, skipping if none found. It then fetches up to 3 recent original LinkedIn posts from the last 30 days using RapidAPI's Fresh-LinkedIn-Profile-Data service.

The core intelligence comes from an AI summary chain powered by three LangChain nodes with OpenAI's GPT-4o-mini model. This chain, including structured and auto-fixing parsers, generates a strict JSON output with key details like job title, location, post summaries, and more. Finally, it upserts the enriched data into HubSpot, mapping standard fields plus five custom properties, with retry logic for error-prone steps.

Benefits include significant time savings for sales teams, improved lead quality, and automated executive record freshness. Use cases: SDRs enriching inbound demo requests, RevOps maintaining clean CRM data, and marketers creating segmented email lists. Requires API keys for Apollo, RapidAPI, OpenAI, and HubSpot OAuth2; sticky notes annotate the canvas for easy setup.