How to Build a Weekly Pipeline Email From HubSpot to the Founder

How do you get a weekly pipeline summary from HubSpot without building it by hand?

Build a small dashboard with five pipeline reports, then schedule HubSpot to email it every week. HubSpot's documentation describes a Share menu option called "Email this dashboard" with Daily, Weekly, or Monthly schedules. Set it for Monday morning, and the founder gets the same view every week without anyone exporting a spreadsheet.

This tutorial is for a specific situation: a founder at a small B2B company who wants a clear pipeline picture once a week, and a sales lead or ops person who is tired of building that picture manually. If someone on your team spends Friday afternoon copying numbers into a slide, this is for you.

The goal is not a giant dashboard. It is a short, consistent email that answers the questions a founder actually asks. Here is how I set it up.

What questions should the weekly email answer?

Five questions: how much new pipeline was created, what moved forward, what closed, what is stuck, and where the quarter stands. If the email answers those five, the founder can spot problems in two minutes. Everything else belongs in a deeper review, not in the weekly summary.

Write these questions down before you build anything. Then check them with the founder. Some founders care more about new pipeline by source. Others care most about stuck deals. Adjust the list, but keep it to five or fewer.

The discipline matters. Every report you add makes the email longer and less likely to be read. A short email read every week beats a long one opened once a month.

Which reports should you build?

Build one report per question. New pipeline created this week, grouped by source. Deals that changed stage this week. Deals closed won and closed lost this week. Open deals with no activity in the last 14 days. And open pipeline for the current quarter by stage. Five reports, one dashboard.

Use HubSpot's report builder for each one. The custom report builder lets you save a report to a dashboard once it is set up, according to HubSpot's documentation. Use deal properties like create date, deal stage, close date, amount, and original source to filter and group.

Keep each report visually simple. A bar chart by source for new pipeline. A table for stage changes and closed deals, so names are visible. A table for stuck deals, sorted by amount. A stacked bar for quarter pipeline by stage. The founder should read each in seconds.

How should you set up the stuck deals report?

Filter open deals where the last activity date is more than 14 days ago, and sort by amount, largest first. That puts the biggest risks at the top. Include the deal owner column, so the founder knows who to ask. This is often the most useful report in the whole email.

Pick a threshold that fits your sales cycle. Fourteen days works for many small B2B teams. If your deals move faster, use seven. If they move slower, use twenty-one. The point is to surface deals that have gone quiet before they quietly die.

If you want an alert as well as a weekly view, you can build a separate notification for stale deals. I covered that in how to build a stale deal alert in HubSpot. The weekly email shows the pattern. The alert prompts action in the moment.

How do you schedule the dashboard email?

Open the dashboard, click Share in the upper right, and select Email this dashboard. HubSpot's documentation says the email sends once by default, so choose "Yes, this is a recurring email," then pick Weekly from the Schedule dropdown. Choose the day and time, such as Monday at 8 a.m. in the founder's time zone.

Note the timing detail. HubSpot's documentation says report data will be captured two hours before the send time. If you send at 8 a.m., the numbers reflect roughly 6 a.m. That is fine for a weekly view, but worth knowing if someone updates deals early Monday.

Add a short subject line that tells the founder what it is, like "Weekly pipeline: week of" plus the date if your setup allows. Consistency helps. The founder learns to expect it and open it.

Who can receive the recurring email?

Only HubSpot users. HubSpot's documentation states that recurring dashboard emails can only be sent to HubSpot users. So the founder needs a HubSpot user seat, even if they rarely log in. If an investor or board member needs the same view, you will need a different approach, such as a one-time send or an export.

Permissions also matter. HubSpot says dashboard data in recurring emails is based on the permissions of the user who set up the email. If a sales rep with limited access sets it up, the founder sees only that rep's data. Have someone with full pipeline access, ideally the founder or an admin, create the schedule.

To change or cancel it later, use Share and then Manage recurring emails on the dashboard. HubSpot's documentation notes that a recurring email must be deleted at least two hours before it is due to send.

Should you add a human note to the email?

Yes, if someone can spare five minutes. Numbers show what happened. A two-line note from the sales lead explains why. "Two big deals slipped to next month because legal review is slow. New pipeline is up because of the partner webinar." That context turns a report into a conversation starter.

The simplest way is a short Slack message or email sent right after the dashboard arrives. Keep it to three sentences at most. What is going well, what is at risk, and what help is needed.

Over time, these notes become a useful record. Looking back a quarter later, you can see what the team was worried about each week and whether those worries were right. That history is valuable for planning.

How do you keep the email trustworthy?

Keep the data clean and the definitions fixed. If reps do not update deal stages or close dates, the weekly email will be wrong, and the founder will stop trusting it. Agree on what each stage means, ask reps to update deals before Friday, and keep report definitions the same week to week.

When you change a report, tell the founder. A new filter or grouping can make numbers jump, and a surprise jump creates confusion. A one-line note like "stuck deals now uses 21 days instead of 14" avoids that.

If your team prefers spreadsheets, the same five questions work there too. I walked through a sheet-based version in how to run a weekly pipeline review in Google Sheets.

What should you do next?

Write down the five questions with your founder, build one HubSpot report for each, and put them on a dashboard called something like "Founder weekly." Then schedule a recurring weekly email from an account with full pipeline access. Check the first two sends together to confirm the numbers match reality.

After a month, ask the founder which report they look at first and which they skip. Remove what they skip. If the quarter view raises questions about coverage, read what a pipeline coverage number actually means before you add more reports.

If you want help setting up HubSpot reporting that your founder and sales team trust, reach out. I build websites and the automations behind them for lead generation, and clean reporting is how you know whether all of it is working. Let's chat.