CRM

Detect Intercom topic spikes and open Linear issues for product

Classifies new Intercom conversations by topic, tracks rolling volume in Postgres.

CategoryCRM
Enginesim
Difficultyadvanced
Triggerwebhook
Steps5
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerIntercom conversation.closed webhook firesIntercomIntercom
  • ActionClassify conversation topic with OpenAIOpenAI
  • ActionUpsert daily topic count in PostgresPostgreSQLPostgres
  • LogicCompare today's volume to trailing baseline
  • OutputOpen a Linear issue on a topic spikeLinearLinear

What it does

Backfilled topic data is only useful if someone acts on it. This workflow turns the live topic stream into an early-warning system: it classifies each closed conversation, increments a per-topic daily counter in Postgres, and compares today's volume to the trailing baseline. When a topic spikes meaningfully, it opens a Linear issue with example conversations attached so product can investigate.

When to use it

Use it when recurring support themes should become product signals instead of dying in a CRM field. Pairs well with the per-contact tagging workflows that keep topics fresh.

How it works

An Intercom `conversation.closed` webhook fires. OpenAI labels the topic. The workflow upserts the daily count for that topic into Postgres and reads the trailing 14-day baseline. A logic step checks whether today's count exceeds the baseline by the configured multiplier; non-spikes end here. On a spike, the output step creates a Linear issue titled with the topic, body containing the trend and linked example conversations.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect IntercomConversations, contacts, articles.
  2. 2
    Connect OpenAIModels, embeddings, files.
  3. 3
    Connect PostgresAny Postgres URL — query, write, migrate.
  4. 4
    Connect LinearIssues, projects, cycles, triage.
  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.