Webflow to HubSpot/Salesforce Lead Dedup with Gmail Alerts

Turn Webflow form leads into clean HubSpot/Salesforce records—with dedup, validation, and Gmail alerts

This n8n workflow receives Webflow form submissions via webhook, normalizes and validates the lead data, then creates or updates the matching HubSpot contact or Salesforce lead/contact—while actively preventing duplicates and sending sanitized Gmail failure alerts plus a daily heartbeat for monitoring.

What this workflow does

• Receives submissions via HTTP POST webhook from Webflow.
• Normalizes and validates lead fields (including email, phone, and attribution fields), checks required fields, and classifies each submission as accepted, rejected, or quarantined based on validation and spam/disposable-email signals.
• Prevents risky CRM writes: returns an immediate webhook response without creating/updating CRM records:
  • 400 for invalid data (rejected)
  • 202 for quarantined submissions
• HubSpot mode (configured): upserts a HubSpot contact using email as the unique identifier, with retries for transient failures.
• Salesforce mode (configured): searches Salesforce Leads and Contacts by email, then:
  • updates an existing Lead
  • creates a new Lead
  • returns 202 review_required for ambiguous matches or when a Contact already exists
• Successful writes: returns 200 with the CRM result when a record is created or updated.
• Operational error handling: on normalization, CRM read/write, or response preparation issues, it sends a sanitized error report via Gmail and marks the execution as failed for visibility and retry.
• Monitoring: runs every 24 hours and sends a Gmail heartbeat email.

Use cases

• Webflow lead capture with automatic CRM sync to HubSpot or Salesforce.
• Deduplication using email to avoid duplicate contacts/leads.
• Rejecting or quarantining disposable/spam-prone submissions before they hit your CRM.
• Auditable operations via Gmail failure alerts and daily heartbeat monitoring.

Technical details

• Nodes / integrations: Webhook, Code, If, Gmail, HubSpot, Salesforce
• Key behavior: dedup with email identifier; quarantine/reject webhook responses; sanitized Gmail alerts; scheduled 24-hour monitoring.