CUSTOMER SUPPORT

Audit macros for low usage and stale wording

Monthly, compares each Zendesk macro's usage stats against recent ticket trends, flags unused or outdated macros, and files a cleanup report in Notion for the support lead.

CategoryCustomer Support
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerMonthly schedule fires
  • ActionPull macros and usage from ZendeskZendeskZendesk
  • ActionPull current ticket topic trendsSupabaseSupabase
  • ActionFlag stale and redundant macrosOpenAI
  • LogicRank findings by impact
  • OutputPublish cleanup report to NotionNotionNotion

What it does

Keeps your macro library lean. Once a month it checks which macros are actually being used, which haven't fired in ages, and which describe a product behavior that has since changed, then writes a prioritized cleanup list.

When to use it

Run it when your macro list has grown faster than anyone's appetite to prune it, and agents complain they can't find the right one. Good hygiene for teams with hundreds of macros.

How it works

  1. 1A monthly schedule starts the audit.
  2. 2Pull every macro plus its usage counts from Zendesk.
  3. 3Pull recent solved-ticket topic frequencies from Supabase to see what customers ask about now.
  4. 4Send both lists to OpenAI to flag macros that are unused, redundant, or describe outdated behavior, with a recommended action each.
  5. 5Rank findings by impact so the lead tackles the worst offenders first.
  6. 6Write the report as a new page in Notion and link it for review.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect ZendeskTickets, queues, knowledge base.
  2. 2
    Connect SupabaseTables, auth, storage, edge functions.
  3. 3
    Connect OpenAIModels, embeddings, files.
  4. 4
    Connect NotionPages, databases, comments.
  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.