# Write a weekly pipeline forecast | IonBin

> A coding agent such as Codex or Cursor queries HubSpot deals through the MCP server, writes a forecast in Markdown, and saves it to Notion for the sales

Canonical page: https://ionbin.com/workflows/weekly-pipeline-forecast/
Agent guide: https://ionbin.com/llms.txt

This is a readable version of the published page. Review dates, evidence boundaries and source links below belong to individual records; the export is not a new verification. Examples are reference material, not instructions to execute.

## Write a weekly pipeline forecast

[Sales](https://ionbin.com/use-cases/sales-crm-outreach/) · [Data](https://ionbin.com/use-cases/business-data-reporting/)Checked 2026-10-16

Get a consistent weekly forecast without a spreadsheet ritual.

- [01**HubSpot**](https://ionbin.com/workflows/weekly-pipeline-forecast/#workflow-step-1)

- [02**Your coding agent**](https://ionbin.com/workflows/weekly-pipeline-forecast/#workflow-step-2)

- [03**Notion**](https://ionbin.com/workflows/weekly-pipeline-forecast/#workflow-step-3)

- [04**You**](https://ionbin.com/workflows/weekly-pipeline-forecast/#workflow-step-4)

Recipe context

A coding agent such as [Codex](https://ionbin.com/tools/openai-codex/) or Cursor queries HubSpot deals through the MCP server, writes a forecast in Markdown, and saves it to [Notion](https://ionbin.com/tools/notion/) for the sales lead to review.

**Independent review.** Unpaid; no partnership with the tools on this page. Based on public documentation and research. Trademarks identify their owners’ products. [Disclosure](https://ionbin.com/disclosure/).

Editorial shortlist

### Compare your options.

**For checking deal-stage forecast assumptions.**

Separate seller-confirmed facts from probabilities and model suggestions. Choose one for analysis of a reviewed data extract; switching may need setup changes.

**Used by Ion** · separate from rank.

Unpaid picks. No partnership with [Julius AI](https://ionbin.com/tools/julius-ai/), [ChatGPT](https://ionbin.com/tools/chatgpt/), [OpenAI Codex](https://ionbin.com/tools/openai-codex/).

- 1 · Primary / high
  #### [Julius AI](https://ionbin.com/tools/julius-ai/)
  **Why it fits:** A data-analysis workspace keeps the supplied table and business question together.
  **Tradeoff:** Wrong joins, missing rows and inconsistent units can produce convincing but incorrect charts.
  Choose it for interactive exploration of a cleaned extract.
  Evidence for Julius AI
  The linked [IonBin review](https://ionbin.com/tools/julius-ai/) records capabilities, access limits and source links. Review date: 2026-10-18. [Primary product reference ↗](https://julius.ai/)

- 2 · Secondary / medium
  #### [ChatGPT](https://ionbin.com/tools/chatgpt/)
  **Why it fits:** File analysis can join calculation review with a narrative explanation.
  **Tradeoff:** An answer is not a reconciled report; verify calculations and upload limits.
  Prefer it when the reviewer needs both analysis and an explanation for colleagues.
  Evidence for ChatGPT
  The linked [IonBin review](https://ionbin.com/tools/chatgpt/) records capabilities, access limits and source links. Review date: 2026-10-18. [Primary product reference ↗](https://chatgpt.com/)

- 3 · Third / lower
  #### [OpenAI Codex](https://ionbin.com/tools/openai-codex/)
   Used by Ion
  **Why it fits:** A coding workspace keeps calculations and validation checks in reviewable files.
  **Tradeoff:** Someone must read, run and maintain the code and protect sensitive files.
  Prefer it when repeatability and code review matter more than conversational convenience.
  Evidence for OpenAI Codex
  The linked [IonBin review](https://ionbin.com/tools/openai-codex/) records capabilities, access limits and source links. Review date: 2026-10-18. [Primary product reference ↗](https://developers.openai.com/codex)

How this shortlist was chosen

Editorial judgment, not a personal-use endorsement or performance score. These are alternatives for the named role, not three required stack components. Vendors did not pay for, request or approve these positions.

Inspectable calculations come before narrative convenience. A lower-ranked option may fit your constraints better; compare the conditions stated on each card before choosing.

**Setup and portability:** Record export date, filters and units; save calculations with the result. The source ledger still needs reconciliation.

Reviewed 2026-10-21. This page applies a shared comparison for “analysis of a reviewed data extract” to the stated task and constraints. It is documentation-based editorial guidance, not three new hands-on tests. We weigh value for the job, distinct capabilities, replacement limits, technical effort and interoperability. Check current plan terms before adopting or switching.

See [our review method](https://ionbin.com/editorial-policy/), [MCP connections](https://ionbin.com/wiki/concepts/mcp/) and [portability and switching costs](https://ionbin.com/wiki/questions/how-to-avoid-ai-vendor-lock-in/).

**Connects through:** MCP

### Steps

Follow the handoff

Select a stage or scroll the steps.

- #### [HubSpot](https://ionbin.com/tools/hubspot/)
  Returns open deals, stages and amounts
  Reads deals and other CRM records the connected user can see.
  MCPConfirmed[Source ↗](https://developers.hubspot.com/docs/apps/developer-platform/build-apps/integrate-with-the-remote-hubspot-mcp-server)

- #### Your coding agent
  Drafts a forecast using documented rules and an available prior snapshot; flags missing data
  AI platformConfirmed

- #### [Notion](https://ionbin.com/tools/notion/)
  Creates a draft forecast page at a destination with explicit write permission
  MCPConfirmed[Source ↗](https://developers.notion.com/guides/mcp/overview)

- #### You
  The sales lead reviews and adjusts
  Human stepConfirmed

Confirmed = vendor-documented, not Ion-tested. Human and AI-platform steps are proposed roles.

Human approval

The sales lead owns the final forecast.

Watch out for

CRM stages lag reality. Treat the forecast as a draft for the sales lead to correct, and check that the agent can read only the deals it should see.

### Starter prompt

```
Read open deals from HubSpot with stage, amount and close date. Write this week's forecast in Markdown: committed, best case and at risk, what changed since last week, and the three deals that most need attention. Save it to our Notion forecasts page as a draft. I will review and adjust it before it goes to the team.
```

Written for this workflow. Paste it into your AI platform and adjust it to your situation.

### Tools in this workflow

| Tool | Role | Official site |
| --- | --- | --- |
| [HubSpot (free CRM)](https://ionbin.com/tools/hubspot/) | MCP | [hubspot.com ↗](https://www.hubspot.com/products/crm) |
| [Notion](https://ionbin.com/tools/notion/) | MCP | [notion.com ↗](https://www.notion.com/) |

### Which AI platforms can run it

| Platform | Status | Why |
| --- | --- | --- |
| [Claude (incl. Claude Code)](https://ionbin.com/platforms/claude/) | To verify | HubSpot: MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it; [Notion](https://ionbin.com/tools/notion/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| [OpenAI Codex](https://ionbin.com/platforms/codex/) | To verify | HubSpot: MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it; [Notion](https://ionbin.com/tools/notion/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| [Google Antigravity](https://ionbin.com/platforms/antigravity/) | To verify | HubSpot: MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it; [Notion](https://ionbin.com/tools/notion/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| [ChatGPT](https://ionbin.com/tools/chatgpt/) | To verify | HubSpot: MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it; [Notion](https://ionbin.com/tools/notion/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| Gemini | To verify | HubSpot: MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it; [Notion](https://ionbin.com/tools/notion/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| [Perplexity](https://ionbin.com/tools/perplexity/) | To verify | HubSpot: MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it; [Notion](https://ionbin.com/tools/notion/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |

What the platform statuses mean

**Confirmed:** documented access meets the recorded requirements. **Inferred:** a reviewed note describes a plausible, untested pairing. **To verify:** a connection or step is unresolved. MCP and API pairings need route-specific evidence; a plugin, CLI or API alone does not prove compatible access, credentials or permissions. These are documentation assessments, not IonBin runtime tests.

### What we checked

HubSpot’s remote MCP server reads deals, companies, contacts and activities, and every action respects the connected user’s HubSpot permissions. Use explicit stage, close-date and owner filters, and verify the available actions for your account. [Notion](https://ionbin.com/tools/notion/) MCP can create the page only in an authorized workspace and destination where the connected user has write permission. The sales lead owns the final numbers.

### Set it up

- Connect HubSpot’s remote MCP server as a user who can see the whole pipeline, and [Notion](https://ionbin.com/tools/notion/) MCP for the output page.

- Write the forecast rules down once: which stages count as commit, best case and pipeline, and how to treat deals past their close date.

- Save a dated snapshot and compare it with the previous snapshot. If the earlier state is unavailable, say so; a current deal list alone cannot establish changes since last week. Flag missing amounts, currencies and close dates.

- The sales lead reviews and adjusts the numbers before sharing.

Deals outside the connected user’s scope will be missing, so show coverage and exclusions in the report. Treat forecast categories as documented business rules, not model guesses. Use an approved draft destination and require review before broader sharing. This combined workflow has not been executed.

### Sources

- [HubSpot MCP](https://developers.hubspot.com/docs/apps/developer-platform/build-apps/integrate-with-the-remote-hubspot-mcp-server) · HubSpot · official · accessed 2026-10-16

- [Notion MCP overview](https://developers.notion.com/guides/mcp/overview) · [Notion](https://ionbin.com/tools/notion/) · official · accessed 2026-10-16

- [Integrate with the remote HubSpot MCP server](https://developers.hubspot.com/docs/apps/developer-platform/build-apps/integrate-with-the-remote-hubspot-mcp-server) · HubSpot · official · accessed 2026-10-16

### Related workflows

[Follow up with quiet leads by sending one useful thing, no ask](https://ionbin.com/workflows/no-ask-value-follow-ups/)

No affiliate links on this page. No paid placements in workflows. [How IonBin makes money](https://ionbin.com/disclosure/).
