intermediate1 hour2 min read

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.

How to automate a weekly pipeline report with HubSpot and Slack

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

Prerequisites
  • HubSpot account with API access (private app token with crm.objects.deals.read scope)
  • Slack workspace with permission to add integrations or webhooks
  • ~1 hour for initial setup

Key metrics to track

$2.4MTotal pipeline value
34%Stage conversion rate
28 daysAverage deal velocity
MetricFormula
Pipeline valueSum of all open deal amounts
Stage conversionDeals advanced / Total deals in stage
Deal velocityAverage days from creation to close
Coverage ratioPipeline value / Quota remaining

Choose your approach

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

n8n

medium

HTTP node to CRM API, Function node for calculations, Gmail/Slack node for delivery

Cost: $0-24/moView guide

Zapier

low

CRM trigger + Formatter + Email/Slack action

Cost: $20-50/moView guide

Make

medium

CRM module, Router for branching, Iterator for deal processing

Cost: $9-29/moView guide

Code + Cron

high

Python/Node script with CRM SDK, scheduled via cron or GitHub Actions

Cost: $0 (hosting varies)View guide

Agent Skill

low

Reusable AI agent skill — run on demand or schedule with Cowork

Cost: Usage-basedView guide

Related Recipes

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.