CUSTOMER SUPPORT
Weekly Zendesk Macro-Gap Miner to Notion Backlog
Every Monday, scans the past week of solved Zendesk tickets for free-text agent replies that cluster around the same answer but have no matching saved macro.
How it runs
The automated pipeline, trigger to output.
- TriggerMonday weekly schedule fires
- ActionFetch last week's solved tickets + first agent repliesZendesk
- ActionPull existing macro catalogZendesk
- ActionEmbed and cluster similar repliesOpenAI
- LogicDrop clusters matching a macro; keep high-volume gaps
- OutputWrite ranked macro candidates to Notion backlogNotion
What it does
It surfaces the answers your agents keep retyping by hand. Each week it pulls solved tickets, isolates the first agent reply on each, embeds and clusters those replies, and checks every cluster against your existing macro library. Clusters with high volume and no close macro match become ranked "macro candidates" written to a Notion backlog with example replies and estimated time saved.
When to use it
Run it when your macro library has gone stale and agents are clearly reinventing the same responses. Ideal for support leads who own macro hygiene and want a steady, evidence-backed queue instead of guessing which canned responses to write next.
How it works
- 1A Monday schedule fires the run.
- 2Fetch all tickets solved in the last 7 days from Zendesk, including first public agent comments.
- 3Pull the current macro catalog from Zendesk to compare against.
- 4Embed replies with OpenAI and cluster the semantically similar ones.
- 5A logic step drops clusters whose centroid closely matches an existing macro, keeping only true gaps above a volume threshold.
- 6Write each surviving gap as a ranked Notion backlog item with sample replies and frequency.
Set it up
What you configure once, before turning it on.
- 1Connect ZendeskTickets, queues, knowledge base.
- 2Connect OpenAIModels, embeddings, files.
- 3Connect NotionPages, databases, comments.
- 4Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 5Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 6Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Customer Support workflows
Send a tailored Loom onboarding sequence on Front first-reply
When a new customer's first email lands in Front, this picks the Loom onboarding walkthroughs matching their plan and use case, builds a friendly sequenced reply.
Suggest the right Loom video by classifying Intercom message intent
Reads each new inbound Intercom conversation, classifies what the customer is trying to do, and surfaces the best-matching Loom walkthrough to the agent as an internal note.
Draft personalized fix-live replies for support to review
When a Sentry issue resolves, an agent reads each linked ticket's full thread and drafts a tailored 'your fix is live' reply per requester.
Close the loop with requesters when a Linear bug moves to Done
When a Linear issue created from a support escalation moves to Done after deploy, look up the originating Zendesk tickets and notify each requester that their reported bug is…
Reopen and notify Front conversations when their bug fix deploys
When a deploy resolves a Sentry issue, find the snoozed or closed Front conversations linked to it, reopen them, and send the customer a reply that the fix is now live.
Tell Intercom users their reported bug shipped after a Vercel deploy
On a successful Vercel production deployment, match the release's resolved Sentry issues to Intercom conversations and message each affected user that their reported issue is…
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.

Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.
