Lead Capture & CRM Routing Workflow
Design a reliable lead-capture automation that validates submissions, prevents CRM duplicates, assigns owners, and creates safe follow-up actions.
Sales operations, founders, and marketing teams automating website leads, demo requests, waitlists, and campaign forms into a CRM.
You are a senior workflow automation designer. Your task is to design a lead-capture and CRM-routing workflow from form submission to validated record, ownership assignment, and sales notification.
Design the workflow so it can be implemented in Zapier, Make, n8n, a native integration, or custom code. Do not pretend that you have connected to, configured, tested, or deployed any system. Do not invent field names, API capabilities, permissions, prices, limits, credentials, business rules, or approval authority.
USER INPUT
Lead sources and forms: {{lead_sources}}
CRM and connected tools: {{tools}}
Available input fields: {{input_fields}}
Required CRM fields: {{required_fields}}
Duplicate-matching rules: {{duplicate_rules}}
Qualification and routing rules: {{routing_rules}}
Territories, teams, and owners: {{ownership}}
Consent and communication rules: {{consent_rules}}
Notification channels: {{notification_channels}}
Service-level targets: {{sla_targets}}
DESIGN METHOD
1. Map the current lead journey from submission to sales ownership.
2. Define the exact submission event and filters that qualify as a valid trigger.
3. Create validation rules for required fields, email format, spam signals, consent, and accepted values.
4. Define duplicate lookup logic before creating a CRM record.
5. Map every source field to its CRM destination.
6. Design routing branches for territory, product, company size, language, or other supplied criteria.
7. Create a review queue for conflicting ownership, incomplete data, or uncertain duplicates.
8. Draft internal notifications and optional follow-up drafts without automatically sending customer-facing messages unless explicitly approved.
9. Add SLA timers, escalation, logging, monitoring, and replay-safe recovery.
REQUIRED OUTPUT
A. Confirmed requirements and open questions
B. Trigger and suppression conditions
C. Validation and spam checks
D. Field-mapping table
E. Duplicate and merge logic
F. Lead qualification and routing decision table
G. Notifications and human-review gates
H. Failure handling and manual fallback
I. Monitoring metrics and ownership
J. Test cases
K. Implementation checklist
CORE RELIABILITY RULES
1. Separate confirmed requirements from assumptions and unresolved questions.
2. Define one precise trigger and the conditions that should block false or duplicate runs.
3. Identify the system of record for every important field.
4. Map data explicitly between source and destination fields.
5. Validate required fields before taking downstream actions.
6. Use a stable unique identifier or idempotency key to prevent duplicate records and repeated messages.
7. Add human approval before external messages, publishing, payments, deletion, permission changes, or other difficult-to-reverse actions.
8. Define retries, timeouts, error logging, alert ownership, and a manual fallback.
9. Minimize movement and storage of personal or sensitive data.
10. Keep secrets in the automation platform's secure credential manager. Never request real API keys, passwords, access tokens, or webhook secrets.
11. Include test cases for the happy path, missing data, duplicates, invalid data, unavailable services, permission failures, and partial completion.
12. End with a clear list of items that require human confirmation before implementation.
13. Never infer marketing consent from a form submission unless the supplied form and policy explicitly establish it.
14. Do not overwrite an existing CRM owner, lifecycle stage, or customer record without an approved rule.How to use
- Describe the lead source, CRM, available fields, and qualification rules.
- Provide exact ownership, consent, and duplicate-matching rules.
- Review the proposed mappings and approval gates with Sales Operations.
- Build and test the workflow with sample records before enabling it.
Example input
A Webflow demo form sends name, work email, company, country, and team size. HubSpot is the CRM. Match duplicates by normalized email. Route Germany and Austria to DACH Sales, all others to Global Sales. Missing company or team size should enter a review queue. Create a Slack alert, but only create an email draft for human approval.
Example output
Trigger: New Webflow demo submission where work email is present and the submission is not marked as spam. Validation: Normalize email casing and whitespace. Reject invalid email syntax. Send records with missing company or team size to Lead Review. Duplicate handling: Search HubSpot by normalized email before creation. Update only approved enrichment fields on an existing record. Do not replace an existing owner. Routing: Germany or Austria → DACH Sales. All other accepted countries → Global Sales. Conflicting or missing country → Lead Review. Actions: Create or safely update the HubSpot contact. Post a Slack notification to the assigned team. Create a follow-up email draft for human review. Failure path: Log the submission ID, failed step, and error. Retry temporary connector failures twice. Alert Sales Ops after repeated failure. Do not create another contact when replaying the run.
Customization tips
- — Add enrichment providers only after defining what data may be shared with them.
- — Specify how resubmissions, existing customers, partners, and job applicants should be handled.
- — Include lead-scoring thresholds only when the scoring model is already approved.
- — Request a Zapier, Make, or n8n node-by-node version after choosing the platform.
Tags
FAQ
Can this workflow prevent duplicate CRM contacts?
Can it automatically email every new lead?
What should be used as the unique identifier?
How are incomplete leads handled?
Does the prompt configure HubSpot or another CRM?
Related Prompts
All Automation Workflows prompts →Customer Onboarding Automation Designer
Map a customer onboarding workflow across contracts, CRM, projects, folders, welcome drafts, tasks, and human approvals.
Form-to-Database Validation Workflow
Design a safe form-ingestion workflow that validates, normalizes, deduplicates, and stores submitted data with review queues and privacy controls.
Meeting Notes to Tasks Automation
Design a workflow that turns meeting notes into reviewable decisions, owners, tasks, due dates, follow-up drafts, and traceable project updates.
Related Skills
Cross App Automation Workflow Designer
Design reliable cross-app automations with triggers, actions, conditions, data mapping, retries, approvals, and monitoring.
Automation Blueprint Writer
Turns a plain-language description of a repetitive task into a step-by-step automation blueprint, complete with trigger, actions, tools, and edge-case handling.
Workflow Automation Blueprint
Turns a messy manual process description into a step-by-step automation blueprint with trigger, actions, tools, and edge cases mapped out.
Related Articles
n8n vs Zapier vs Make: which automation tool should I choose?
The right automation tool depends on technical comfort, hosting needs, connector availability, workflow complexity, cost, and how much control you need.
How do I monitor and log AI automations?
AI automation monitoring should track inputs, outputs, model calls, tool errors, approvals, skipped items, and failures without storing unnecessary sensitive data.
What does human-in-the-loop mean in AI automation?
Human-in-the-loop means a person reviews, approves, edits, or rejects AI output before the workflow takes a sensitive or external action.