AutomationFlowsMarketing & Ads › Clean Lead Pipeline

Clean Lead Pipeline

Clean Lead Pipeline. Uses httpRequest, postgres. Webhook trigger; 5 nodes.

Webhook trigger★★☆☆☆ complexity5 nodesHTTP RequestPostgres
Marketing & Ads Trigger: Webhook Nodes: 5 Complexity: ★★☆☆☆ Added:

This workflow follows the HTTP Request → Postgres 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
{
  "name": "Clean Lead Pipeline",
  "nodes": [
    {
      "id": "trigger-1",
      "name": "Webhook Start",
      "type": "n8n-nodes-base.webhook",
      "typeVersion": 2,
      "position": [
        200,
        200
      ],
      "parameters": {
        "path": "lint-clean",
        "httpMethod": "POST"
      }
    },
    {
      "id": "lookup-1",
      "name": "Look Up User By Id",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.1,
      "onError": "continueRegularOutput",
      "position": [
        400,
        200
      ],
      "parameters": {
        "method": "GET",
        "url": "https://api.example.com/users/{{$json.userId}}"
      }
    },
    {
      "id": "charge-1",
      "name": "Charge Customer",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.1,
      "retryOnFail": true,
      "maxTries": 5,
      "position": [
        600,
        200
      ],
      "parameters": {
        "method": "POST",
        "url": "https://api.stripe.com/v1/charges",
        "headerParameters": {
          "parameters": [
            {
              "name": "Idempotency-Key",
              "value": "={{$json.requestId}}"
            }
          ]
        }
      }
    },
    {
      "id": "save-1",
      "name": "Save To DB",
      "type": "n8n-nodes-base.postgres",
      "typeVersion": 2.3,
      "continueOnFail": true,
      "position": [
        800,
        200
      ],
      "parameters": {
        "operation": "insert",
        "schema": "public",
        "table": "leads"
      }
    },
    {
      "id": "log-error",
      "name": "Log Failure",
      "type": "n8n-nodes-base.set",
      "typeVersion": 3,
      "position": [
        600,
        400
      ],
      "parameters": {
        "values": {
          "string": [
            {
              "name": "status",
              "value": "error"
            }
          ]
        }
      }
    }
  ],
  "connections": {
    "Webhook Start": {
      "main": [
        [
          {
            "node": "Look Up User By Id",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Look Up User By Id": {
      "main": [
        [
          {
            "node": "Charge Customer",
            "type": "main",
            "index": 0
          }
        ]
      ],
      "error": [
        [
          {
            "node": "Log Failure",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Charge Customer": {
      "main": [
        [
          {
            "node": "Save To DB",
            "type": "main",
            "index": 0
          }
        ]
      ],
      "error": [
        [
          {
            "node": "Log Failure",
            "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

Clean Lead Pipeline. Uses httpRequest, postgres. Webhook trigger; 5 nodes.

Source: https://github.com/wranngle/n8n_showcase/blob/main/fixtures/lint/clean.json — 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

Wranngle Lead Intake (Centralized). Uses postgres, emailSend, httpRequest. Webhook trigger; 5 nodes.

Postgres, Email Send, HTTP Request
Marketing & Ads

Dirty Lead Pipeline. Uses httpRequest, postgres. Webhook trigger; 4 nodes.

HTTP Request, Postgres
Marketing & Ads

This workflow automates bulk email campaigns with built-in validation, deliverability protection, and smart send-time optimization.

HTTP Request, Postgres, Gmail
Marketing & Ads

get-data-for-marketting-dashboard. Uses postgres, googleAnalytics, httpRequest. Webhook trigger; 20 nodes.

Postgres, Google Analytics, HTTP Request
Marketing & Ads

Enrich person L3. Uses executeWorkflowTrigger, postgres, perplexity, httpRequest. Webhook trigger; 12 nodes.

Execute Workflow Trigger, Postgres, Perplexity +1