Secure Web Form to Odoo CRM Leads with UTM Tracking

This workflow transforms web form submissions into Odoo CRM leads using a secure webhook endpoint protected by header authentication (x-webhook-token). It receives POST data including essential fields like firstname, lastname, email, phone, and optional UTMs (utm.source, utm.medium, utm.campaign). Upon ingestion, it validates required fields; invalid requests return a 400 Bad Request response immediately.

Next, it performs targeted Odoo API lookups to resolve UTM parameters by name, fetching source_id, medium_id, and campaign_id. If a UTM doesn't exist, it gracefully sets the ID to null, ensuring the workflow doesn't fail. Data is then consolidated via Merge and Code nodes into a clean object with fields like name, contact_name, email_from, phone, description, type: 'lead', and the resolved UTM IDs.

Finally, it creates the crm.lead record in Odoo and responds with a 200 success status. Benefits include production-ready security, automatic UTM tracking for marketing attribution, reduced manual data entry, and seamless integration without custom coding. Ideal for websites, landing pages, or apps funneling leads into Odoo CRM, saving hours on setup and ensuring data integrity for sales teams.