CRM

Publish a weekly Intercom friction roundup to Notion

Each week the workflow reviews closed Intercom conversations, has an LLM cluster them into ranked product-friction themes with example quotes.

CategoryCRM
Enginesim
Difficultybeginner
Triggerschedule
Steps5
Setup~5 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWeekly schedule
  • ActionList conversations closed this weekIntercomIntercom
  • ActionCluster into ranked themes with quotesOpenAI
  • LogicFormat clusters into Notion blocks
  • OutputPublish dated roundup page to NotionNotionNotion

What it does

On a weekly schedule it collects the week's closed Intercom conversations, uses an LLM to cluster them into the top product-friction themes ranked by volume, and writes a clean Notion page with each theme, its share of conversations, affected account count, and a few verbatim customer quotes.

When to use it

Use this to feed a recurring product or leadership review with a digest of what customers complained about, without anyone manually reading the queue. Good for teams that run weekly triage and want a durable, linkable record of friction over time.

How it works

  1. 1A weekly schedule triggers the run.
  2. 2The workflow lists conversations closed during the past week and pulls transcripts plus account names.
  3. 3An LLM clusters the threads into ranked friction themes with counts and representative quotes.
  4. 4A formatting step shapes the clusters into Notion blocks (heading, table, quote callouts).
  5. 5The roundup is published as a new dated page in the team's Notion database.

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 NotionPages, databases, comments.
  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.