{"product_id":"appdor-enquiry-form-to-email-alerts-via-n8n-workflow-automation","title":"Appdor Enquiry Form to Email Alerts via n8n Workflow Automation","description":"\u003ch3\u003eAppdor enquiry forms to automated email alerts—with duplicate-safe n8n routing\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures new and returning enquiries via an n8n Form, checks for duplicates in your Appdor database, preserves existing status, and sends the right email notifications to your fixed Sales\/Support\/Billing inboxes (or an escalation inbox for urgent requests). It also stops safely when lookups, saving, or email delivery fail—so you don’t create messy records or notify the wrong team.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects enquiry details\u003c\/strong\u003e (Name, Email, Message, Enquiry type, Priority) through an \u003cstrong\u003en8n Form\u003c\/strong\u003e with required value validation, length limits, and configured category\/priority enforcement (Sales, Support, Billing; Normal or Urgent).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and de-duplicates\u003c\/strong\u003e the submitted email (trimmed, case-insensitive) and queries Appdor for up to \u003cstrong\u003etwo\u003c\/strong\u003e matches.\u003c\/li\u003e\n  \u003cli\u003e\n    \u003cstrong\u003eHandles match outcomes safely\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eZero matches\u003c\/strong\u003e: creates a new enquiry.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eOne match\u003c\/strong\u003e: updates the latest enquiry using the returned record version and \u003cstrong\u003epreserves existing Status\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eTwo matches\u003c\/strong\u003e: stops for \u003cstrong\u003ehuman duplicate review\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfirms the saved record ID\u003c\/strong\u003e before notifying teams.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes notifications\u003c\/strong\u003e by priority:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eNormal\u003c\/strong\u003e → fixed Sales\/Support\/Billing inbox\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eUrgent\u003c\/strong\u003e → fixed escalation inbox\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends notification emails with routing metadata\u003c\/strong\u003e including the record ID, while excluding submitted names, email addresses, and message content.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate enquiry handling for a SaaS landing page using n8n Form inputs.\u003c\/li\u003e\n  \u003cli\u003ePrevent duplicate Appdor records with case-insensitive email matching and a “two matches” human review stop.\u003c\/li\u003e\n  \u003cli\u003eEscalate high-priority enquiries to a dedicated inbox while keeping normal enquiries routed to the correct team.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ approach:\u003c\/strong\u003e \u003cem\u003eform trigger\u003c\/em\u003e, \u003cem\u003eHTTP request\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e (validation\/normalization\/duplicate logic), \u003cem\u003eemail send\u003c\/em\u003e, and a \u003cem\u003esticky note\u003c\/em\u003e for workflow clarity.\u003c\/li\u003e\n  \u003cli\u003eIncludes separate \u003cstrong\u003eStop And Error\u003c\/strong\u003e branches for \u003cstrong\u003elookup\u003c\/strong\u003e, \u003cstrong\u003esave\u003c\/strong\u003e, and \u003cstrong\u003eSMTP\u003c\/strong\u003e failures.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomatic retries are disabled\u003c\/strong\u003e; notification is retried only after an SMTP failure, and the form confirms success only after successful notification.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46086684180659,"sku":"N8N-19838","price":61.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/OTWuaVry7BpzkfrK4V6ra_4rn1RNeZ.png?v=1790327970","url":"https:\/\/buyflowscripts.com\/products\/appdor-enquiry-form-to-email-alerts-via-n8n-workflow-automation","provider":"N8N Commerce","version":"1.0","type":"link"}