What This Workflow Does
This n8n workflow solves the tedious manual process of researching companies on LinkedIn and transferring their information to your CRM. Sales professionals waste hours each week copying data between platforms, risking errors and missing opportunities. The automation performs targeted LinkedIn searches based on your criteria (industry, location, size), extracts key company details, and creates clean records in your Airtable CRM.
By automating this process, you ensure your sales pipeline stays filled with qualified prospects while eliminating repetitive data entry. The workflow captures comprehensive company profiles including industry classification, employee count, headquarters location, and LinkedIn engagement metrics—all structured for easy filtering and segmentation in Airtable.
How It Works
1. Configure LinkedIn search parameters
The workflow starts by executing a LinkedIn company search using your predefined filters. You can specify criteria like industry verticals, geographic locations, company size ranges, or keywords in company descriptions. These parameters ensure you only capture relevant prospects matching your ideal customer profile.
2. Extract company profile data
For each matching company, the workflow collects detailed information including the company name, LinkedIn profile URL, industry classification, employee count range, headquarters location, and website URL. It also captures valuable engagement metrics like follower count and recent post activity.
3. Transform data for CRM consistency
The raw LinkedIn data gets processed to match your Airtable CRM structure. This includes standardizing industry classifications, converting employee ranges to numerical values, and extracting clean website domains. The transformation ensures all records follow your preferred formatting for consistent reporting and filtering.
4. Create or update Airtable records
The workflow checks if each company already exists in your Airtable base to prevent duplicates. New companies get added as fresh records, while existing ones receive updates with the latest LinkedIn data. The system maintains all historical information while refreshing key metrics for accurate pipeline management.
Who This Is For
This automation delivers the most value to B2B sales teams, business development professionals, and recruiters who need to systematically build prospect lists. It's particularly useful for:
- Sales teams targeting specific industries or company sizes
- Startups building their initial customer pipeline
- Agencies managing multiple client prospecting lists
- Recruiters specializing in particular company types
- Market researchers analyzing industry landscapes
Pro tip: Combine this workflow with email finding tools to build complete prospect records with contact information automatically added to your CRM.
What You'll Need
- An n8n instance (cloud or self-hosted)
- LinkedIn Sales Navigator account for advanced search capabilities
- Airtable account with a prepared CRM base structure
- API credentials for both LinkedIn (via proxy service) and Airtable
- Clear criteria for your ideal customer profile (industries, sizes, locations)
Quick Setup Guide
- Download the JSON template file
- Import it into your n8n instance
- Configure the LinkedIn search node with your target criteria
- Connect the Airtable node to your CRM base
- Map the LinkedIn data fields to your Airtable columns
- Test with a small search sample
- Schedule regular runs (weekly recommended)
Key Benefits
Save 5-10 hours weekly by eliminating manual LinkedIn research and data entry. What used to take hours now happens automatically in minutes.
Never miss qualified prospects with systematic searches that capture all matching companies, not just the ones you manually notice.
Maintain accurate CRM data with automatic updates that refresh company details like employee counts and locations.
Improve targeting precision by analyzing complete industry datasets rather than anecdotal samples.
Scale prospecting efforts effortlessly—searching 100 companies takes the same time as searching 10.