To automate a quarterly forecast report, record the forecast build once: pulling open pipeline, applying historical win rates, and laying out best/likely/worst scenarios. Export the workflow to Make, n8n or Claude and schedule it, so the forecast refreshes against live pipeline and actuals instead of going stale.
A forecast report is different from a backward-looking report: it's a projection. It takes current pipeline, applies historical conversion rates, and produces a number — usually with scenarios. The math is consistent, which is exactly why it's automatable; what changes is the live data underneath it.
What goes into a forecast report
| Input | Source | What it drives |
|---|---|---|
| Open pipeline by stage | CRM | Weighted projection |
| Historical win rates | CRM history | Stage probabilities |
| Bookings to date | CRM / finance | Quota attainment |
| Prior forecast vs actuals | Last quarter | Forecast accuracy |
The steps
1. Build this quarter's forecast — recorded
Pull open deals by stage, apply your win-rate assumptions, total the weighted pipeline, and lay out best / likely / worst — once, with a recorder running.
2. Capture the calculation logic
The recording becomes a workflow: the pipeline pull, the probability weighting, the scenario math, the variance-vs-actuals comparison. Confirm your assumptions are captured correctly.
3. Export and schedule
Send it to Make or n8n so it re-pulls live pipeline, or to Claude for the commentary on why the forecast moved. Schedule weekly or monthly to turn a quarterly chore into a rolling forecast.
A forecast rebuilt by hand is a snapshot. A forecast that refreshes itself is a system — and that's the difference between guessing and steering.
Worked example: the revenue forecast
Take open pipeline weighted by stage probability, add committed bookings, and you have a "likely" number; flex the win rates up and down for best/worst. Recorded once, that's a repeatable workflow that re-runs against today's pipeline. Pair it with the pipeline report for the underlying detail, and see sales use cases for more.
How Spion does it
Record the forecast build once; Spion reconstructs the steps and exports a ready-to-run automation to Claude, Make, Zapier or n8n. Method: how to automate a workflow fast.