Weekly voice-of-customer report from Aircall calls
Every Monday, roll up last week's Aircall conversations into a themed voice-of-customer report, sent by email and posted to Slack.
Aircall
Gmail
SlackSalesCustomer SupportAI ReportsFeedback TriageDaily DigestsEvery Monday at 8am in the workspace's configured timezone, pull the last seven days of calls from Aircall using Search Calls. Filter by the relevant date range, page through all matching results with per_page up to 50, and stay inside Aircall's 10,000-item list cap and 120 requests-per-minute rate limit.
From that pool, sample the most signal-rich conversations: the longest calls and the most-tagged ones. Target roughly 30 to 60 calls per week so the intelligence retrievals stay comfortably inside the rate budget. For each sampled call, use the Conversation Intelligence add-on to retrieve its Call Summary, Call Sentiments, Call Topics, and Call Action Items. Pull the full Call Transcription only when you need a specific verbatim quote for the report.
Synthesize a voice-of-customer report that groups the week's recurring objections, feature requests, competitor mentions, and sentiment trends by tag and by team. Under each theme, include one or two representative quotes lifted directly from the transcripts, along with a rough count of how many calls the theme appeared in. Add week-over-week deltas by comparing this week's counts against last week's stored totals so trends are visible, not just this week's raw numbers. Lead the report with the biggest movers rather than the biggest absolute numbers.
Send the finished report to the leadership distribution list via Gmail using Send a Message, with a clear subject line and the full themed report in the body. Then post a short highlights version (top three themes, top three quotes, the biggest week-over-week deltas, and any red-flag sentiment shifts) to the designated Slack channel using Send a Message so managers see the takeaways even if they skip the email.
If any Conversation Intelligence retrieval returns 403, note in the report that the CI add-on is not enabled for the workspace and fall back to raw call metadata (tags, duration, direction, assigned user, team) for the tag and team breakdown so the run still produces a useful weekly view.
Additional information
What does this prompt do?
- Pulls last week's Aircall conversations and picks the calls with the most to say (the longest calls and the most-tagged ones)
- Groups the themes (objections, feature requests, competitor mentions, sentiment shifts) by tag and by team, with real quotes lifted from the transcripts
- Includes week-over-week changes so you see trends, not just this week's raw numbers
- Emails the full report to leadership and posts a short highlights version to Slack so managers see the takeaways even if they skip the email
What do I need to use this?
- An Aircall account with the Conversation Intelligence add-on enabled (needed for summaries, sentiment, topics, and action items)
- A Gmail account that can send to your leadership distribution list
- A Slack workspace and a channel where the weekly highlights should be posted
How can I customize it?
- The day, time, and timezone the report runs
- Which tags or teams the report groups by, and how many calls to sample each week
- The Gmail recipient list and the Slack channel that receives the highlights
Frequently asked questions
Do I need Aircall's Conversation Intelligence add-on?
What if my team makes thousands of calls a week?
Can I change who receives the report?
Does the report show trends over time, or just this week?
Can I run this daily or monthly instead of weekly?
Related templates
Turn every week of sales calls into a voice-of-customer briefing.
Stop scrolling through call logs to figure out what customers are saying. Get the themes, the quotes, and the trend lines delivered every Monday morning.