Renewal-risk brief: CRM and support signals in one red, amber or green call

HubSpot + Intercom

IntermediateCustomer success

Who it's for

CSMs and account managers who want a quick, evidence-backed read on an upcoming renewal before the prep call, without changing anything in the CRM or the support inbox. HubSpot can be swapped for Salesforce, Attio or Pipedrive. EU-hosted Intercom workspaces use Intercom EU. Zendesk isn't listed here yet (no official server available).

What you get

A renewal-risk brief for one account. Sample output: every company and person in it is fictional.

Account: Larkspur Freightworks (fictional)
Renewal: Nov 30 (45 days out), $36K ARR
Owner: Priya Raman (CSM). Champion: Dana Okafor, Ops Director

Call: AMBER

Why:
- Support load is up: 9 Intercom conversations in the last 60 days, against 3 in the 60 days before.
- Main theme is the CSV export (5 of 9 conversations). Two are still open, the oldest from Sep 22.
- On Oct 3 Dana wrote: "If exports keep failing we'll need to look at other options before renewal." (Intercom, conversation with Dana Okafor)
- HubSpot shows no logged call or meeting with Dana since Aug 14.

What's going well:
- The renewal deal is open, with a close date of Nov 30 and a note from Sep 10: "Budget confirmed for next year."
- A new contact, Sam Whitlock (Finance), was added to the deal on Oct 1.

Suggested next steps (nothing has been changed):
1. Get the two open export conversations to a fix or a date this week.
2. Book a check-in with Dana before Oct 31.

Not found: no Intercom company record matched on the first try. Matched on the domain larkspur.example instead.

Time and cost

Estimate About 5–10 minutes per account, most of it checking the evidence.

Assumptions: One account with one renewal deal, a few contacts and about 10 recent support conversations.

Exact credit costs depend on your plan with each vendor. Check the tool pages before a large run.

MCP servers

Every server is confirmed in: Claude

Set up in a chat app

Every server in this recipe is confirmed for Claude. Connect each one, then paste the prompts below into one conversation.

Developer setup

Auth setup and mcp.json for Claude Code and Cursor
  • HubSpot: Sign in with OAuth in your client (run /mcp in Claude Code). Do it once interactively, and the client stores and refreshes the token.
  • Intercom: Sign in with OAuth, or pass an API key as a Bearer token for headless use.

Put this in .mcp.json (Claude Code, project root) or ~/.cursor/mcp.json (Cursor). Swap the example keys for your own, and don't commit real ones. Remove the // comment lines if your client requires strict JSON.

{
  "mcpServers": {
    "hubspot": {
      "url": "https://mcp.hubspot.com"
    },
    "intercom": {
      "url": "https://mcp.intercom.com/mcp"
      // headless alternative: "headers": { "Authorization": "Bearer YOUR_INTERCOM_API_KEY" }
    }
  }
}

Step-by-step prompts

  1. Find {company} in HubSpot. Show me the renewal date (use {renewal field}), the owner, the open renewal deal and its stage, the contacts on the deal, and the notes and activities from the last 90 days. Don't change anything.
  2. Find {company} in Intercom by name or by the domain {domain}, and tell me how you matched it. List its conversations from the last 90 days with the date, contact, status and a one-line topic.
  3. Group those conversations into themes. For each theme give a count, how many are still open, and one short quote with its date.
  4. Write a renewal-risk brief: a red, amber or green call, the reasons for it with the evidence behind each one, what's going well, and two or three next steps. List anything you couldn't find. Don't write anything back to HubSpot or Intercom.

Run it on a schedule (optional)

Where this goes wrong

Gotchas

Download

Get the prompts, guardrails and expected output as one Markdown file. Paste it into a Claude Project or ChatGPT project's instructions, or save it as CLAUDE.md for Claude Code.

Download renewal-risk-brief.md

Vendor sites: HubSpot. If we join an affiliate program, these links will be labeled as affiliate links.