/
/
Catch won deals that never reached billing
For project managers who want to know which recently won Pipedrive deals still have no client, estimate or project in Harvest, by asking their AI assistant.
On this page
Connector
Connect Pipedrive, pick your AI tool and paste the prompt.
The problem
Won deals that nobody set up for billing
After a deal is won in Pipedrive the hand-off to billing relies on someone remembering. Without a check, work starts with no client, estimate or project in Harvest.
Without PopdockAI
- List recently won deals in Pipedrive
- Search Harvest for each customer by name
- Open estimates and projects one at a time
- Find the gap after work has already begun
With PopdockAI
- Recent wins are read from Pipedrive for you
- Each customer is checked in Harvest automatically
- Status is labelled, with unstarted deals first
- Ambiguous names are marked and nothing is created
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find deals won in the last `{lookback-days}` days (default 30) in Pipedrive and check whether the customer is set up to be billed in Harvest.
**Step 1: Read won deals (Pipedrive)**
Call `pipedrive-get-deal` with `status` set to won and `max-records` 200. Keep deals whose `won-date` falls within the lookback window. If `{owner-name}` is given, also call `pipedrive-get-user` with `name.contains` set to it, and keep only deals owned by that user.
**Step 2: Check Harvest for each customer**
For each deal, take `organization-name` and call `harvest-get-clients` with `name` set to it (retry once with `name.contains`). If a client is found, call `harvest-get-estimates` with that `client-id`, and `harvest-get-project-budget-report` with that `client-id`.
**Step 3: Report**
A table with one row per deal: deal title, customer, value and currency, won date, owner, then the Harvest status: "no client", "client only", "client with estimate" or "client with active project". Sort the "no client" and "client only" rows first. These are the won deals nobody has started billing.
**Rules & Guidelines:**
* Pipedrive tools: `pipedrive-get-deal`, `pipedrive-get-user`. Harvest tools: `harvest-get-clients`, `harvest-get-estimates`, `harvest-get-project-budget-report`.
* Read-only. Do not call `harvest-clients-create`, `harvest-estimates-create`, `harvest-projects-create` or any other write tool on either server.
* A deal with no organization name cannot be matched; list it as "no organization on the deal".
**Validation:**
* If no deals were won in the window, say so and stop.
* If a customer name matches several Harvest clients, list them and mark the row "ambiguous" rather than choosing.Who it's for
One answer, three teams that use it
Project managers
Know which wins still need a project
See which won deals have no active Harvest project, so delivery is not waiting on a handover nobody sent.
Which Pipedrive deals won this month have no active project in Harvest?
Billing administrators
Set up clients before the first invoice
Find won customers that are not yet clients in Harvest, so the account exists before work needs billing.
List won deals from the last 14 days where the customer is not a Harvest client yet.
Sales managers
Confirm your wins reached delivery
Check that deals owned by your team have moved into billing and are not stuck after the close.
Show deals owned by Dana Whitfield won in the last 30 days and whether Harvest has an estimate for each.
How it works
What PopdockAI does when you ask
You choose the window and your AI assistant compares Pipedrive wins with what exists in Harvest. It reports only, so setting up the client or project stays your call.
Ask
You choose the lookback window and, if you want, a deal owner.
Read
It lists the Pipedrive deals won in that window.
Check
It looks for each customer's Harvest client, estimates and project budgets.
Report
You get one row per deal with its billing status, gaps first.
What PopdockAI provides
The tools behind the answer
Ready made tools for Pipedrive and one secure connection to your AI tool. No code, no exports.
pipedrive-get-deal
pipedrive-get-user
harvest-get-clients
harvest-get-estimates
harvest-get-project-budget-report
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
No won deal goes unbilled by accident
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)
