/
/
Never invoice a new customer late because no client exists
For finance teams who ask their AI assistant which recently won Nutshell leads still need a client set up in Harvest.
On this page
Connector
Connect Nutshell, pick your AI tool and paste the prompt.
The problem
Won deals reach billing by memory
When a Nutshell lead is won, billing hears about it by email or by chance. If nobody creates the Harvest client, the first invoice goes out late or not at all.
Without PopdockAI
- List recently won leads in Nutshell
- Search Harvest for each company
- Note which ones have no client
- Tell billing by email and hope
With PopdockAI
- Won leads are read for the date range
- Each company is checked against Harvest clients
- Missing clients are listed with value 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 leads won in Nutshell 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 leads (Nutshell server)**
Call `nutshell-get-lead` with `status` set to the won status (use the value the account uses for won leads; if unsure, call it once without `status` and look at the distinct `status` values), `closed-time.from` set to `{won-from}` and `closed-time.to` set to `{won-to}`. Keep `name`, `number`, `value`, `closed-time`, `owner` and `companies`.
**Step 2: Check Harvest (Harvest server)**
For each distinct company name in `companies`, call `harvest-get-clients` with `name.contains` set to it. A lead whose company has an exact or loose match is "has client". If a lead has no company, list it separately as "no company on lead".
**Step 3: Report**
Give a table of leads with no Harvest client: lead number and name, company, value, closed date, owner. Then list the leads 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 Nutshell tools (names starting nutshell-) come from the nutshell server. Both servers must be connected.
* Nutshell calls customers companies or accounts 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 `nutshell-add-company`, `nutshell-add-person`, `nutshell-add-lead`, `nutshell-add-activity`, `nutshell-update-person`, `nutshell-update-lead`, `nutshell-update-company`, `nutshell-delete-person`, `nutshell-delete-company` or `nutshell-delete-lead`.
* Hourly rates, cost rates and invoice amounts are sensitive: show them only because the user asked for billing context.
**Validation:**
* If no leads 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 coordinators
Set up clients before the first invoice
You get a short list of won leads that still need a Harvest client, with the details needed to create one.
Which Nutshell leads were won in the last 30 days with no client in Harvest?
Sales operations
Close the handoff between sales and billing
You can check that every closed lead made it to billing and chase the owner of any that did not.
Show me won leads from this quarter whose company is not a Harvest client, with the lead owner.
Finance managers
Catch revenue that has not started billing
Won value with no client is visible in one list, so late billing is caught before it affects cash flow.
Which won Nutshell leads over 10,000 in October are missing a Harvest client?
How it works
What PopdockAI does when you ask
You set the won period and your AI assistant reads Nutshell 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 leads won in Nutshell in that period.
Check
It looks for each company among the Harvest clients by name.
Report
You get leads that need a client, leads that already have one and leads with no company, with counts.
What PopdockAI provides
The tools behind the answer
Ready made tools for Nutshell and one secure connection to your AI tool. No code, no exports.
nutshell-get-lead
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
Every won customer ready to be billed
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)
