TICKET MANAGEMENT

Real-Time Duplicate Detector for Front Conversations

When a new Front conversation arrives, it embeds the message, searches recent open conversations for near-matches.

CategoryTicket Management
Enginesim
Difficultyintermediate
Triggerwebhook
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerNew Front conversation createdFront
  • ActionEmbed subject + first message with OpenAIOpenAI
  • ActionVector-search open conversations in PostgresPostgreSQLPostgres
  • LogicKeep only matches above similarity threshold
  • ActionGenerate duplicate rationaleOpenAI
  • OutputPost merge suggestion with approve buttons to SlackSlack

What it does

Every time a customer opens a new Front conversation, this workflow checks whether it is likely a duplicate of another open ticket. If it finds a strong match, it sends the agent a one-click merge suggestion in Slack instead of letting two agents work the same issue.

When to use it

Use it when your support inbox gets repeat contacts (a customer emails, then replies from a second address, or two teammates report the same outage). It cuts double-handling without auto-merging anything you haven't approved.

How it works

  1. 1A Front inbound-message webhook fires when a conversation is created.
  2. 2OpenAI generates an embedding of the subject and first message body.
  3. 3The workflow queries a Postgres pgvector table of embeddings for open conversations and ranks candidates by cosine similarity.
  4. 4A similarity threshold filters out weak matches; only pairs above the cutoff continue.
  5. 5For a strong match, OpenAI writes a short rationale explaining why the two look like duplicates.
  6. 6A Slack message posts to the support channel with both conversation links and Merge / Not a duplicate buttons for the assigned agent.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect FrontShared inbox, conversations.
  2. 2
    Connect OpenAIModels, embeddings, files.
  3. 3
    Connect PostgresAny Postgres URL — query, write, migrate.
  4. 4
    Connect SlackChannels, DMs, threads, mentions.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.