AutomationFlowsWeb Scraping › Weekly Linkedin Connections Sync & Analysis with Apify and Google Sheets

Weekly Linkedin Connections Sync & Analysis with Apify and Google Sheets

ByDavid Olusola @dae221 on n8n.io

This workflow automatically scrapes your LinkedIn connections using Apify, processes the data, and logs it into a structured Google Sheet every week. It also generates a summary of top companies, locations, and industries across your network. Weekly Sync (Sunday 2 AM) A Cron

Cron / scheduled trigger★★★★☆ complexity13 nodesHTTP RequestGoogle Sheets
Web Scraping Trigger: Cron / scheduled Nodes: 13 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #8041 — we link there as the canonical source.

This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "nodes": [
    {
      "id": "20f1dbb0-303a-4129-87ea-0130f619d86b",
      "name": "Setup Instructions",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        176
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e24ff50b-bb32-4450-9617-c8e64f70eaea",
      "name": "Weekly Sync (Sunday 2AM)",
      "type": "n8n-nodes-base.cron",
      "position": [
        688,
        560
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "3c9344c6-3f3c-4123-b26a-04160d3e7069",
      "name": "Start LinkedIn Scrape",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        896,
        560
      ],
      "parameters": {},
      "typeVersion": 4.1
    },
    {
      "id": "51b11269-7779-47a9-b613-489bb2870dec",
      "name": "Extract Run ID",
      "type": "n8n-nodes-base.code",
      "position": [
        1088,
        560
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "41c86b36-af09-4e88-849a-e624e0b6dbdb",
      "name": "Wait for Scrape (30s)",
      "type": "n8n-nodes-base.wait",
      "position": [
        1296,
        560
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "fd27f571-51c5-4ac3-bd2a-fc977653362c",
      "name": "Check Scrape Status",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1488,
        560
      ],
      "parameters": {},
      "typeVersion": 4.1
    },
    {
      "id": "8adef10e-6281-41b7-8fac-1580bcb676a6",
      "name": "Scrape Completed?",
      "type": "n8n-nodes-base.if",
      "position": [
        1696,
        560
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "207a9ab4-b0ac-457a-9819-4a44f23fbefa",
      "name": "Get Scraped Data",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1888,
        464
      ],
      "parameters": {},
      "typeVersion": 4.1
    },
    {
      "id": "f4ad1f43-e96c-43c3-ac29-42672ee3b081",
      "name": "Process Connections Data",
      "type": "n8n-nodes-base.code",
      "position": [
        2096,
        464
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "d9008ae6-20ab-485d-a14d-28f665ce9730",
      "name": "Clear Existing Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2288,
        384
      ],
      "parameters": {},
      "typeVersion": 4
    },
    {
      "id": "4ae5f39a-1c29-461f-940b-462294cc8e2b",
      "name": "Save Connections to Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2288,
        544
      ],
      "parameters": {},
      "typeVersion": 4
    },
    {
      "id": "c159d043-ceb1-43b2-879b-d5f6eabe22b5",
      "name": "Generate Sync Summary",
      "type": "n8n-nodes-base.code",
      "position": [
        2496,
        544
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "e2cf5870-02fa-48e3-a9a4-e07885383d34",
      "name": "Wait & Retry (60s)",
      "type": "n8n-nodes-base.wait",
      "position": [
        1696,
        704
      ],
      "parameters": {},
      "typeVersion": 1
    }
  ],
  "connections": {
    "Extract Run ID": {
      "main": [
        [
          {
            "node": "Wait for Scrape (30s)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Scraped Data": {
      "main": [
        [
          {
            "node": "Process Connections Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Scrape Completed?": {
      "main": [
        [
          {
            "node": "Get Scraped Data",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Wait & Retry (60s)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait & Retry (60s)": {
      "main": [
        [
          {
            "node": "Check Scrape Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Scrape Status": {
      "main": [
        [
          {
            "node": "Scrape Completed?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Start LinkedIn Scrape": {
      "main": [
        [
          {
            "node": "Extract Run ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait for Scrape (30s)": {
      "main": [
        [
          {
            "node": "Check Scrape Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process Connections Data": {
      "main": [
        [
          {
            "node": "Clear Existing Data",
            "type": "main",
            "index": 0
          },
          {
            "node": "Save Connections to Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Weekly Sync (Sunday 2AM)": {
      "main": [
        [
          {
            "node": "Start LinkedIn Scrape",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Save Connections to Sheets": {
      "main": [
        [
          {
            "node": "Generate Sync Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This workflow automatically scrapes your LinkedIn connections using Apify, processes the data, and logs it into a structured Google Sheet every week. It also generates a summary of top companies, locations, and industries across your network. Weekly Sync (Sunday 2 AM) A Cron…

Source: https://n8n.io/workflows/8041/ — original creator credit. Request a take-down →

More Web Scraping workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Web Scraping

> Watch the full Youtube Video Tutorial [](https://youtu.be/Y-wUr2-UYZk)

Data Table, HTTP Request, Google Sheets +1
Web Scraping

This workflow automatically scrapes business leads from Google Maps on a daily schedule and ensures only high-quality, unique leads are processed. New businesses are cleaned, validated, and deduplicat

Google Sheets, Gmail, HTTP Request
Web Scraping

Women creators, homemakers-turned-entrepreneurs, and feminine lifestyle brands who want a graceful, low-lift way to keep an eye on competitor content and spark weekly ideas.

HTTP Request, Google Sheets, Email Send +1
Web Scraping

This workflow automatically searches YouTube Data API for videos related to specific keywords, extracts channel data, filters channels based on performance metrics, and saves the results into Google S

Google Sheets, @Apify/N8N Nodes Apify, HTTP Request
Web Scraping

Marketing agencies, sales teams, lead generation specialists, and business development professionals who need to build comprehensive business databases with contact information for outreach campaigns

Google Sheets, HTTP Request