AutomationFlowsMarketing & Ads › Lead Enrichment Pipeline: Leadfeeder to Apollo to Google Sheets

Lead Enrichment Pipeline: Leadfeeder to Apollo to Google Sheets

ByKhairul Muhtadin @khmuhtadin on n8n.io

This automation creates a seamless daily pipeline that: Pulls yesterday's website visitors from Leadfeeder Enriches company data using Apollo.io's powerful database Delivers enriched leads to your Google Sheets with smart deduplication Alerts your team via Telegram when…

Cron / scheduled trigger★★★★☆ complexity23 nodesHTTP RequestGoogle SheetsError TriggerTelegram
Marketing & Ads Trigger: Cron / scheduled Nodes: 23 Complexity: ★★★★☆ Added:

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

This workflow follows the Error Trigger → Google Sheets 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
{
  "id": "cFNi1b3jO3XvSvAn",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Automate leadfeeder and Apollo.io data collection",
  "tags": [],
  "nodes": [
    {
      "id": "a2faf2da-24c3-4972-994d-9dabe6feb7a6",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e4218112-f685-4ade-8265-365cf01382f7",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        512
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "7ffd56d9-f27d-41e3-95d4-6b3a55bcc1da",
      "name": "Daily Trigger (9 AM)",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        112,
        288
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "7515cbdd-ef25-45dd-9118-5d8b9eef2569",
      "name": "Fetch Leadfeeder Account ID",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        352,
        288
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "3a901947-6a9d-4240-b8e3-80a0e603618b",
      "name": "Generate Pagination Sequence",
      "type": "n8n-nodes-base.code",
      "position": [
        576,
        288
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "4657e075-050e-4e99-a214-dbb30b5f2221",
      "name": "Pagination Controller",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        800,
        288
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "15f367cc-6031-4440-a13d-952cbc09e245",
      "name": "Assign Current Page Number",
      "type": "n8n-nodes-base.set",
      "position": [
        1024,
        208
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "86fc67c9-12e5-4dfa-9b63-d49f9059d4e8",
      "name": "Retrieve Lead Data (Leadfeeder)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1248,
        208
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "7db9202f-9978-4716-9016-7cf2056b3f07",
      "name": "Check Last Page Condition",
      "type": "n8n-nodes-base.if",
      "position": [
        1472,
        208
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "aebd0481-ac90-4494-bff9-e8d11fc17a30",
      "name": "Extract Leads (Last Page)",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1696,
        96
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "230f4943-0fbd-4cde-a22c-f60123b65f74",
      "name": "Enrich with Apollo (Last Page)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1920,
        96
      ],
      "parameters": {},
      "executeOnce": false,
      "typeVersion": 4.2,
      "alwaysOutputData": true
    },
    {
      "id": "791cd99d-59d4-4746-bec5-e59cffe11b28",
      "name": "Save Leads to Google Sheets (Last Page)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2144,
        96
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "26c5e81a-027a-4466-ba34-ce3580d958ba",
      "name": "Extract Leads (Full Page)",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1696,
        304
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e7f593b8-edb3-4aa4-86d3-3f553457a3ff",
      "name": "Enrich with Apollo (Full Page)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1920,
        304
      ],
      "parameters": {},
      "executeOnce": false,
      "typeVersion": 4.2,
      "alwaysOutputData": true
    },
    {
      "id": "78ccfdc1-8bd7-4425-b270-4322c248d9c5",
      "name": "Save Leads to Google Sheets (Full Page)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2144,
        304
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "aba38dd5-79eb-41c5-8dda-111fa923ef82",
      "name": "Rate Limit Delay (40s)",
      "type": "n8n-nodes-base.wait",
      "position": [
        2368,
        384
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "9bbd30ee-e365-4e11-a462-8efc1eba2ccb",
      "name": "Workflow Error Listener",
      "type": "n8n-nodes-base.errorTrigger",
      "position": [
        64,
        608
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "2fabef88-4742-4f4d-9cb6-85fabd53fc16",
      "name": "Format Error Report",
      "type": "n8n-nodes-base.code",
      "position": [
        288,
        608
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "6237a74a-7f4b-4277-9e8c-a2b6c964dc31",
      "name": "Send Alert to Telegram",
      "type": "n8n-nodes-base.telegram",
      "position": [
        496,
        608
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "149e66d0-8679-41d9-958e-b9c6ecf210ec",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        736,
        656
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d34dba88-59a0-4efd-83b3-7148579daa86",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1264,
        656
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c9bdf4b3-e4fc-4e56-8e98-eedd2e0951dd",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1728,
        656
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0db97b64-7a09-4bfe-a473-80e6429a7e5e",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2192,
        656
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "58cc5a2a-d253-43ad-b657-058ed893f2f4",
  "connections": {
    "Format Error Report": {
      "main": [
        [
          {
            "node": "Send Alert to Telegram",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Trigger (9 AM)": {
      "main": [
        [
          {
            "node": "Fetch Leadfeeder Account ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Pagination Controller": {
      "main": [
        [],
        [
          {
            "node": "Assign Current Page Number",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Rate Limit Delay (40s)": {
      "main": [
        [
          {
            "node": "Pagination Controller",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Workflow Error Listener": {
      "main": [
        [
          {
            "node": "Format Error Report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Last Page Condition": {
      "main": [
        [
          {
            "node": "Extract Leads (Last Page)",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Extract Leads (Full Page)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Leads (Full Page)": {
      "main": [
        [
          {
            "node": "Enrich with Apollo (Full Page)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Leads (Last Page)": {
      "main": [
        [
          {
            "node": "Enrich with Apollo (Last Page)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Assign Current Page Number": {
      "main": [
        [
          {
            "node": "Retrieve Lead Data (Leadfeeder)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Leadfeeder Account ID": {
      "main": [
        [
          {
            "node": "Generate Pagination Sequence",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Pagination Sequence": {
      "main": [
        [
          {
            "node": "Pagination Controller",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Enrich with Apollo (Full Page)": {
      "main": [
        [
          {
            "node": "Save Leads to Google Sheets (Full Page)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Enrich with Apollo (Last Page)": {
      "main": [
        [
          {
            "node": "Save Leads to Google Sheets (Last Page)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Retrieve Lead Data (Leadfeeder)": {
      "main": [
        [
          {
            "node": "Check Last Page Condition",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Save Leads to Google Sheets (Full Page)": {
      "main": [
        [
          {
            "node": "Rate Limit Delay (40s)",
            "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 automation creates a seamless daily pipeline that: Pulls yesterday's website visitors from Leadfeeder Enriches company data using Apollo.io's powerful database Delivers enriched leads to your Google Sheets with smart deduplication Alerts your team via Telegram when…

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

More Marketing & Ads workflows → · Browse all categories →

Related workflows

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

Marketing & Ads

Workflow A — WhatsApp Lead Intake & Qualification. Uses postgres, httpRequest, errorTrigger. Scheduled trigger; 67 nodes.

Postgres, HTTP Request, Error Trigger
Marketing & Ads

This workflow runs on scheduled weekly and monthly triggers to generate unified marketing performance reports. It processes multiple websites by collecting analytics data, paid ads performance, and CR

Gmail, Google Sheets, Google Analytics +3
Marketing & Ads

Goal: Get Reddit posts from specific subreddits, filter those mentioning freelance/gigs and n8n, extract top-level comments, remove mod replies, and store everything into Google Sheets.

HTTP Request, Reddit, Google Sheets
Marketing & Ads

This workflow is a comprehensive solution for digital marketers, performance agencies, and e-commerce brands looking to scale their creative testing process on Meta Ads efficiently. It eliminates the

Google Drive, HTTP Request, Google Sheets
Marketing & Ads

Watch target companies for C-level and VP hiring signals, then send AI-personalized outreach emails when leadership roles are posted.

Google Sheets, @Predictleads/N8N Nodes Predictleads, Slack +2