Rank open opportunities by urgency and fit for Sales teams | Copy-Paste AI Recipe

Name: Rank open opportunities by urgency and fit for Sales teams
Prep time: 15 min
Ingredients: Postgres AI system; HubSpot AI system

NextFlows Contributors

doi:nextflows.ai/recipes/rank-open-opportunities-by-urgency-and-fit-sales-29

⚡ TL;DR

✓ Save reps 30 minutes before every call with concise account context, risks, talking points, and next steps
✓ 15 minutes to first success
✓ Read-only
✓ Uses Postgres MCP, HubSpot MCP

Before you start

0/4

Claude Desktop installedPostgres MCP access configuredHubSpot MCP access configuredPermission for Postgres read access, HubSpot read access

Setup (15 min)

0/5

1Connect Postgres MCP in your MCP client and confirm the server shows as available.

2Connect HubSpot MCP so the assistant can combine context.

3Grant the minimum read scopes needed for this forecast workflow.

4Open the workspace, channel, repository, database, or account you want the assistant to use.

5Paste the prompt from this recipe into your AI client.

The prompt

You are helping a Sales teammate with this workflow: Rank open opportunities by urgency and fit.
Use the connected Postgres MCP, HubSpot MCP tools to gather only the information needed for forecast.
Create a concise result with: summary, important details, recommended next actions, owners, and links to sources.
Flag anything uncertain, stale, sensitive, or missing instead of guessing.
Do not make changes without asking me to confirm the final draft.

Paste into Claude Desktop. It will use your connected AI servers: Postgres MCP, HubSpot MCP.

Expected outcome

Save reps 30 minutes before every call with concise account context, risks, talking points, and next steps

Success checklist

0/4

The output explains the forecast context in plain English.Every recommendation includes a source, owner, or next action.Sensitive data is summarized only at the level needed for the task.Sales teammates can use the result without asking for extra background.

Troubleshooting

MCP server is not available in the client

Cause

The server config was not saved, the client was not restarted, or Node.js cannot run npx.

Solution

Run Postgres MCP manually with its install command, then restart your MCP client.

The assistant cannot find the expected records

Cause

The connected account lacks access to the workspace, channel, repo, database, or page.

Solution

Grant the missing read scope and test with one known record before running the full recipe.

The result is too broad or includes stale context

Cause

The prompt did not limit the date range, source, account, or project clearly enough.

Solution

Add the relevant team, date range, channel, repo, account, or page name to the prompt.