Weekly LinkedIn Connections Sync & Analysis with Apify and Google Sheets

This n8n workflow automates the synchronization and analysis of your LinkedIn connections every week. Triggered by a Cron node on Sundays at 2 AM (adjustable), it initiates a scrape using the Apify LinkedIn Scraper Actor with your credentials. The workflow extracts the run ID, polls for completion with retries, fetches the dataset including names, titles, companies, locations, industries, mutual connections, and profile URLs.

Data is then cleaned and normalized in a Code node, removing duplicates and incomplete profiles. The processed connections are appended to a Google Sheet after clearing old data, with structured headers for easy tracking. Finally, it generates a summary analyzing total connections, top companies, locations, and industries, providing actionable insights into your professional network.

Benefits include effortless network maintenance, saving hours of manual export and analysis. Ideal for sales professionals, recruiters, and business developers to monitor network growth, identify trends, and prioritize outreach. Use cases: CRM integration prep, lead generation tracking, or quarterly networking reports. High reliability with status checks ensures robust automation even for large networks.