{
  "name": "Find company LinkedIn URLs using Apify - Google Sheets integration",
  "nodes": [
    {
      "id": "93f0f15e-c64f-45ac-b5cd-2c89a71d4b61",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -96,
        624
      ]
    },
    {
      "id": "9dfadbf2-8d26-4055-a922-7fbeeb9deb0a",
      "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 populate a Google Spreadsheet with LinkedIn company URLs automatically using the [Apify LinkedIn Company URL Finder actor](https://apify.com/anchor/linke"
      }
    },
    {
      "id": "9b7ff544-37eb-4461-bf8f-a48ccfd544d1",
      "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": "cc9daaaf-0c94-492d-8b60-784f5bd38cf9",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1184,
        800
      ],
      "parameters": {
        "width": 896,
        "height": 304,
        "content": "## Output Example\n\n![google sheet output example](https://i.postimg.cc/nczBd890/Screenshot-2025-11-11-at-21-41-19.png)"
      }
    },
    {
      "id": "00dab93c-f84e-4829-80ae-d8cc6031800f",
      "name": "Get URLs from first sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        352,
        720
      ]
    },
    {
      "id": "1ad7685b-0303-45dd-95ff-b79c2e57622d",
      "name": "Set google sheet URL & original sheet name",
      "type": "n8n-nodes-base.set",
      "position": [
        128,
        624
      ]
    },
    {
      "id": "18dd0ef5-b90a-488d-aae8-ac7e91918531",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        320,
        880
      ],
      "parameters": {
        "width": 400,
        "height": 352,
        "content": "## Google Sheet INPUT Example\n\n![google sheet example](https://i.postimg.cc/xdKzknBG/Screenshot-2025-11-11-at-21-41-32.png)"
      }
    },
    {
      "id": "7be3757e-fc71-46aa-b2b2-955c9b11565c",
      "name": "wait for previous nodes to finish",
      "type": "n8n-nodes-base.merge",
      "position": [
        576,
        624
      ]
    },
    {
      "id": "8cd6f699-ca26-442a-9ff2-3d4ee0fe1a3a",
      "name": "format data for Apify INPUT type",
      "type": "n8n-nodes-base.code",
      "position": [
        800,
        624
      ]
    },
    {
      "id": "0b6fa7e5-2cd5-42ed-86e2-606b420a476f",
      "name": "Run Actor on Apify",
      "type": "@apify/n8n-nodes-apify.apify",
      "position": [
        1024,
        624
      ]
    },
    {
      "id": "c8ee379d-0574-42fd-94b0-ceb571290425",
      "name": "Get Results from Apify",
      "type": "@apify/n8n-nodes-apify.apify",
      "position": [
        1248,
        624
      ]
    },
    {
      "id": "6822cf59-2533-41c8-937f-ce627eca61e5",
      "name": "Create new sheet for founded compnaies",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        352,
        528
      ]
    },
    {
      "id": "bf4e6d14-c3b8-4b65-beca-94727c2763c9",
      "name": "Add company urls 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 company urls 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 founded compnaies": {
      "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 founded compnaies",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get URLs from first sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}