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 LinkedIn profile URLs using a script step. - These usernames are required for further enrichment using [RapidAPI](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](www) 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.