Weekly Forecast Run
Run this every Monday morning (or at the cadence the team sets) to pull the current pipeline, build the forecast buckets, and write the dated output tab to Google Sheets.
- Confirm the run parameters: the forecast period (usually the current quarter), the minimum stage for inclusion, the stage-to-bucket mapping (commit / best case / pipeline), and the probability weights per stage.
- Query the CRM for all open opportunities meeting the minimum stage threshold.
- Assign each deal to a forecast bucket based on stage and any rep-set forecast category override.