/
/
Make sure every won deal has a Harvest client
For finance teams who ask their AI assistant which recently won OnePageCRM deals still need a client in Harvest.
On this page
Connector
Connect OnePageCRM, pick your AI tool and paste the prompt.
The problem
A won deal does not always reach billing
When a OnePageCRM deal closes, billing finds out by email or by chance. Without a Harvest client the first invoice is late or never sent.
Without PopdockAI
- List won deals in OnePageCRM
- Search Harvest for each company
- Note the ones with no client
- Email billing and hope they act
With PopdockAI
- Won deals are read for the date range
- Each company is checked against Harvest clients
- Missing clients are listed with amount and owner
- Loose and ambiguous matches are shown, 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 OnePageCRM between `{won-from}` and `{won-to}` (default: the last 30 days) whose company has no client in Harvest, so that billing can be set up.
**Step 1: Read won deals (OnePageCRM server)**
Call `onepagecrm-get-deal` with `status` set to the won status (use the value the account uses for won deals; if unsure, call it once without `status` and look at the distinct `status` values), `close-date.from` set to `{won-from}` and `close-date.to` set to `{won-to}`. Keep `name`, `amount`, `close-date`, `owner`, `contact-name` and `company-name`.
**Step 2: Check Harvest (Harvest server)**
For each distinct `company-name`, call `harvest-get-clients` with `name.contains` set to it. A deal whose company has an exact or loose match is "has client". If a deal has no company name, list it separately as "no company on deal".
**Step 3: Report**
Give a table of deals with no Harvest client: deal name, company, amount, close date, owner. Then list the deals that already have a client, with the matched client name. End with the counts.
**Rules & Guidelines:**
* Harvest tools (names starting harvest-) come from the harvest server and OnePageCRM tools (names starting onepagecrm-) come from the onepagecrm server. Both servers must be connected.
* OnePageCRM calls customers companies (and the people at them contacts) and Harvest calls them clients. There is no shared id, so match on name: exact (ignoring case, punctuation and suffixes such as Inc, LLC, Ltd) first, then one name containing the other, and always show which kind of match was used.
* This is read-only. Do NOT call any Harvest create, update, delete, stop or restart tool (for example `harvest-clients-create`, `harvest-contacts-create`, `harvest-invoices-create`, `harvest-estimates-create`, `harvest-time-entries-update`) and do NOT call `onepagecrm-add-contact`, `onepagecrm-add-deal`, `onepagecrm-add-note`, `onepagecrm-add-call`, `onepagecrm-add-meeting`, `onepagecrm-add-action`, `onepagecrm-update-contact`, `onepagecrm-update-deal`, `onepagecrm-update-action`, `onepagecrm-delete-contact` or `onepagecrm-delete-deal`.
* Hourly rates, cost rates and invoice amounts are sensitive: show them only because the user asked for billing context.
**Validation:**
* If no deals were won in the window, say so and stop.
* If a company name matches more than one client, list the candidates rather than choosing.
* State the exact dates used.Who it's for
One answer, three teams that use it
Billing staff
See which new customers need a client
A short list of won deals with no Harvest client tells you exactly what to set up before invoicing.
Which won OnePageCRM deals in the last two weeks have no matching Harvest client?
Sales reps
Check your closed deals reached billing
You can confirm that a deal you closed has a client in Harvest, so the customer is not invoiced late.
Did the deals I won in October all get a client in Harvest?
Operations managers
Audit the sale to billing handoff
A period review shows how many wins had no client, which helps you fix the process behind the gaps.
Count won OnePageCRM deals this quarter with and without a Harvest client.
How it works
What PopdockAI does when you ask
You set the won period and your AI assistant reads OnePageCRM and Harvest. It reports the gaps and leaves creating clients to you.
Ask
You give the won dates, or leave it at the last 30 days.
Read
It reads the deals won in OnePageCRM in that period.
Check
It looks for each company among the Harvest clients by name.
Report
You get deals that need a client, deals that already have one and deals with no company, with counts.
What PopdockAI provides
The tools behind the answer
Ready made tools for OnePageCRM and one secure connection to your AI tool. No code, no exports.
onepagecrm-get-deal
harvest-get-clients
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
New customers billed from day one
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)
