Scrape LinkedIn profiles & save to Google Sheets with Apify

This n8n workflow automates the process of scraping LinkedIn profiles using the Apify platform and organizing the extracted data into Google Sheets for easy analysis and follow-up.

Use Cases - Lead Generation: Extract contact information and professional details from LinkedIn profiles - Recruitment: Gather candidate information for talent acquisition - Market Research: Analyze professional networks and industry connections - Sales Prospecting: Build targeted prospect lists with detailed professional information

How It Works

1. Workflow Initialization & Input - Webhook Start Scraper: Triggers the entire scraping workflow - Read LinkedIn URLs: Retrieves LinkedIn profile URLs from Google Sheets - Schedule Scraper Trigger: Sets up automated scheduling for regular scraping

2. Data Processing & Extraction - Data Formatting: Prepares and structures the LinkedIn URLs for processing - Fetch Profile Data: Makes HTTP requests to Apify API with profile URLs - Run Scraper Actor: Executes the Apify LinkedIn scraper actor - Get Scraped Results: Retrieves the extracted profile data from Apify

3. Data Storage & Completion - Save to Google Sheets: Stores the scraped profile data in organized spreadsheet format - Update Progress Tracker: Updates workflow status and progress tracking - Process Complete Wait: Ensures all operations finish before final steps - Send Success Notification: Alerts users when scraping is successfully completed

Requirements

Apify Account - Active Apify account with sufficient credits - API token for authentication - Access to LinkedIn Profile Scraper actor