/
/
Spot expansion deals before the budget runs out
For account managers who want to know which Harvest projects are nearly spent and whether a Pipedrive deal already exists, by asking their AI assistant.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Budgets run dry before anyone opens a deal
A Harvest project can be almost out of budget while Pipedrive shows no sign of a renewal. Account managers only notice when the team complains, which is too late to plan an expansion.
Without PopdockAI
- Review each active project budget in Harvest
- Work out the remaining share by hand
- Search Pipedrive for each customer deal
- Learn about the gap from a complaint
With PopdockAI
- Nearly spent projects are picked out for you
- Open deals are checked in Pipedrive automatically
- Customers with no deal are listed first
- Hours and money budgets stay separate
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find active Harvest projects that have used most of their budget, and check whether the customer already has an open deal in Pipedrive to follow it up. Treat a project as nearly spent when the budget remaining is under `{remaining-percent}` percent of its budget (default 20).
**Step 1: Read project budgets (Harvest)**
Call `harvest-get-project-budget-report` with `active` true. Compute remaining divided by budget for each project, skipping projects with no budget. Keep those under the threshold, including any already over budget.
**Step 2: Check Pipedrive for each customer**
For each distinct `client-name`, call `pipedrive-get-organization` with `name` set to it (retry once with `name.contains`). If found, call `pipedrive-get-deal` with `organization-id` and `status` open.
**Step 3: Report**
A table: customer, project, budget, spent, remaining, then the Pipedrive status: "open deal" (with title, stage, value), "no open deal" or "not in Pipedrive". Put "no open deal" first: these are the customers worth a renewal or expansion conversation. Name the owner from `pipedrive-get-organization` when there is one.
**Rules & Guidelines:**
* Harvest tools: `harvest-get-project-budget-report`. Pipedrive tools: `pipedrive-get-organization`, `pipedrive-get-deal`.
* Read-only. Do not call `pipedrive-add-deal`, `pipedrive-add-lead`, `pipedrive-add-activity` or any other write tool.
* Budgets are in hours or money depending on the budget basis; show the unit and never compare across units.
**Validation:**
* If no project is under the threshold, say so and stop.
* If a customer has several matching organizations, list them and mark the row "ambiguous".Who it's for
One answer, three teams that use it
Account managers
Know which customers need a renewal call
See projects close to their budget limit and whether a deal already exists, so you reach out before the team runs short.
Which of my customers have Harvest projects nearly out of budget and no open deal in Pipedrive?
Delivery leads
Flag budget pressure early
Share a list of projects under their remaining threshold with sales, so scope conversations begin before work stalls.
List active Harvest projects with less than 25 percent budget remaining, including any already over budget.
Sales leaders
Find expansion revenue in existing work
See where delivered work points to a follow up deal that nobody has opened yet.
Show Harvest projects under 15 percent budget and tell me which customers have no open Pipedrive deal.
How it works
What PopdockAI does when you ask
You choose how close to the limit a budget must be and your AI assistant reads Harvest and Pipedrive. It makes no changes, so no deal or lead is created without you.
Ask
You set how little budget counts as nearly spent, or use the default.
Read
It reads active Harvest project budgets and keeps those under the threshold.
Check
It looks up each customer in Pipedrive and finds open deals.
Report
You get a table with customers without an open deal first.
What PopdockAI provides
The tools behind the answer
Ready made tools for Harvest and one secure connection to your AI tool. No code, no exports.
harvest-get-project-budget-report
pipedrive-get-organization
pipedrive-get-deal
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Renewal conversations start before budgets end
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
