🚀 Enrich CRM Leads with LinkedIn Company Data Using AI
Who's it for
Sales teams, marketers, and business development professionals who need to automatically enrich their CRM records with detailed company information from LinkedIn profiles. Perfect for anyone doing B2B outreach who wants to personalize their messaging at scale.
What it does
This workflow transforms bare-bones lead records into rich, personalized prospect profiles by:
- Automatically scraping LinkedIn company profiles
- Using AI (GPT-4) to extract key business intelligence
- Generating 15+ email-ready personalization variables
- Updating your CRM with structured, actionable data
The workflow pulls company overviews, products/services, funding information, recent posts, and converts everything into natural-language variables that can be dropped directly into your outreach templates.
How it works
- Trigger: Workflow starts when a new lead is added to Airtable (or on schedule)
- Fetch: Retrieves the lead record containing the LinkedIn company URL
- Scrape: Pulls the raw HTML from the company's LinkedIn profile
- Clean: Strips HTML tags and formats content for AI processing
- Analyze: GPT-4 extracts structured company intelligence (overview, products, market presence, recent posts)
- Transform: Converts analysis into 15+ email-ready variables with natural phrasing
- Update: Writes enriched data back to your CRM
Setup Requirements
- Airtable account (free tier works fine)
- OpenAI API key (GPT-4o-mini recommended for cost-effectiveness)
- LinkedIn company URLs stored in your CRM
- 5 minutes for initial configuration
How to set up
-
Configure Airtable Connection
- Replace
YOUR_AIRTABLE_BASE_ID
with your base ID
- Replace
YOUR_TABLE_ID
with your leads table ID
- Ensure your table has a "LinkedIn Organization URL" field
- Add your Airtable API credentials
-
Add OpenAI Credentials
- Click on both OpenAI nodes
- Add your OpenAI API key
- GPT-4o-mini is recommended (cost-effective and fast)
-
Set Up Trigger
- Add a trigger node (Schedule, Webhook, or Airtable trigger)
- Configure to run when new leads are added or on a daily schedule
-
Test the Workflow
- Add a test lead with a LinkedIn company URL
- Execute