Templates / Manage idempotent lead intake via webhook, Postgres, and HTTP APIs

Manage idempotent lead intake via webhook, Postgres, and HTTP APIs

Ready for 3.0

by Oneclick AI Squad ✓ · 14 views · created 2026-10-06 · Lead Generation, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 15 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Postgres.

How it runs

Trigger: When an HTTP POST request hits its webhook URL.

  1. Postgres: run a query
  2. Code: runs custom JavaScript code
  3. Postgres: run a query
  4. Code: runs custom JavaScript code
  5. If: checks a condition and branches into true / false
  6. HTTP Request: calls an HTTP API (POST)
  7. Respond to Webhook: sends the response back to the webhook caller
  8. Wait: waits 2 seconds
  9. Code: runs custom JavaScript code
  10. HTTP Request: calls an HTTP API (POST)

…plus 4 more steps. See the full node list below.

Services it uses

Postgres

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (7)

From the author

Quick overview This workflow receives lead submissions via a webhook and uses PostgreSQL to enforce idempotency so the same Idempotency-Key is processed at most once, replaying stored results on retries. For newly claimed requests, it calls external…

Excerpt from Oneclick AI Squad's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.