Lead Generation Automate on LinkedIn - Personalisation, Enrichment
VerifiedAutomates LinkedIn lead enrichment and AI personalization into Google Sheets.
What this workflow does
This automation pulls lead details via HTTP, applies OpenAI models to create custom summaries and engagement insights, and writes enriched results to Google Sheets with dynamic column updates.
It is designed for sales and marketing teams seeking to streamline lead qualification and message personalization at scale using n8n.
Who is this for?
Sales development reps and growth marketers who need to enrich and personalize LinkedIn leads at scale without manual copy-paste work.
What problem it solves
Manually pulling LinkedIn profile data, verifying emails, and writing personalized messages is slow and error-prone; this workflow automates enrichment and stores everything in Google Sheets.
Live workflow preview
Interactive canvas of every node and connection — scroll and click to explore. Powered by n8n's preview.
Open the template on n8n to import and run it. View source template →
What it automates
Cold outreach prep
Pull new leads from a sheet, enrich bios via HTTP, then use OpenAI to generate first-line hooks based on recent activity.
Weekly list refresh
Re-run the workflow on existing rows to update missing emails or summaries without duplicating data.
Campaign segmentation
Enrich leads with OpenAI-generated tags so the sales team can filter the Google Sheet by industry or recent post topics.
How the workflow works
The 4 nodes in this automation, in order.
- 1Google SheetsgoogleSheets
- 2HTTP RequesthttpRequest
- 3Codecode
- 4OpenAI@n8n/n8n-nodes-langchain.openAi
Apps & integrations used
How to set up Lead Generation Automate on LinkedIn - Personalisation, Enrichment
- 1Create a new n8n workflow and add a Google Sheets node to read lead URLs and IDs from your input sheet.
- 2Add an HTTP Request node to fetch additional profile data using the LinkedIn URLs.
- 3Insert an OpenAI node to generate a short profile summary and personalized message draft from the enriched data.
- 4Add a second Google Sheets node to append the new columns (email, summary, message) back to the sheet.
- 5Connect the nodes in sequence and activate the workflow; test with 3-5 rows first.
How to customize this workflow
- →Swap the OpenAI model from GPT-4o-mini to GPT-4o for longer summaries
- →Change the trigger from manual to a Schedule or Webhook node
- →Add a filter after the HTTP node to skip rows that already have an email
- →Insert a Set node to format data before writing to Google Sheets
Lead Generation Automate on LinkedIn - Personalisation, Enrichment: pros & cons
Pros
- +Uses only the three listed integrations
- +Keeps all data in one Google Sheet
- +OpenAI handles personalization without extra tools
- +Beginner-friendly node sequence
Cons
- –HTTP Request node still requires you to supply correct API endpoints
- –No built-in retry logic described in the given integrations
- –LinkedIn data access depends on the HTTP endpoint you configure
Frequently asked questions
It reads leads from Google Sheets, enriches them via HTTP, uses OpenAI for summaries and messages, then writes results back to the sheet.
User reviews
Verified reviews from the community shape this listing's rating.
Loading reviews…
Similar workflows
Other ai & llm automations worth a look.