How to send a weekly Slack report on HubSpot sequence performance

Why report on sequence performance?

Your outbound sequences are a core revenue driver, but most teams only check performance when something feels off — by then, a bad sequence has been running for weeks. A 2-point drop in reply rate across 500 weekly enrollments means 10 fewer conversations per week. Over a month, that's 40 missed opportunities.

The typical check involves logging into HubSpot, clicking into each sequence, and mentally comparing numbers. With 5-10 active sequences, that's 15-20 minutes of clicking and no easy way to compare week-over-week. A weekly Slack report surfaces underperforming sequences before they waste another week of outbound effort.

How it works

Every approach in this guide follows the same pattern:

1. Trigger on a weekly schedule (usually Monday morning)
2. Fetch all sequences from HubSpot via the CRM v3 objects API
3. Pull enrollment data per sequence, filtered to the last 7 days by hs_enrollment_start_date
4. Calculate metrics — open rate, reply rate, and meeting booked rate per sequence
5. Post a formatted report to Slack with per-sequence breakdown and aggregate totals

What you'll need

Which approach should I use?

• Code + Cron if you want zero ongoing cost and full control over the API calls. Best for teams with a developer who can maintain the script. The Sequences API requires Sales Hub Professional+.
• n8n if you want a visual workflow with loop-based enrollment fetching. Free self-hosted or $24/mo cloud. The Split In Batches node handles per-sequence iteration cleanly.
• Make if your team already uses Make. Requires Core plan ($29/mo) for the Code module. Credit cost scales with the number of active sequences (~15 credits/run for 10 sequences).
• Claude Code if you want conversational flexibility — compare specific sequences, adjust the lookback window, or ask which sequence has the best reply rate. Best for on-demand analysis during sales standups.

Select an approach below to see the full step-by-step guide.