Automate LinkedIn Profile Enrichment from Airtable

Stop manually copying LinkedIn profile data into your Airtable database. This n8n workflow automatically enriches your LinkedIn profile URLs with complete professional data, transforming empty records into rich contact profiles in minutes.

What this workflow does

This automation connects your Airtable database directly to Apify's LinkedIn Profile Scraper, creating a seamless data enrichment pipeline. The workflow queries your Airtable base for records matching your filter criteria (like empty "First name" fields), then systematically processes each LinkedIn URL through a batch iterator. For every profile, it extracts comprehensive data including names, headlines, job titles, companies, locations, skills, work positions, education, certifications, and follower counts, then writes everything back to your Airtable records automatically.

Use cases

• Sales prospecting: Transform basic LinkedIn URLs into detailed prospect profiles with company information, job titles, and professional background
• Recruitment databases: Automatically populate candidate records with education, skills, certifications, and career history from LinkedIn profiles
• Lead qualification: Enrich marketing leads with professional data to better understand prospect seniority and company fit
• CRM maintenance: Keep contact databases current with accurate job titles, companies, and professional details

Technical details

Built with essential n8n nodes including Airtable integration for database operations, HTTP Request nodes for Apify API communication, Manual Trigger for on-demand execution, and Split in Batches for efficient bulk processing. The workflow requires Airtable API access and an Apify account with LinkedIn Profile Scraper permissions.

Setup involves connecting your Airtable credentials, configuring your base and table settings with proper filter formulas, obtaining and connecting your Apify API key, and customizing field mappings to match your Airtable schema. The automation processes records individually to ensure reliable data extraction and proper rate limiting.

Perfect for sales teams, recruiters, and growth operators managing LinkedIn prospect lists who need professional profile enrichment without manual data entry.