CUSTOMER SUPPORT

Convert Failed Help-Center Searches into a Ranked Article Backlog

Reads logged help-center search queries that returned no results, clusters the recurring misses.

CategoryCustomer Support
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily schedule fires
  • ActionQuery Postgres for yesterday's zero-result searchesPostgreSQLPostgres
  • ActionCluster queries and count occurrencesOpenAI
  • LogicDrop clusters below frequency threshold
  • ActionDraft an article outline per clusterOpenAI
  • OutputCreate a Linear issue per cluster, priority by hit countLinearLinear

What it does

Customers type questions into your help-center search bar and sometimes get nothing back. This workflow reads those zero-result queries from a Postgres analytics table, clusters the ones that repeat, and creates a Linear issue for each cluster. Every issue carries the raw queries, a hit count, and an OpenAI-drafted article outline so a writer can start immediately. Higher-frequency gaps get higher priority.

When to use it

Use it when your help center has search but no feedback loop. Zero-result searches are the cleanest possible demand signal for missing docs, and this turns them into a backlog the docs team can burn down in order of real customer need.

How it works

  1. 1A daily schedule starts the run.
  2. 2Query the Postgres search-log table for yesterday's zero-result queries.
  3. 3Cluster near-duplicate queries and count occurrences per cluster with OpenAI.
  4. 4Filter out clusters below a frequency threshold.
  5. 5Draft a short article outline for each remaining cluster.
  6. 6Create one Linear issue per cluster with priority set from hit count.

Set it up

What you configure once, before turning it on.

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