{
  "name": "Extract emails, phones & social links from websites with Apify and Google Sheets",
  "nodes": [
    {
      "id": "35a5417a-ff07-4bed-b223-e40592fe94e4",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -96,
        624
      ]
    },
    {
      "id": "06d930a8-58f0-474c-a725-32f05c6a346d",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -800,
        512
      ],
      "parameters": {
        "width": 540,
        "height": 1328,
        "content": "Try It Out!\n\nThis n8n template shows how to, based on a list of website, enrich a Google Spreadsheet with emails and phone numbers automatically using the [Apify Email & Phone Extractor](https://apify"
      }
    },
    {
      "id": "9f796244-c705-4c86-b289-dcdc0a410255",
      "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": "26242c38-e9ef-4bc7-8018-6bbcaf1f6e74",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        864,
        800
      ],
      "parameters": {
        "width": 1152,
        "height": 224,
        "content": "## Output Example\n\n![google sheet output example](https://i.postimg.cc/BbS8jzKF/Screenshot-2025-11-11-at-22-31-12.png)"
      }
    },
    {
      "id": "209cc0dd-91c3-434f-ac6b-b02490829c7f",
      "name": "Set google sheet URL & original sheet name",
      "type": "n8n-nodes-base.set",
      "position": [
        128,
        624
      ]
    },
    {
      "id": "5b8add37-b502-4e63-a831-3d727bfa9536",
      "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/hvzX8nff/Screenshot-2025-11-11-at-22-19-21.png)"
      }
    },
    {
      "id": "a1f44b43-db17-41bc-a41a-f9ea5be2209c",
      "name": "wait for previous nodes to finish",
      "type": "n8n-nodes-base.merge",
      "position": [
        576,
        624
      ]
    },
    {
      "id": "3ae29830-16f8-4764-984c-5e64f50488a8",
      "name": "format data for Apify INPUT type",
      "type": "n8n-nodes-base.code",
      "position": [
        800,
        624
      ]
    },
    {
      "id": "40ce81c8-7c0f-49c2-8c16-b9977e54a035",
      "name": "Run Actor on Apify",
      "type": "@apify/n8n-nodes-apify.apify",
      "position": [
        1024,
        624
      ]
    },
    {
      "id": "95ffc5c0-745b-41ca-a90c-5195cf1ffbea",
      "name": "Get Results from Apify",
      "type": "@apify/n8n-nodes-apify.apify",
      "position": [
        1248,
        624
      ]
    },
    {
      "id": "f2c66877-0716-466c-871d-a4440eef1716",
      "name": "Add emails, phones, socials... into the new Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1472,
        624
      ]
    },
    {
      "id": "a7bcfc5b-0131-4bfb-8b09-b8720c3639dd",
      "name": "Create new sheet for founded emails and phones",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        352,
        528
      ]
    },
    {
      "id": "883368eb-c5c8-435e-9b16-3a7e7877469a",
      "name": "Get website URLs from first sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        352,
        720
      ]
    },
    {
      "id": "f0f65408-75a6-4c6e-b542-bcd738cd3abf",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        608,
        272
      ],
      "parameters": {
        "width": 512,
        "height": 288,
        "content": "## Customizable parameters\nIn the code block \"format data for Apify\" there are a few parameters you can play with.\n\n- “maxRequests” :  Total pages to crawl across all links. 0 for no limit\n- “sameDoma"
      }
    }
  ],
  "connections": {
    "Run Actor on Apify": {
      "main": [
        [
          {
            "node": "Get Results from Apify",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Results from Apify": {
      "main": [
        [
          {
            "node": "Add emails, phones, socials... into the new Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "format data for Apify INPUT type": {
      "main": [
        [
          {
            "node": "Run Actor on Apify",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get website URLs from first sheet": {
      "main": [
        [
          {
            "node": "wait for previous nodes to finish",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "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
          }
        ]
      ]
    },
    "Set google sheet URL & original sheet name": {
      "main": [
        [
          {
            "node": "Create new sheet for founded emails and phones",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get website URLs from first sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create new sheet for founded emails and phones": {
      "main": [
        [
          {
            "node": "wait for previous nodes to finish",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}