Enrich lead profiles from LinkedIn URLs with Apify and Google Sheets
Ready for 3.0What this workflow does
This workflow has 18 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls api.apify.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Rows - Not Enriched Yet (Google Sheets): uses Google Sheets
- Process One Row at a Time (Loop Over Items (Split in Batches)): loops over the items in batches
- Start Apify Scrape (HTTP Request): calls api.apify.com (POST)
- Store Run Info (Code): runs custom JavaScript code
- Wait: waits 15 seconds
- Check Status (HTTP Request): calls an HTTP API
- Update Loop Counter (Code): runs custom JavaScript code
- Check if Ready (If): checks a condition and branches into true / false
- Fetch LinkedIn Data (HTTP Request): calls an HTTP API
- Check Max Retries (If): checks a condition and branches into true / false
…plus 7 more steps. See the full node list below.
Services it uses
HTTP calls to: api.apify.com
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 - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if - Merge
n8n-nodes-base.merge - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets
From the author
Transform LinkedIn profile URLs into comprehensive enriched lead profiles, quickly and automatically. Add URLs to your sheet, run the workflow, and get fully enriched contact data: names, job titles, company details, career history, recent activity, and more…