Lead generation automate on LinkedIn - personalisation, enrichment
Workflow Summary This system automates LinkedIn lead generation and enrichment in six clear stages: 1. Lead Collection (via Apollo.io) - Automatically pulls leads based on keywords, roles, or industries using Apollo’s API. - Captures name, job title, company, and LinkedIn profile URL. - You can kick off the workflow via form, webhook, WhatsApp, Telegram, or any other custom trigger that passes search parameters. 2. LinkedIn Username Extraction - Extracts usernames from LinkedI
At a glance
Lead generation automate on LinkedIn - personalisation, enrichment is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, WhatsApp, Telegram, LinkedIn. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets, WhatsApp, Telegram, LinkedIn
- Modules
- 47
- Price
- Free
- Version
- v1.0

About this workflow
Workflow Summary This system automates LinkedIn lead generation and enrichment in six clear stages: 1. Lead Collection (via Apollo.io) - Automatically pulls leads based on keywords, roles, or industries using Apollo’s API. - Captures name, job title, company, and LinkedIn profile URL. - You can kick off the workflow via form, webhook, WhatsApp, Telegram, or any other custom trigger that passes search parameters. 2. LinkedIn Username Extraction - Extracts usernames from LinkedIn profile URLs using a script step. - These usernames are required for further enrichment using RapidAPI. 3. Email Retrieval (via Apollo.io User ID) - Fetches verified work email using the Apollo User ID. - Email validity is double-checked using www.mails.so filtering out undeliverable or inactive emails by checking MX records and deliverability. 4. Profile Summary (via LinkedIn API on RapidAPI) - Enriches lead data by pulling bio/summary details to understand their background and expertise. 5. Activity Insights (Posts & Reposts) - Collects recent posts or reposts to help craft personalised messages based on what they’re currently engaging with. 6. Leads Sheet Update - All data is written into a Google Sheet. - New columns are populated dynamically without erasing existing data. ⸻ ✅ Smart Retry Logic Each workflow is equipped with a fail-safe system: - Tracks status per row: ✅ done, ❌ failed, ⏳ pending - Failed rows are automatically retried after a custom delay (e.g., 2 weeks). - Ensures minimal drop-offs and complete data coverage. 📊 Google Sheets Setup Make a copy of the following: - Template 1: Apollo Leads Scraper & Enrichment - Template 2: Final Enriched Leads The system appends data (like emails, bios, activity) step by step. 🔐 API Credentials Needed 1. Apollo API - Sign up and generate API key at Apollo Developer Portal - Be sure to enable the “Master API Key” toggle so the same key works for all endpoints. 2. LinkedIn Data API (via RapidAPI) - Subscribe at RapidAPI - LinkedIn Data - Use your key in the x-rapidapi-key header. 3. Mails.so API - Get your API Key from mails.so dashboard 🛠️ Troubleshooting – LinkedIn Lead Machine ✅ Common Mistakes & Fixes 1. API Keys Not Working - Make sure API keys for Apollo, RapidAPI, and mails.so are correct. - Apollo “Master API Key” must be enabled. - Keys should be saved as Generic Credentials in n8n. 2. Leads Not Found - Check if the search query (keyword/job title) is too narrow. - Apollo might return empty results if the filters are incorrect. 3. LinkedIn URLs Missing or Invalid - Ensure Apollo is returning valid LinkedIn URLs. - Improper URLs will cause username extraction and enrichment steps to fail. 4. Emails Not Coming Through - Apollo may not have verified emails for all leads. - mails.so might reject invalid or expired email addresses. 5. Google Sheet Not Updating - Make sure the Google Sheet is shared with the right Google account (linked to n8n). - Check if the column names match and data isn’t blocked due to formatting. 6. Status Columns Not Changing - Each row must have done, failed, or pending in the status column. - If the status doesn’t update, the retry logic won’t trigger. 7. RapidAPI Not Returning Data - Double-check if username is present and valid. - Make sure the RapidAPI plan is active and within limits. 8. Workflow Not Running - Check if the trigger node (form, webhook, etc.) is connected and active. - Make sure you’re passing the required inputs (keyword, role, etc.). ------------ Need Help? Contact www.KrupalPatel.com for support and custom workflow development
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Save Facebook pages posts to a Google Sheets spreadsheet
Generate bulk Google Slides certificates 📜 as PDFs and email them with Gmail
Normalize and validate customer data with Google Sheets highlights
Automated revenue predictions from Stripe data with GPT-4 and Google Sheets
Analyze hotel reviews with OpenAI GPT-4o-mini and Airtable sentiment fields
AI-optimized content posting to X, Discord & LinkedIn with OpenRouter
Scrape LinkedIn job listings for hiring signals & prospecting with Bright Data
Generate AI-Powered LinkedIn Posts with Google Gemini and Gen-Imager
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you