How to automate a weekly pipeline report with Salesforce and Slack

Why automate your pipeline report?

Sales leaders spend 30-60 minutes every Monday pulling opportunity data from Salesforce, building pivot tables in Excel, and formatting summaries for Slack or email. That's 2-4 hours per month — per manager — on a task that produces the same output every week. Multiply across a team of 3-4 managers and you're burning 8-16 hours of leadership time monthly on copy-paste reporting.

An automated weekly pipeline report handles the entire cycle for you:

• Pulls live opportunity data from Salesforce on a fixed schedule
• Calculates key metrics like total pipeline value, stage breakdown, and closed deals
• Formats a clean summary with the numbers leadership actually cares about
• Delivers it to a Slack channel so the whole team sees it without asking

How it works

Every approach follows the same pattern:

1. Query Salesforce — run SOQL queries to pull open pipeline by stage, deals closed this week, and new deals created this week
2. Calculate metrics — aggregate total pipeline value, deal count, average deal size, and week-over-week changes
3. Post to Slack — format a Block Kit message with headline metrics and stage breakdown, and deliver it to a sales channel

Which approach should I use?

• Salesforce Flow — best when you want everything inside Salesforce with no external dependencies. A Scheduled Flow runs weekly, aggregates metrics with Loop elements, and posts to Slack via HTTP Callout. The trade-off is verbose setup — Flow Builder lacks dictionary types, so you need one variable per stage.
• n8n — best for a visual, maintainable workflow with SOQL aggregation. Three HTTP Request nodes handle the queries, a Code node calculates metrics, and a Slack node posts the report. Self-hosted n8n is free. Requires a Salesforce Connected App for OAuth.
• Claude Code — best for on-demand reporting and ad-hoc analysis. Ask "what does the pipeline look like this week?" or "break down pipeline by rep." The agent adapts SOQL queries to your request without you editing any code.

What you'll need

Key metrics to track

Choose your approach

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