{
  "name": "Enrich LinkedIn leads with Apify using Google Sheets",
  "nodes": [
    {
      "id": "d7af6e84-429f-4bf3-9ee4-82eb218381b9",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -96,
        624
      ]
    },
    {
      "id": "253ad592-d742-4257-8e88-55fa0e799714",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -800,
        512
      ],
      "parameters": {
        "width": 540,
        "height": 1200,
        "content": "## Try It Out!\n\nThis n8n template shows how to enrich Google spreadsheet with LinkedIn profiles automatically using the Apify LinkedIn Profile Enrichment actor from [Anchor](https://apify.com/anchor)."
      }
    },
    {
      "id": "cf257c1e-df6d-4db5-b986-33fa2ef9b920",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -192,
        816
      ],
      "parameters": {
        "width": 448,
        "height": 224,
        "content": "## Input Example\n```json\n[\n {\n   \"google_sheet_url\": \"https://docs.google.com/spreadsheets/d/1ffxxxxxxxxxxvI/\",\n   \"google_sheet_name\": \"profiles\"\n }\n]\n```"
      }
    },
    {
      "id": "735e23a5-1279-4686-8a71-b67a3ba06bc1",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1104,
        816
      ],
      "parameters": {
        "width": 896,
        "height": 416,
        "content": "## Output Example\n\n![google sheet output example](https://i.postimg.cc/vmHr9VGR/Screenshot-2025-11-10-at-01-22-02.png)"
      }
    },
    {
      "id": "1847381e-9c55-48f9-814e-c24f9c65ec07",
      "name": "Create new sheet for enriched profiles",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        352,
        528
      ]
    },
    {
      "id": "befb634a-f002-4fe2-a06b-e6e0dbe2c316",
      "name": "Get URLs from first sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        352,
        720
      ]
    },
    {
      "id": "9d7b9c9a-81f8-4bf3-923d-0ded1b16c45a",
      "name": "Set google sheet URL & original sheet name",
      "type": "n8n-nodes-base.set",
      "position": [
        128,
        624
      ]
    },
    {
      "id": "a03f0ca7-4e85-406b-9d27-5a5f0f52ef62",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        320,
        880
      ],
      "parameters": {
        "width": 672,
        "height": 352,
        "content": "## Google Sheet INPUT Example\n\n![google sheet example](https://i.postimg.cc/k4HB2VgW/Screenshot-2025-11-10-at-01-16-03.png)"
      }
    },
    {
      "id": "bef6026e-8153-49c4-ad55-f680c42526f1",
      "name": "wait for previous nodes to finish",
      "type": "n8n-nodes-base.merge",
      "position": [
        576,
        624
      ]
    },
    {
      "id": "0ceae0f0-b870-4878-b244-38bbc239e87b",
      "name": "format data for Apify INPUT type",
      "type": "n8n-nodes-base.code",
      "position": [
        800,
        624
      ]
    },
    {
      "id": "0986effe-19f0-4ae9-b422-58518e39fee8",
      "name": "Run Actor on Apify",
      "type": "@apify/n8n-nodes-apify.apify",
      "position": [
        1024,
        624
      ]
    },
    {
      "id": "e1364b92-dce2-4187-b96f-010ef120566f",
      "name": "Get Results from Apify",
      "type": "@apify/n8n-nodes-apify.apify",
      "position": [
        1248,
        624
      ]
    },
    {
      "id": "aef23e87-4fd1-42d9-81fc-86ff77397259",
      "name": "Add profiles into the new Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1472,
        624
      ]
    }
  ],
  "connections": {
    "Run Actor on Apify": {
      "main": [
        [
          {
            "node": "Get Results from Apify",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Results from Apify": {
      "main": [
        [
          {
            "node": "Add profiles into the new Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get URLs from first sheet": {
      "main": [
        [
          {
            "node": "wait for previous nodes to finish",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "format data for Apify INPUT type": {
      "main": [
        [
          {
            "node": "Run Actor on Apify",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "wait for previous nodes to finish": {
      "main": [
        [
          {
            "node": "format data for Apify INPUT type",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Set google sheet URL & original sheet name",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create new sheet for enriched profiles": {
      "main": [
        [
          {
            "node": "wait for previous nodes to finish",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set google sheet URL & original sheet name": {
      "main": [
        [
          {
            "node": "Create new sheet for enriched profiles",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get URLs from first sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}