Lead generation automate on LinkedIn - personalisation, enrichment

Automatically generates LinkedIn leads from Apollo, enriches profiles with emails and activity data, then saves everything to Google Sheets.

workflowlead_generation

by Krupal Patelon n8n

Nodes

Triggers

Platform

n8n

Tech Stack

OpenAI

Google Sheets

How It Works

This workflow pulls leads from Apollo based on your search criteria, then enriches each profile with verified emails, LinkedIn bio data, and recent activity insights. All enriched lead data is automatically organized in Google Sheets with smart retry logic for failed requests.

Collect leads from Apollo

Automatically pulls leads based on keywords, roles, or industries using Apollo's API. Captures name, job title, company, and LinkedIn profile URL.

Extract LinkedIn usernames

Processes LinkedIn profile URLs to extract usernames needed for further profile enrichment through RapidAPI.

Retrieve verified emails

Fetches work emails using Apollo User ID and validates deliverability using mails.so to filter out inactive addresses.

Enrich profile summaries

Pulls LinkedIn bio and summary details via RapidAPI to understand each lead's background and expertise.

Attached Files

workflow.json