Every Monday morning looks the same. The sales manager opens Salesforce, exports the pipeline. Opens Gmail, searches for deal updates from the past week. Checks the shared doc where reps log meeting notes. Copies numbers into a spreadsheet. Formats it for the VP. Two and a half hours later, the report is done — and the morning is gone.
This happens at every company with a sales team larger than three people. The data exists in three or four systems. Pulling it together is manual. The format changes slightly every week depending on who asks for what. And the manager doing this work is the same person who should be coaching reps, reviewing pipeline, and closing deals.
The fix isn’t a better spreadsheet template. It’s a workflow that does the pulling, summarizing, and formatting automatically.
What the workflow does
The Weekly Sales Summary workflow runs three steps:
-
Pull CRM pipeline data — The workflow connects to your Salesforce or HubSpot instance and extracts the current pipeline: deals by stage, amounts, close dates, owner assignments, and activity timestamps. It pulls the delta from the last 7 days so you see what moved, not just what exists.
-
AI summarizes deals by stage — The raw pipeline data feeds into an AI recipe that produces a structured analysis. Deals are grouped by stage with win/loss commentary. New deals entering the pipeline are highlighted. Stalled deals — anything without activity in 5+ days — get flagged. The summary includes a narrative paragraph you can paste directly into an email to leadership.
-
Format as executive report — The final step produces a formatted output with key metrics at the top: total pipeline value, deals closed this week, weighted forecast, conversion rate by stage. Below that, a deal-by-deal breakdown with action items. The output is structured so you can paste it into Slack, email, or a Google Doc.
The entire workflow runs in under 60 seconds.
Setting it up
Setup takes about 5 minutes:
- Open the Sales department pack in JieGou
- Select the Weekly Sales Summary recipe
- Connect your CRM — Salesforce or HubSpot via the built-in MCP integration
- Set the schedule: Monday at 8:00 AM (or whenever you want it)
- Choose the output destination: Slack channel, email, or just the JieGou dashboard
The recipe comes pre-configured with sensible defaults for deal stages, stall thresholds, and report format. You can customize all of these — change the stall threshold from 5 days to 3, add a section for competitive deals, or adjust the executive summary tone.
The math on time saved
A sales manager spending 2.5 hours every Monday on this report is spending 130 hours per year — more than three full work weeks. At a blended cost of $50/hour, that’s $6,500 per year per manager. If you have regional sales managers doing the same thing, multiply accordingly.
But the time cost isn’t the real problem. The real problem is that the report is already stale by the time it’s finished. A deal might close or go dark between when the manager pulls data and when the report reaches the VP. An automated workflow that runs at 8 AM Monday delivers a report that reflects the pipeline as of 8 AM Monday — not as of whenever the manager got around to pulling the export.
What the human still does
The workflow generates the report. It doesn’t make strategic decisions about the pipeline. The manager still reviews the output, adds context that only they have — “this deal is stalled because the champion left the company” or “this one is actually further along than the stage suggests” — and decides what to escalate.
This is the right division of labor. The AI is good at pulling data, calculating metrics, and formatting output. The human is good at knowing which numbers matter and what they mean in context.
Beyond the weekly report
The Sales department pack includes workflows for the entire sales cycle:
- Daily Pipeline Pulse — A lighter daily summary of new deals and stage changes
- Deal Risk Alerts — Real-time notifications when a deal shows risk signals
- Quarterly Business Review Prep — Aggregates a full quarter’s data into QBR slides
- Win/Loss Analysis — Post-close analysis of what worked and what didn’t
Each one follows the same pattern: automate the data gathering and formatting, keep the human on strategy and decisions.