How to automate a weekly pipeline report with Salesforce and Slack
Automatically pull opportunity data from Salesforce each week, calculate pipeline metrics, and deliver a formatted report to Slack. No manual exports or spreadsheets.
Workflow
Why automate your pipeline report?
Sales leaders waste hours every week exporting opportunities from Salesforce, building spreadsheets, and copy-pasting summaries into Slack. That time should go toward coaching reps and moving deals forward.
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
What you'll need
- Salesforce org with API access (a Connected App configured with OAuth 2.0)
- Slack workspace with permission to add integrations or incoming webhooks
- ~1 hour for initial setup
Key metrics to track
| Metric | Formula |
|---|---|
| Pipeline value | Sum of Amount for all open Opportunities |
| Stage breakdown | Count of Opportunities grouped by StageName |
| Closed this week | Opportunities where CloseDate = THIS_WEEK and IsWon = true |
| Average deal size | Total pipeline value / Number of open Opportunities |
Choose your approach
Select an approach below to see a full step-by-step guide for building this report.
Salesforce Flow
mediumScheduled Flow → SOQL query for open Opportunities → aggregate metrics → Slack notification
n8n
mediumWeekly Schedule trigger → Salesforce SOQL query → Code node for metrics → Slack report
Agent Skill
lowAgent skill to pull pipeline data from Salesforce and compose a weekly summary
Claude Cowork
lowScheduled weekly Cowork task that generates and posts the pipeline report
Related Recipes
How to automate a weekly pipeline report with HubSpot and Slack
HubSpot + Slack
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
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.