Find LinkedIn Sales Leads with Apify & Save to Google Sheets

Find LinkedIn sales leads with Apify and automatically save them to Google Sheets

This n8n workflow runs an Apify-powered LinkedIn search, enriches each matched profile with contact and company details, and appends every lead as a new row in your Google Sheets—right when you click Execute workflow.

What this workflow does

• Manual trigger: Starts when you run the workflow in n8n by clicking Execute workflow.
• Search LinkedIn profiles via Apify: Uses the Apify LinkedIn profile search Actor to find people matching your configured query and filters.
• Collect profile URLs: Aggregates the returned LinkedIn profile URLs into a single array for the next step.
• Enrich lead details via Apify: Runs a second Apify Actor to enrich each profile URL with first name, last name, company name, and email.
• Append to Google Sheets: Writes each enriched lead to your destination spreadsheet, mapping columns to Name, Last Name, Email, and Company.

Use cases

• SaaS sales prospecting: Pull LinkedIn profiles for a target persona, then store enriched contacts in Google Sheets for outreach planning.
• Outbound lead lists: Generate fresh lead rows on demand (manual execution) without manually copying profile data.
• Sales ops workflows: Centralize lead information in Sheets so your team can segment and manage follow-ups.

Technical details

• Trigger: Manual trigger in n8n.
• Apify integrations: n8n node for Apify Actors (apifyn8n-nodes-apifyapify) for both LinkedIn profile search and profile enrichment.
• Data handling: Uses aggregate to combine profile URLs into an array.
• Google Sheets: Uses the Google Sheets append step to add rows with mapped columns (Name, Last Name, Email, Company).

Setup checklist

• Create an Apify API token and add it as an Apify credential in n8n.
• Add a Google Sheets OAuth2 credential with edit access.
• Confirm the destination worksheet contains columns for Name, Last Name, Email, and Company.
• Update the Apify search input (e.g., searchQuery, maxItems, yearsOfExperienceIds) to match your LinkedIn persona.