Extract LinkedIn profiles with Apify & auto-generate lead data for Google Sheets CRM
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 13 nodes and runs manually, when you click “Execute workflow” (plus 2 other triggers). Along the way it connects Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 2 other triggers).
- Process All Input Sources (Code): runs custom JavaScript code
- Read LinkedIn URLs (Google Sheets): uses Google Sheets
- Format Input Data (Edit Fields (Set)): sets or maps fields
- Check Batch Processing (If): checks a condition and branches into true / false
- Split Batch URLs (Code): runs custom JavaScript code
- Scrape LinkedIn Profile (HTTP Request): calls an HTTP API
- Process Profile Data (Code): runs custom JavaScript code
- Route to Google Sheets (If): checks a condition and branches into true / false
- Add to Google Sheets CRM (Google Sheets): uses Google Sheets
- Respond Success (Respond to Webhook): sends the response back to the webhook caller
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Webhook
n8n-nodes-base.webhook - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
Overview This professional n8n automation suite transforms LinkedIn prospecting from manual drudgery into intelligent automation. Instead of spending hours copying profile data into spreadsheets, simply paste LinkedIn URLs and get complete lead intelligence…