Data Sync & ETL
Sync customer and vendor master data between ERP and CRM via webhook
Receives customer or vendor changes by webhook, deduplicates and resolves conflicts, syncs them to target systems, verifies the sync, and returns an audit report.
What it does
## Cross-Company Master-Data Synchronization Receives customer or vendor master-data changes, normalizes and matches records, resolves conflicts, synchronizes to target systems, verifies the sync, and returns a full audit report. ### All nodes (1-line each) 1. Webhook - Master Data Change – Receives customer or vendor master-data payload via POST. 2. Code - Validate & Normalize – Validates the payload and normalizes fields into a canonical model. 3. Code - Match & Deduplicate – Matches the incoming record against existing golden records using keys and fuzzy rules. 4. Wait - Pre Conflict Check – Short pause before conflict evaluation. 5. Code - Detect Conflicts – Identifies field-level conflicts between incoming data and the golden record. 6. Wait - Pre Sync – Pause before writing to target systems. 7. HTTP Request - Sync to ERP – Pushes the resolved master record to the ERP system. 8. Code - Process ERP Result – Records ERP sync outcome. 9. Wait - Pre CRM Sync – Pause before CRM synchronization. 10. HTTP Request - Sync to CRM – Pushes the resolved master record to the CRM system. 11. Code - Process CRM Result – Records CRM sync outcome. 12. Wait - Pre Verify – Pause before verification. 13. HTTP Request - Verify Sync – Confirms the record exists and matches in target systems. 14. Code - Build Sync Report – Aggregates match, conflict, sync and verification results into a final report. 15. Code - Finalize Response – Assembles the response payload for the caller. 16. Respond to Webhook – Returns the complete master-data synchronization result.
The steps
- Webhook - Master Data Change
- Code - Validate & Normalize
- Code - Match & Deduplicate
- Wait - Pre Conflict Check
- Code - Detect Conflicts
- Wait - Pre Sync
- HTTP Request - Sync to ERP
- Code - Process ERP Result
- Wait - Pre CRM Sync
- HTTP Request - Sync to CRM
- Code - Process CRM Result
- Wait - Pre Verify
- HTTP Request - Verify Sync
- Code - Build Sync Report
16 steps in total.
Similar automations
E-commerce & PaymentsRoute store webhook orders to supplier, shipping, CRM and ERP with stock checks24 stepsAI Agents & AssistantsScore supplier risk and route approvals with OpenAI, Slack and ERP data57 stepsData Sync & ETLSync ERP orders from SQL Server to Postgres and alert Finance on Slack19 stepsEmail AutomationDraft weekly vendor update emails from Google Sheets using OpenAI and Gmail10 steps