Project Overview: An advanced inbound pipeline

Project Overview: An advanced inbound pipeline engineered to protect CRM integrity. This system introduces idempotency-based deduplication searches, automatic deal stage creation, and split-branch routing to handle repeat traffic without polluting sales boards.

Architecture & Key Features:

Idempotency-Based Deduplication: Searches the CRM using a hashed idempotency key rather than just an email address, closing the gap on double-clicks and webhook misfires that standard deduplication misses.

Split-Branch Traffic Routing: Safely merges duplicate checks—routing known prospects to an audit sheet and acknowledging their repeat inquiry, while pushing net-new leads through to active sales creation.

Dynamic Pipeline Creation: Automatically generates a new "Deal" and assigns it to the correct pipeline stage ("New Lead In") in HubSpot or Airtable the moment a net-new lead is verified.

Decoupled Error Failover: Native integration with a standalone error-trigger workflow that intercepts node crashes and logs execution details independently of the CRM.