About

Overview: I’m looking for an experienced automation engineer to build a two-way data sync system using n8n that keeps customer data consistent across Shopify, GHL (GoHighLevel), Gorgias, and Airtable. The Airtable base will act as the Golden Record, but changes should flow both ways — updates from any source should reflect in all connected systems automatically. 🧩 Scope of Work Inbound Sync (3 → 1) Pull contacts from Shopify, GHL, and Gorgias into Airtable. Match and deduplicate by Email + Phone. Create or update a single “Golden Record” entry in Airtable. Apply missing Shopify phone numbers from shipping addresses where needed. Outbound Sync (1 → 3) When the Golden Record is updated (e.g., name corrected, phone added, discount applied, etc.), push those changes back to Shopify, GHL, and Gorgias. Ensure checkout events in Shopify update the customer’s corresponding records in Gorgias and GHL (e.g., contact info, tags, last purchase date). Communication Data Sync texts and call logs from GHL into Gorgias tickets, so the full communication history is visible per customer. Automation Logic Implement webhook triggers where possible (real-time) and scheduled syncs where APIs require polling. Include smart field-update rules (e.g., “prefer Airtable phone if missing in Shopify,” “don’t overwrite if source field has recent activity”). Documentation & Handoff Deliver a clear field-mapping sheet. Provide full n8n JSON exports. Include setup walkthrough or Loom video. ✅ Deliverables Working n8n flows for inbound and outbound sync. Airtable schema aligned for contact unification. Deduplication and field precedence logic implemented. Real-time or near-real-time sync established. Documentation and test validation. 💡 Ideal Candidate Deep experience with n8n or Make (Integromat) building multi-API syncs. Prior work integrating Shopify Admin API, Gorgias API, GHL API, and Airtable API. Strong understanding of contact identity resolution and data normalization. Ability to handle conditional logic for field preference and sync direction. 🚀 Bonus Points Familiarity with bi-directional CRM synchronization patterns. Experience setting up Golden Record / CDP architectures. Familiar with Shopify webhooks (checkout creation / update events).