TICKET MANAGEMENT

Real-time duplicate detection on new Front conversations

When a new Front conversation arrives, it embeds the message, searches a vector store of recent tickets for near-matches.

CategoryTicket Management
Enginesim
Difficultyintermediate
Triggerevent
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerNew Front conversation createdFront
  • ActionEmbed subject + body with OpenAIOpenAI
  • ActionVector-search recent open ticketsPostgreSQLPostgres
  • LogicKeep matches above similarity threshold
  • ActionDraft merge rationaleOpenAI
  • OutputPost private merge-suggestion comment in FrontFront

What it does

Every time a customer opens a new Front conversation, this workflow checks whether it's a duplicate of an existing open ticket and, if so, drops a private internal comment on the new conversation suggesting which ticket(s) to merge it into.

When to use it

Run this on inbound support inboxes where the same outage, bug, or billing event triggers a flood of near-identical tickets. It stops agents from independently working the same issue and keeps one canonical thread.

How it works

  1. 1A Front webhook fires when a new conversation is created, passing the subject and first message body.
  2. 2OpenAI generates an embedding of the subject plus body text.
  3. 3A Postgres query (pgvector) finds the top open tickets within a cosine-similarity threshold from the last 14 days.
  4. 4A logic step keeps only matches above 0.86 similarity; if none clear the bar, the run ends quietly.
  5. 5OpenAI drafts a short rationale naming each candidate and why it looks like the same issue.
  6. 6The workflow posts a private internal comment on the Front conversation with the ranked candidates and one-click merge links.

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
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    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.