AutomationFlowsSlack & Telegram › Pipedrive Lead Filter & Clearbit Enrichment

Pipedrive Lead Filter & Clearbit Enrichment

Original n8n title: Splitout Filter (clearbit)

Splitout Filter. Uses stickyNote, clearbit, pipedrive, scheduleTrigger. Scheduled trigger; 20 nodes.

Cron / scheduled trigger★★★★☆ complexity20 nodesClearbitPipedriveSlackHTTP Request
Slack & Telegram Trigger: Cron / scheduled Nodes: 20 Complexity: ★★★★☆ Added:

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

This workflow follows the HTTP Request → Slack 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
{
  "meta": {
    "templateId": "2131"
  },
  "nodes": [
    {
      "id": "2b12fb75-ec81-4d2c-a8bb-12ff2bb7e935",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        680,
        2.662790697674268
      ],
      "parameters": {
        "color": 5,
        "width": 410.6749642132356,
        "height": 428.2515771212859,
        "content": "## Setup\n1. Go to Company Settings -> Data fields -> Organization and add `Domain` as a custom field\n2. Go to Company Settings -> Data fields -> Leads and add `Enriched at` as a custom date field\n2. Add your `Pipedrive`, `Clearbit` and `Slack` credentials.\n3. Fill the `setup` node below. To get the ID of your custom domain fields, simply run the `Show only custom organization fields` and `Show only custom lead fields` nodes below and copy the keys of your domain and enriched at field."
      },
      "typeVersion": 1
    },
    {
      "id": "123ad2e5-f4f2-4411-bf03-5668124b8757",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1800,
        160
      ],
      "parameters": {
        "color": 7,
        "width": 223.7628185364029,
        "height": 276.3308728978709,
        "content": "Adjust condition to filter leads by your desired condition. e.g, revenue, number of employees, etc."
      },
      "typeVersion": 1
    },
    {
      "id": "7725dc9e-5c93-475d-9522-f99b4fd1c81f",
      "name": "Enrich company",
      "type": "n8n-nodes-base.clearbit",
      "position": [
        1460,
        140
      ],
      "parameters": {
        "domain": "={{ $json[$('Setup').first().json.domainCustomFieldId2]}}",
        "additionalFields": {}
      },
      "credentials": {
        "clearbitApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "f65855c3-d3d2-415b-bda2-e452d4d7e154",
      "name": "Get all leads",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        1120,
        280
      ],
      "parameters": {
        "filters": {
          "archived_status": "not_archived"
        },
        "resource": "lead",
        "operation": "getAll"
      },
      "credentials": {
        "pipedriveApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "39767a37-bd6d-422e-bc38-bfdfcbbf05af",
      "name": "Add Organization ID to data",
      "type": "n8n-nodes-base.set",
      "position": [
        1640,
        140
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "71b4c743-fd69-4f5d-8c29-66b3672f7a2a",
              "name": "organization_id",
              "type": "number",
              "value": "={{ $('Get organization details').item.json.id }}"
            }
          ]
        },
        "includeOtherFields": true
      },
      "typeVersion": 3.3
    },
    {
      "id": "4263cd25-dcf3-4521-b716-0ce48d3b2c26",
      "name": "Keep leads that match the criteria",
      "type": "n8n-nodes-base.filter",
      "position": [
        2320,
        260
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "1b31b826-e87d-425f-a65d-370b4b20f7e1",
              "operator": {
                "type": "boolean",
                "operation": "true",
                "singleValue": true
              },
              "leftValue": "={{ $json.tags.includes(\"B2B\") }}",
              "rightValue": 5000000
            },
            {
              "id": "90ef79a7-807a-4894-ae8c-92f9d46e7177",
              "operator": {
                "type": "number",
                "operation": "gt"
              },
              "leftValue": "={{ $json.metrics.employees }}",
              "rightValue": 100
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "98578544-b03d-44aa-a64f-285f8a7cc371",
      "name": "Trigger every 5 minutes",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        540,
        280
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "minutes"
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "69ace950-7f1e-469b-bfca-6c0c81f356b9",
      "name": "Setup",
      "type": "n8n-nodes-base.set",
      "position": [
        820,
        280
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "dba31775-dce0-4f4c-ad61-790359197bb3",
              "name": "slackChannel",
              "type": "string",
              "value": "#yourChannel"
            },
            {
              "id": "f8206758-7a4f-414d-921c-6cfecd936335",
              "name": "domainCustomFieldId",
              "type": "string",
              "value": "<Run \"Show only custom organization fields\" and copy the key>"
            },
            {
              "id": "59c71724-f774-4d41-80e7-5fc76dd27c7d",
              "name": "enrichedAtCustomFieldId",
              "type": "string",
              "value": "<Run \"Show only custom lead fields\" and copy the key>"
            },
            {
              "id": "da4ec51e-cc5c-4512-b675-0888d6a0213e",
              "name": "enrichedAtCustomFieldId2",
              "type": "string",
              "value": "68a15ecb2e1255250617c1fd1c06385893334e3c"
            },
            {
              "id": "43544b80-88d3-44ad-9e36-634e9eeaf013",
              "name": "domainCustomFieldId2",
              "type": "string",
              "value": "ab26f671c92146268edacd244181e76579286e71"
            }
          ]
        }
      },
      "typeVersion": 3.3
    },
    {
      "id": "63db576a-6bb7-4215-88f3-98e304081b3e",
      "name": "Send alert to Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        2520,
        260
      ],
      "parameters": {
        "text": "=New high-quality lead \ud83e\udd11\n*Company Name*: {{ $json.name }} \n*Website*: {{ \"https://\" + $json.domain }}\n*Revenue*: {{ $json.metrics.estimatedAnnualRevenue}}\n*Number of employees*: {{ $json.metrics.employees }}",
        "select": "channel",
        "channelId": {
          "__rl": true,
          "mode": "name",
          "value": "={{ $('Setup').item.json.slackChannel }}"
        },
        "otherOptions": {}
      },
      "credentials": {
        "slackApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "9bef53b4-3732-4ce5-a72c-81c65a533196",
      "name": "Merge data",
      "type": "n8n-nodes-base.merge",
      "position": [
        1880,
        260
      ],
      "parameters": {
        "mode": "combine",
        "options": {
          "clashHandling": {
            "values": {
              "resolveClash": "preferInput2"
            }
          }
        },
        "joinMode": "enrichInput2",
        "mergeByFields": {
          "values": [
            {
              "field1": "organization_id",
              "field2": "organization_id"
            }
          ]
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "9c8d106a-ffc6-4295-bc22-8ceddeb0061f",
      "name": "Get organization details",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        1280,
        140
      ],
      "parameters": {
        "resource": "organization",
        "operation": "get",
        "organizationId": "={{ $json.organization_id }}"
      },
      "credentials": {
        "pipedriveApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "632477f4-77d1-4c87-a819-2f7022fa6f23",
      "name": "Get all organization keys",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        680,
        620
      ],
      "parameters": {
        "url": "https://api.pipedrive.com/v1/organizationFields",
        "options": {},
        "sendQuery": true,
        "authentication": "predefinedCredentialType",
        "queryParameters": {
          "parameters": [
            {}
          ]
        },
        "nodeCredentialType": "pipedriveApi"
      },
      "credentials": {
        "pipedriveApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.1
    },
    {
      "id": "f12c4e56-895d-4f34-8924-c99f5e5fefec",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        997,
        520
      ],
      "parameters": {
        "width": 187.68142318756514,
        "height": 276.3308728978709,
        "content": "Run me to find the Id of your custom domain field"
      },
      "typeVersion": 1
    },
    {
      "id": "229db444-ac48-4557-b393-4dcdc69130fd",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1597,
        520
      ],
      "parameters": {
        "width": 187.68142318756514,
        "height": 276.3308728978709,
        "content": "Run me to find the Id of your enriched at domain field"
      },
      "typeVersion": 1
    },
    {
      "id": "ea4b0c82-e52b-4a45-9d3f-7b28b8959574",
      "name": "Get all lead keys",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1260,
        620
      ],
      "parameters": {
        "url": "https://api.pipedrive.com/v1/leadFields",
        "options": {},
        "sendQuery": true,
        "authentication": "predefinedCredentialType",
        "queryParameters": {
          "parameters": [
            {}
          ]
        },
        "nodeCredentialType": "pipedriveApi"
      },
      "credentials": {
        "pipedriveApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.1
    },
    {
      "id": "a74a2122-ddd5-4239-baa3-ebbc3de15e03",
      "name": "Split out lead field data",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1440,
        620
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "data"
      },
      "typeVersion": 1
    },
    {
      "id": "84fded6b-bdeb-4863-b54c-01faf6cb64cc",
      "name": "Split out organization field",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        860,
        620
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "data"
      },
      "typeVersion": 1
    },
    {
      "id": "9d9c502e-ccf2-40f9-ae91-7008532e5528",
      "name": "Show only custom lead fields",
      "type": "n8n-nodes-base.filter",
      "position": [
        1640,
        620
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "b21201d0-7f9c-417c-ab02-fbaea23a8d24",
              "operator": {
                "type": "boolean",
                "operation": "true",
                "singleValue": true
              },
              "leftValue": "={{ $json.edit_flag }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "a53f58ee-9649-42bc-bee4-b70eea6a0c63",
      "name": "Show only custom organization fields",
      "type": "n8n-nodes-base.filter",
      "position": [
        1040,
        620
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "b21201d0-7f9c-417c-ab02-fbaea23a8d24",
              "operator": {
                "type": "boolean",
                "operation": "true",
                "singleValue": true
              },
              "leftValue": "={{ $json.edit_flag }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "f9fa198a-860c-460f-ae82-172c71b5a838",
      "name": "Mark lead as enriched in Pipedrive",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2100,
        260
      ],
      "parameters": {
        "url": "=https://api.pipedrive.com/v1/leads/{{ $json.id }}",
        "method": "PATCH",
        "options": {},
        "sendBody": true,
        "authentication": "predefinedCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "={{ $('Setup').first().json.enrichedAtCustomFieldId2 }}",
              "value": "={{ $now.format('yyyy-MM-dd') }}"
            }
          ]
        },
        "nodeCredentialType": "pipedriveApi"
      },
      "credentials": {
        "pipedriveApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.1
    }
  ],
  "connections": {
    "Setup": {
      "main": [
        [
          {
            "node": "Get all leads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge data": {
      "main": [
        [
          {
            "node": "Mark lead as enriched in Pipedrive",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get all leads": {
      "main": [
        [
          {
            "node": "Get organization details",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge data",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Enrich company": {
      "main": [
        [
          {
            "node": "Add Organization ID to data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get all lead keys": {
      "main": [
        [
          {
            "node": "Split out lead field data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Trigger every 5 minutes": {
      "main": [
        [
          {
            "node": "Setup",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get organization details": {
      "main": [
        [
          {
            "node": "Enrich company",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get all organization keys": {
      "main": [
        [
          {
            "node": "Split out organization field",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split out lead field data": {
      "main": [
        [
          {
            "node": "Show only custom lead fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add Organization ID to data": {
      "main": [
        [
          {
            "node": "Merge data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split out organization field": {
      "main": [
        [
          {
            "node": "Show only custom organization fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Keep leads that match the criteria": {
      "main": [
        [
          {
            "node": "Send alert to Slack",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Mark lead as enriched in Pipedrive": {
      "main": [
        [
          {
            "node": "Keep leads that match the criteria",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

Pro

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

How this works

This workflow automates the enrichment and filtering of leads in Pipedrive, helping sales teams identify high-potential prospects without manual effort, saving hours of research each week. It pulls leads from Pipedrive, enriches them with company details via Clearbit, and filters out those not matching your specific criteria, such as industry or size, to focus on qualified opportunities. The key step is the intelligent filtering node that applies your custom rules, ensuring only relevant leads proceed for actions like Slack notifications or further processing.

Use this workflow when you need to regularly scan and qualify leads from Pipedrive based on dynamic business criteria, such as targeting tech firms over 50 employees. Avoid it for one-off tasks or if your lead volume is too low to justify scheduling, as it runs every five minutes via cron trigger. Common variations include adjusting the filter for geographic regions or integrating additional data sources like HTTP requests for custom APIs.

About this workflow

Splitout Filter. Uses stickyNote, clearbit, pipedrive, scheduleTrigger. Scheduled trigger; 20 nodes.

Source: https://github.com/Zie619/n8n-workflows — original creator credit. Request a take-down →

More Slack & Telegram workflows → · Browse all categories →

Related workflows

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

Slack & Telegram

debug. Uses httpRequest, slack, redis, mailgun. Scheduled trigger; 60 nodes.

HTTP Request, Slack, Redis +2
Slack & Telegram

This workflow is an automated employee time tracking and reporting system that monitors weekly work hours via TMetric, then delivers personalized summaries directly to each team member on Slack. It co

HTTP Request, Item Lists, Data Table +1
Slack & Telegram

Import Productboard Notes Companies And Features Into Snowflake. Uses stickyNote, httpRequest, splitOut, snowflake. Scheduled trigger; 35 nodes.

HTTP Request, Snowflake, Slack
Slack & Telegram

Import Productboard Notes, Companies and Features into Snowflake. Uses stickyNote, httpRequest, splitOut, snowflake. Scheduled trigger; 35 nodes.

HTTP Request, Snowflake, Slack
Slack & Telegram

This workflow imports Productboard data into Snowflake, automating data extraction, mapping, and updates for features, companies, and notes. It supports scheduled weekly updates, data cleansing, and S

HTTP Request, Snowflake, Slack