AI Pipeline Review Report — Automated Weekly with Make + Claude

What this automation does: Every Friday afternoon, automatically exports your pipeline data from Salesforce or HubSpot, sends it to Claude for at-risk deal analysis and forecast assessment, and delivers a structured pipeline review report to your Slack or email before your weekend.

Why it matters: Most pipeline reviews happen once a week in a meeting. By the time that meeting occurs, the data is already a week old and the at-risk deals have been stalling longer than they should. This automation makes pipeline intelligence continuous — you see risk as it develops, not after the fact.

How to set it up:

1. In Salesforce/HubSpot, create a report that exports open opportunities with: deal name, stage, amount, days in stage, last activity date, and close date
2. In Make, create a scheduled trigger every Friday at 4pm
3. Add a Salesforce/HubSpot module to pull the report as CSV data
4. Pass the CSV data to Claude API with the Pipeline Audit prompt from Promptifi
5. Parse Claude's response into a formatted Slack message or email
6. Send to your personal Slack channel or email

Claude's output includes: High/medium/low risk deal classification, reasons for each rating, a weighted forecast estimate, and the top 3 actions to take before end of week.

Estimated time saved: 45-60 minutes of manual pipeline analysis per week. More importantly: deals get attention before they stall rather than after.