This n8n workflow searches LinkedIn for profiles that match your query and filters, enriches each match with contact and company details, and adds every lead as a new row in Google Sheets. It starts when you click Execute workflow in n8n.
It uses two Apify Actors. The first searches LinkedIn profiles. The workflow gathers the returned profile URLs into a single array. The second Actor then enriches each URL with first name, last name, company name and email.
Each enriched lead is appended to your spreadsheet with columns mapped to Name, Last Name, Email and Company. It can be used for SaaS sales prospecting, outbound lead lists generated on demand, and sales ops workflows that keep lead information in Sheets for segmenting and follow-ups.
- Platform
- n8n workflow
- Trigger
- Manual trigger (Execute workflow)
- Integrations
- Apify Actors (LinkedIn profile search and profile enrichment), Google Sheets
- Data collected
- First name, last name, company name, email
- Sheet columns
- Name, Last Name, Email, Company
- Data handling
- Aggregate step combines profile URLs into an array
- Output
- Each lead appended as a new row in Google Sheets
- Search input
- Configurable in Apify, e.g. searchQuery, maxItems, yearsOfExperienceIds
- Requires
- Apify API token added as an Apify credential in n8n; Google Sheets OAuth2 credential with edit access
- Setup
- Destination worksheet must contain columns for Name, Last Name, Email and Company