Enrich CRM Contact Data with LinkedIn Profiles using GPT & Multi-CRM Support

Description

⚠️ DISCLAIMER: This workflow uses the AnySite LinkedIn community node, which is only available on self-hosted n8n instances. It will not work on n8n.cloud.

Overview
This n8n workflow automates the enrichment of CRM contact data with professional insights from LinkedIn profiles. The workflow integrates with both Pipedrive and HubSpot CRMs, finding LinkedIn profiles that match your contacts and updating your CRM with valuable information about their professional background and recent activities.

Key Features
Multi-CRM Support**: Works with both Pipedrive and HubSpot
AI-Powered Data Enrichment**: Uses an advanced AI agent to analyze and summarize professional information
Automated Triggers**: Activates when new contacts are added or when enrichment is requested
Comprehensive Profile Analysis**: Captures LinkedIn profile summaries and post activity

How It Works

Triggers
The workflow activates in three scenarios:
When a new contact is created in CRM
When a contact is updated in CRM with an enrichment flag

LinkedIn Data Collection Process
Email Lookup: First tries to find the LinkedIn profile using the contact's email
Advanced Search: If email lookup fails, uses name and company details to find potential matches
Profile Analysis: Collects comprehensive profile information
Post Analysis: Gathers and analyzes the contact's recent LinkedIn activity

CRM Updates
The workflow updates your CRM with:
LinkedIn profile URL
Professional summary (skills, experience, background)
Analysis of recent LinkedIn posts and activity

Setup Instructions

Requirements
Self-hosted n8n instance with the HDW LinkedIn community node installed
API access to OpenAI (for GPT-4o)
Pipedrive and/or HubSpot account
AnySite API key https://AnySite.io

Installation Steps
Install the HDW LinkedIn Node:
npm install n8n-nodes-hdw
Follow the detailed instructions at: https://www.npmjs.com/package/n8n-nodes-hdw

Configure Credentials:
OpenAI: Add your OpenAI API key
Pipedrive: Connect your Pipedrive account (if using)
HubSpot: Connect your HubSpot account (if using)
AnySite LinkedIn: Add your API key from https://AnySite.io

CRM Custom Fields Setup:

For Pipedrive:
Go to Settings → Data Fields → Contact Fields → + Add Field
Create the following custom fields:
LinkedIn Profile: Field type - Large text
Profile Summary: Field type - Large text
LinkedIn Posts Summary: Field type - Large text
Need Enrichment: Field type - Single option (Yes/No)

Detailed instructions for creating custom fields in Pipedrive:
https://support.pipedrive.com/en/article/custom-fields

For HubSpot:
Go to Settings → Properties → Create property
Create the following properties for Contact object:
linkedin_url: Field type - Single-line text
profile_summary: Field type - Multi-line text
linkedin_posts_summary: Field type - Multi-line text
need_enrichment: Field type - Checkbox (Boolean)

Detailed instructions for creating properties in HubSpot:
https://knowledge.hubspot.com/properties/create-and-edit-properties

Import the Workflow:
Import the "HDW_CRM_Enrichment.json" file into your n8n instance

Activate Webhooks:
Enable the webhook triggers for your CRM to ensure the workflow activates correctly

Customization Options

AI Agent Prompts
You can modify the system prompts in the "Data Enrichment AI Agent" nodes to:
Change the focus of profile analysis
Adjust the tone and detail level of summaries
Customize what information is extracted from posts

CRM Field Mapping
The workflow is pre-configured to update specific custom fields in Pipedrive and HubSpot. Update the field/property mappings in:
"Update data in Pipedrive" nodes
"Update data in HubSpot" node

Troubleshooting

Common Issues
LinkedIn Profile Not Found**: Check if the contact's email is their work email; consider adjusting the search parameters
Webhook Not Triggering**: Verify webhook configuration in your CRM
Missing Custom Fields**: Ensure all required custom fields are created in your CRM with correct names

Rate Limits
Be aware of LinkedIn API rate limits (managed by AnySite LinkedIn node)
Consider implementing delays if processing large batches of contacts

Best Practices
Use enrichment flags to selectively update contacts rather than enriching all contacts
Review and clean contact data in your CRM before enrichment
Periodically review the AI-generated summaries to ensure quality and relevance