Automate Odoo Contact Deduplication with n8n Workflow

Transform your Odoo contact management from a time-consuming nightmare into a streamlined, automated process with this powerful n8n workflow that automatically identifies, merges, and cleans duplicate contacts in your database.

What this workflow does

This automation workflow tackles the administrative burden of maintaining clean Odoo contact records through intelligent deduplication:

• Automatically scans your entire Odoo database to identify duplicate contacts based on phone numbers
• Executes Odoo's native Merge Wizard via JSON-RPC API to consolidate duplicate records seamlessly
• Identifies and archives invalid contacts with missing names, phone numbers, or containing only symbols
• Groups valid contacts by phone numbers and processes duplicates in organized batches
• Eliminates hours of repetitive manual work while ensuring data integrity

Use cases

Perfect for organizations struggling with:

• Sales teams dealing with confused customer communications due to duplicate records
• Accounting departments facing invoicing errors from multiple contact entries
• Marketing teams needing accurate reporting without inflated contact counts
• Customer service representatives managing fragmented customer histories
• Database administrators maintaining clean CRM data at scale

Technical details

This n8n workflow leverages multiple specialized nodes for comprehensive contact deduplication:

• Manual Trigger: Initiates the deduplication process on-demand
• Odoo nodes: Fetches active partner records from your Odoo database
• Code nodes: Custom filtering logic to identify invalid contacts and group duplicates by phone numbers
• HTTP Request nodes: Interfaces with Odoo's JSON-RPC API to create and execute merge wizards
• IF nodes: Conditional logic for processing different contact scenarios
• Sticky Note: Documentation and workflow guidance

Setup requires connecting your Odoo API credentials and ensuring proper access rights for res.partner record operations. Simply update the HTTP Request node URLs to match your Odoo domain, and you're ready to automate your contact deduplication process.