🎣 Enrich LinkedIn profiles in Google Sheets with Apify
⚡ 1,516 views · 🎣 Lead Generation & Enrichment
💡 Pro Tip — If you’re pulling LinkedIn data through HTTP requests or dealing with API restrictions, there’s a community node called ScraperNode that handles this natively. It has dedicated scrapers for profiles, companies, jobs, and people search — you just pass a URL and get structured data back.
Description
Quick overview
This workflow reads LinkedIn profile URLs from Google Sheets, calls the Apify LinkedIn scraper to fetch profile details, and writes enriched fields (name, headline, job title, company, location, skills, positions, education, certifications, and follower data) back to the same rows.
How it works
- Runs when you manually execute the workflow.
- Loads configuration values such as the LinkedIn URL column name, apify actor ID, contact-finding toggle, and batch size.
- Reads rows from the selected Google Sheets tab to get the LinkedIn profile URLs to enrich.
- Processes the sheet rows in batches to control throughput and respect Apify rate limits.
- For each row, sends the LinkedIn URL to apify and retrieves the scraped LinkedIn profile data.
- Updates the matching Google Sheets row (by row_number) with the returned profile fields, including skills, positions, education, and other metadata.
Setup
- Add a Google Sheets OAuth2 credential and select the target spreadsheet and sheet tab in the read and update steps.
- Add an apify API token as HTTP Header Auth (Authorization: Bearer YOUR_APIFY_TOKEN) for the Apify request.
- Ensure your Google Sheet includes a column containing LinkedIn profile URLs (default name: “LinkedIn URL”) and a row_number column used to match updates.
- In the configuration step, set the correct LinkedIn URL column name, Apify actor ID, and batch size (and enable find_contacts only if your Apify actor/setup supports it).
Additional info
Enrich LinkedIn profiles in Google Sheets
📥 Open full documentation on Notion
Need help customizing?
Contact me for consulting and support : Linkedin
MY NEW YOUTUBE CHANNEL
👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n.
🔗 Nodes Used
Google Sheets, HTTP Request
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File