How to automate a weekly pipeline report with HubSpot and Slack

Why automate your pipeline report?

Sales leaders spend 30-60 minutes every Monday morning exporting deals from HubSpot, formatting spreadsheets, and pasting updates into Slack. That's 2-4 hours per month of a senior leader's time spent on data formatting instead of coaching reps. Worse, by the time the report is ready, the numbers are already stale.

Manual reporting also means inconsistent formatting, missed weeks during busy periods, and no historical comparison. An automated pipeline report eliminates all of this — it runs on schedule, uses the same format every time, and frees leadership to focus on the numbers instead of compiling them.

How it works

Every approach in this guide follows the same pattern:

1. Trigger on a weekly schedule (usually Monday morning before standup)
2. Fetch pipeline stages from HubSpot to map stage IDs to human-readable names
3. Search all active deals with their amounts, stages, close dates, and last modified dates
4. Calculate metrics — total pipeline value, deals by stage, stale deals (14+ days without activity)
5. Post a formatted report to Slack with key metrics and at-risk deal alerts

What you'll need

Key metrics to track

Which approach should I use?

• n8n (recommended) if you want a visual workflow you can modify without code. The visual editor makes it easy to add stages, change metrics, or split reports by pipeline. Free self-hosted or $24/mo cloud.
• Code + Cron if you want zero ongoing cost and full control. Best for teams with a developer who can maintain the script. Runs on GitHub Actions for free.
• Zapier if your team already pays for Zapier Professional and wants a managed solution. Requires Webhooks by Zapier to call the HubSpot Search API directly. ~140 tasks/month.
• Make if your team already uses Make. The visual builder handles deal aggregation natively. Any plan works for weekly schedules.
• Claude Code if you want conversational flexibility — ask for pipeline snapshots by stage, time period, or specific reps. Best for on-demand reports during leadership meetings.

Select an approach below to see a full step-by-step guide for building this report.