CUSTOMER SUPPORT
Weekly CSAT Rollup Report to Google Drive
Every Monday, pull the past week's CSAT responses from Zendesk, summarize trends and top detractor themes with OpenAI, and save a formatted report to a shared Google Drive folder.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly schedule (Monday 7am)
- ActionPull last 7 days of CSAT ratings from ZendeskZendesk
- LogicCompute CSAT rate, delta, and split sentiment
- ActionSummarize detractor themes with OpenAIOpenAI
- OutputSave dated report to Google Drive folderGoogle Drive
What it does
On a weekly schedule, this collects all CSAT survey responses from the previous seven days, computes the satisfaction rate and response count, and uses OpenAI to cluster the negative comments into recurring themes. The result is written as a dated report document into a shared Google Drive folder your team already reviews.
When to use it
Use this when leadership wants a regular pulse on support quality without anyone manually exporting and charting survey data. It replaces the Friday-afternoon spreadsheet scramble with an automatic Monday-morning brief.
How it works
- 1A schedule trigger runs every Monday at 7am in your team's timezone.
- 2An action queries Zendesk for all satisfaction ratings submitted in the trailing week.
- 3A logic step computes the CSAT percentage, week-over-week delta, and splits comments into promoters and detractors.
- 4An OpenAI step summarizes detractor comments into ranked themes with example quotes.
- 5The final step writes the dated rollup as a document into the shared Google Drive reports folder.
Set it up
What you configure once, before turning it on.
- 1Connect ZendeskTickets, queues, knowledge base.
- 2Connect OpenAIModels, embeddings, files.
- 3Connect Google DriveDocs, sheets, slides, files.
- 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.