How to automate a weekly pipeline report with HubSpot and Slack
Automatically pull deal data from HubSpot each week, calculate pipeline metrics, and deliver a formatted report to Slack. Compare approaches across n8n, Zapier, Make, and custom code.

Why automate your pipeline report?
Sales leaders spend hours every week manually exporting deals from HubSpot, formatting spreadsheets, and pasting updates into Slack. This is time that should be spent coaching reps and closing deals.
An automated weekly pipeline report connects HubSpot to Slack and handles the whole cycle:
- Pulls live deal data from HubSpot on a weekly schedule
- Calculates key metrics (pipeline value, stage conversion, velocity)
- Formats a clean summary with the numbers your leadership team cares about
- Delivers it to a Slack channel so the whole team sees it without asking
What you'll need
- HubSpot account with API access (private app token with
crm.objects.deals.readscope) - Slack workspace with permission to add integrations or webhooks
- ~1 hour for initial setup
Key metrics to track
| Metric | Formula |
|---|---|
| Pipeline value | Sum of all open deal amounts |
| Stage conversion | Deals advanced / Total deals in stage |
| Deal velocity | Average days from creation to close |
| Coverage ratio | Pipeline value / Quota remaining |
Choose your approach
Select an approach below to see a full step-by-step guide for building this report.
n8n
mediumHTTP node to CRM API, Function node for calculations, Gmail/Slack node for delivery
Code + Cron
highPython/Node script with CRM SDK, scheduled via cron or GitHub Actions
Agent Skill
lowReusable AI agent skill — run on demand or schedule with Cowork
Related Recipes
How to post a daily Slack leaderboard of rep activity from HubSpot
HubSpot + Slack
How to track lead-to-MQL conversion rate by source and report weekly to Slack
HubSpot + Slack
How to send a weekly Slack report on HubSpot sequence performance
HubSpot + Slack
How to send a Slack alert when a HubSpot deal changes stage
HubSpot + Slack
Frequently Asked Questions
Need help implementing this?
We build and optimize automation systems for mid-market businesses. Let's discuss the right approach for your team.