Weekly voice-of-customer report from Aircall calls

Every 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.